error with formula for time difference calculation

[AvidanR]

Here is an example of the error i get when I am trying to get in the On Time/Late column for it to say "No Value". The cells that say NULL should say NULL and in the Originally Shipped column it should have the error because it is pulling data from the cells that say NULL.

[AvidanR]

obviously that last bit of the formula works because I have other data that comes up as late or on time its just that when I have a #VALUE! i need it to say "No Value"

[leelnich]

Hi ArvidanR- Try this in J2:
=IF(ISERROR(D2-I2), "No Value",IF(I2>D2, "Late","On Time"))

or:
=IFERROR(IF(D2-I2<0, "Late","On Time"), "No Value")

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

[AvidanR]

Thank you this hit the nail on the head.

[leelnich]

Happy to help! If your requirements are met, please go to Thread Tools up top and mark your thread as SOLVED. Thanks - Lee

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

[AliGW]

Duplicate thread closed. Continue here, please: https://www.excelforum.com/excel-gen...correctly.html