Getting Error on Formula - #INCORRECT ARGUMENT SET

I am getting an error on the formula I have entered saying #INCORRECT ARGUMENT SET

=IF(AND([EHS COVID Approved]@row = "Yes", [ExComm Travel Approved?]@row = "Yes", "[email protected]"))

Basically it is not inputting the [email protected] email as the answer if the 2 conditions are met... not sure what I am doing wrong.... I used the following as just an "IF" statement and worked in another cell, but when I did the "IF/AND" together it is not working to put an email in...

=IF([EHS COVID Approved]@row = "Yes", "[email protected]") - This one worked.

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    It is just a misplaced parenthesis. The AND function needs to be closed off before proceeding to the "output if true" portion of the IF function.

    =IF(AND([EHS COVID Approved]@row = "Yes", [ExComm Travel Approved?]@row = "Yes"), "[email protected]")

    Come see me at ENGAGE 2023! I have "Happy to help 👍️" buttons!

    If you can't find me roaming the floor, I will most likely be at the 10xViz Partner Booth.