IF then using multiple cells and words [Solved]

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

4 replies

Reply to this topic
Mazzaropi 1826 Posts Monday August 16, 2010Registration dateContributorStatus April 15, 2018 Last seen - May 11, 2017 at 02:50 PM
+1
Helpful
2
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
Was this answer helpful?  
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?
Respond to Mazzaropi
Ambucias 51189 Posts Monday February 1, 2010Registration dateModeratorStatus April 26, 2018 Last seen - May 11, 2017 at 05:02 PM
0
Helpful
Hey Marcílio

Another one bites the dust! Good work!
Respond to Ambucias