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
1950
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
January 9, 2022
148
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 so much. This works great.
0

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?
0
Posts
47366
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
September 1, 2021
11,368
Hey Marcílio

Another one bites the dust! Good work!
0