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 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
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 47356 Registration date Monday February 1, 2010 Status Moderator Last seen February 15, 2023 11,166
May 11, 2017 at 05:02 PM
Hey Marcílio

Another one bites the dust! Good work!