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
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
135
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 4053 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
51394
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
February 5, 2020
14,211
Hey Marcílio

Another one bites the dust! Good work!