IF Statement help

[Treynic]

Hello, new guy here!
Its a little "bug" if you will or I dont know how to properly write the formula.

Basically, I want that status cell to read "On Schedule" if the delivery date is blank. But its giving me early, because technically the value of it being blank is less than the due date.
=IF([@[Delivery Date]]=[@[Due Date]],"On Time",IF([@[Delivery Date]]<[@[Due Date]],"Early",IF([@[Delivery Date]]>[@[Due Date]],"Late",IF(C2="","On Schedule",""))))

Hoping someone can point out where I went wrong or where to correct.

Thanks!

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF([@[Delivery Date]]="","On Schedule",IF([@[Delivery Date]]=[@[Due Date]],"On Time",IF([@[Delivery Date]]<[@[Due Date]],"Early","Late")))

 

[Treynic]

Hi & welcome to MrExcel.
How about

=IF([@[Delivery Date]]="","On Schedule",IF([@[Delivery Date]]=[@[Due Date]],"On Time",IF([@[Delivery Date]]<[@[Due Date]],"Early","Late")))

Thanks Fluff! I over thought it, I forgot about about the truth false statement as a whole at the end of Delivery<Due.
Thank you!

 

[Fluff]

Glad to help & thanks for the feedback.