IF then using multiple cells and words
Solved/Closed
Related:
- IF then using multiple cells and words
- Mpc hc multiple instances - Guide
- Based on the values in cells b77 b88 ✓ - Excel Forum
- How to make multiple selections in photoshop - Guide
- If a cell has text then return value ✓ - Excel Forum
- How to rotate multiple pictures at once windows 10 - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
11 May 2017 à 14:50
11 May 2017 à 14:50
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
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
Ambucias
Posts
47311
Registration date
Monday 1 February 2010
Status
Moderator
Last seen
15 February 2023
11,166
11 May 2017 à 17:02
11 May 2017 à 17:02
Hey Marcílio
Another one bites the dust! Good work!
Another one bites the dust! Good work!
11 May 2017 à 16:56
22 May 2017 à 15:53