Adding more variables to my IF formula

Hello,

I have the formulae =IF(COUNTBLANK(M2)=0,IF(M2>K2, "Late", "On Time"))

This is returning the text "Late" or "On Time", if the date in cell M2 is greater than the date in cell K2, only if there is actually a date entered in M2. If there is no date in M2, it leaves the cell with the formulae above as "FALSE". (Ideally I would like to just leave it blank but can't figure that out).

Now I want to extend the formulae, and say if M2<K2 (LESS THAN), then it returns the value of "Early". I tried to add to the formulae above but it's not picking up the first part of the formula, to say "FALSE" it if there is no value in M2.

Thank you!
Kelly

perhaps this will work better for you... =IF(M2="","",IF(M2>K2, "Late", "On Time"))

Unless there is something in M2 that you don't see, such as a space, that formula change should return blank.
Now, if you want early instead of on time then this change should work for you... =IF(M2="","",IF(M2>K2, "Late", "Early"))
if it doesn't return a blank when M2 is blank then try this in another blank cell to see what it returns... =ISBLANK(M2)
if that returns TRUE then there is something else wrong and posting a sample workbook (instructions at the top of the page) would help - with expected results even if you hand enter them.

By the way, is there a circumstance where you still want the outcome to be "On Time"? You'll have to explain that so I (we) can see how to fit it into the formula.

The only option I can think of is if M2 is equal to K2 where On Time might be the option.
So maybe this... =IF(M2="","",IF(M2=K2,"On Time",IF(M2>K2, "Late", "Early")))

Great, glad I could help. Thank for marking the post as solved And thank you for the rep!