IF then using multiple cells and words

Matt Louisiana - May 11, 2017 at 12:45 PM
 Matt Louisiana - May 22, 2017 at 03:53 PM
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

Mazzaropi Posts 1967 Registration date Monday August 16, 2010 Status Contributor Last seen October 3, 2022 146
May 11, 2017 at 02:50 PM
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
Matt Louisiana
May 11, 2017 at 04:56 PM
Thank you so much. This works great.
Matt Louisiana
May 22, 2017 at 03:53 PM
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?
Ambucias Posts 47359 Registration date Monday February 1, 2010 Status Moderator Last seen September 1, 2021 11,252
May 11, 2017 at 05:02 PM
Hey Marcílio

Another one bites the dust! Good work!