IF then using multiple cells and words [Solved/Closed]

Report
-
 Matt Louisiana -
Hello,
D3,D4,D5 that all need to say either 'Compliant' or 'N/A', for result in E3 to say "yes", else "No".
Please help.



2 replies

Posts
1923
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 29, 2021
143
Matt Louisiana, Good afternoon.

You can do a combination of IF, AND and OR functions to solve this.

E3 --> =IF(AND(OR(D3="Compliant",D3="N/A"),OR(D4="Compliant",D4="N/A"),OR(D5="Compliant",D5="N/A")),"YES","NO")

In EXCEL you always have several ways to solve the same question.

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month


Thank you so much. This works great.

Belo,Horizonte. I would like D3,D4,D5 to default to 'Not Reviewed' and E3 to default to 'blank' (no text). Can you help please?
Posts
47365
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
June 2, 2021
10,459
Hey Marcílio

Another one bites the dust! Good work!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!