IF then using multiple cells and words [Solved]

Ask a question Matt Louisiana - Last answered on May 22, 2017 at 03:53 PM by Matt Louisiana
D3,D4,D5 that all need to say either 'Compliant' or 'N/A', for result in E3 to say "yes", else "No".
Please help.

plus moins
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?  
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?
Leave a comment
plus moins
Hey Marcílio

Another one bites the dust! Good work!
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!