the empty condition not working properly

toony

New member
Joined
Mar 6, 2014
Messages
49
Reaction score
0
Points
0
Location
UK
Excel Version(s)
Excel 2016
I have entered formula IF(D9<NOW(),"LATE",""), but if D9 cell is empty, it still says "LATE", which I don't know why. So, I tried IF(D9="",""(IF(D9<NOW(),"LATE","") but the cell then gives me a VALUE error. Can somebody hep me?
 
Last edited:

peter.abing

New member
Joined
Oct 24, 2012
Messages
34
Reaction score
0
Points
0
It should be =IF(D9="","",(IF(D9<NOW(),"LATE","")))
you are missing a comma.
 

toony

New member
Joined
Mar 6, 2014
Messages
49
Reaction score
0
Points
0
Location
UK
Excel Version(s)
Excel 2016
Many thanks.....so silly, me. Thanks
 
Top