Forum Discussion
Chris_Mercer
Feb 26, 2024Copper Contributor
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 da...
HansVogelaar
Feb 26, 2024MVP
=IF(OR(P9:Q9=""), "", IF(Q9<=P9, "Early", "Late"))
Chris_Mercer
Feb 26, 2024Copper Contributor
Hi Hans - Great thanks for that, appreciated!