Nulls in columns are giving my On Time/ Late calculations an error

I am creating a On time/Late column for a spread sheet that calculates time difference. I have this formula to calculate three things if something is on time, late or no value because a date wasn't entered or time is missing. I have cells that NULL in those place everything calculates correct except for the No value because of my formula. =IF(W2 = "#VALUE!", "No Value", IF(AB2>V2, "Late","On Time")) I am trying to tweak it so that even though there are NULLs that are in AB2 and V2 that it should still return No value.

I have a sort of working formula Its just not working for give me the answer of No value.
=IF(Y2:AB2 = "NULL", "No Value",IF(S2:V2 ="NULL", "No Value", IF(W2 = "#VALUE!", "No Value",IF(AB2>V2, "Late","On Time"))))
When this formula runs it says that it is the wrong data type.

Can you post a sample workbook? It's easier for someone to assist you if they actually see what data you're working with.

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.

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"