IF then using multiple cells and words

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

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
1
Matt Louisiana
May 11, 2017 at 04:56 PM
Thank you so much. This works great.
0
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?
0
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!
0