Results 1 to 3 of 3

Thread: the empty condition not working properly

  1. #1

    the empty condition not working properly



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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 12:47 AM. Reason: typying error on text

  2. #2
    It should be =IF(D9="","",(IF(D9<NOW(),"LATE","")))
    you are missing a comma.

  3. #3
    Many thanks.....so silly, me. Thanks

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •