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", "jeff.shepherd@advance-auto.com"))
Basically it is not inputting the Jeff.Shepherd@advance-auto.com 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", "Jason.Reichert@advance-auto.com") - This one worked.
Best 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"), "jeff.shepherd@advance-auto.com")
Answers
-
It is basically showing me to pick a "Select a Contact" with the error... but then if I do, the formula disappears and the contact name then stays... trying to have it auto populate with the name/email if the 2 conditions are met
-
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"), "jeff.shepherd@advance-auto.com")
-
Awesome, thank you, it worked ...
-
Happy to help. 👍️
