how to get return value yes or no in excel if statement when either of two cells is blank?
how to get return value yes or no in excel if statement when either of two cells is blank?
R
If your cells are A1 and A2 say, you use the OR function within the test argument of the IF. Here I've also used the ISBLANK function to test those cells:
=IF(OR(ISBLANK(A1),ISBLANK(A2)),"Yes","No")
You just need to change the cell references to suit.
Hope this works for you.