It should be =IF(D9="","",(IF(D9<NOW(),"LATE","")))
you are missing a comma.
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 by toony; 2014-03-13 at 01:47 AM. Reason: typying error on text
It should be =IF(D9="","",(IF(D9<NOW(),"LATE","")))
you are missing a comma.
Many thanks.....so silly, me. Thanks
Bookmarks