I am trying to use a IF statement to return one of 3 results but can't figure it out. Thanks for any help.
If the cell date is prior to the set date, enter the number 1.
If the cell date is after the set date, enter the number 0.
If the cell is blank, do nothing.
Example:
Set date = 11/1/2017, located in cell A4.
Cell to be evaluated is located in B5.
Formula entered into cell C5.
If B5 is blank, how do I get C5 to also be blank? I've tried:
1) IF(B5<A4,1,0), IF(B5="","",??)
Bookmarks