Nested IF Function

[Chris_Mercer]

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

[#2]

@Chris_Mercer 

=IF(OR(P9:Q9=""), "", IF(Q9<=P9, "Early", "Late"))

[#3]

Hi Hans - Great thanks for that, appreciated!