Forum Discussion
Nested IF Function
Hi - I'm looking for help!
I'm trying to write a nested IF function to return in cell S9 either-
- "Early" if the date in Q9 is less than the date in P9
- "Late" if the date in Q9 is more than the date in P9
- returns blank if there is no date in Cell Q9
The formula I am writing is - =IF((Q9>P9),"Late"),IF((Q9<P9),"Early"),IF(ISBLANK(Q9),"")
I am getting a #Value error for some reason!
Thanks in advance
=IF(OR(P9:Q9=""), "", IF(Q9<=P9, "Early", "Late"))
- Hi Hans - Great thanks for that, appreciated!
