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
-
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.
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"), "[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.
-
Awesome, thank you, it worked ...
-
Happy to help. 👍️
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.