I have spent more time than I'd like on this formula. I keep getting a #Incorrect argument set error. I would like to provide different direction based on when specific columns have a yes answer. It was working fine until I added the final column Used to Provide Information - Handout. Now I can't get the formula to work using the following:
=IF(AND(ISBLANK([Is Form]@row), ISBLANK([Is Publication]@row), ISBLANK([On Letterhead]@row), ISBLANK([Has Logo with Name]@row), ISBLANK([Used to Provide Information - Handout]@row)), " ", IF(OR([Is Form]@row = "Yes", [Is Publication]@row = "Yes", [On Letterhead]@row = "Yes", [Has Logo with Name]@row = "Yes"), "Name must be updated.", IF([Used to Provide Information - Handout]@row = "Yes"), "Please use an approved header with only the seal. More information to come.", IF(OR([Is Form]@row = "No", [Is Publication]@row = "No", [On Letterhead]@row = "No", [Has Logo with Name]@row = "No", [Used to Provide Information - Handout]@row = "No"), "If the name is present, it can be removed.")))
Basically it should work like this:
If any of the fields are blank don't show anything.
If any of the fields say yes except the handout field say "Name must be updated."
If the handout field says yes say "Please use an approved header with only the seal. More information to come."
If all fields say no say "If the name is present, it can be removed."
How can I accomplish this?
