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

- - Latest reply:  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.



See more 

2 replies

Best answer
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
130
1
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

Say "Thank you" 1

A few words of thanks would be greatly appreciated. Add comment

CCM 5907 users have said thank you to us 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?
Posts
51376
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
October 29, 2019
13223
0
Thank you
Hey Marcílio

Another one bites the dust! Good work!