IF then using multiple cells and words [Solved/Closed]

Matt Louisiana - May 11, 2017 at 12:45 PM - Latest reply:  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.

See more 

4 replies

Best answer
Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - May 11, 2017 at 02:50 PM
Thank you
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

Thank you, Mazzaropi 1

Something to say? Add comment

CCM has helped 1673 users 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?
Ambucias 53296 Posts Monday February 1, 2010Registration dateModeratorStatus July 21, 2018 Last seen - May 11, 2017 at 05:02 PM
Thank you
Hey Marcílio

Another one bites the dust! Good work!