IF(OR Statement giving #unparseable, using ; or , ?

05/30/20 Edited 06/03/20
Accepted

Please help. I keep getting #unparseable error for the following formula:


=IF(OR([DLExpiration Date]1 > TODAY(); [MECExpiration Date]1 > TODAY()); "NON COMPLIANT"; "COMPLIANT")


I want the cell in my Status column to display as NON COMPLIANT or COMPLIANT if today's date is greater than the dates in columns DLExpiration Date or MECExpirtion Date.

Best Answer

Answers

  • Hi Lisa,

    I see that my response answered your question, which is great! I hope you don't mind but I've adjusted the title of your question to help other users who may have the same question find the answer.

    Cheers,

    Genevieve

Sign In or Register to comment.