IF then using multiple cells and words
Solved/Closed
Related:
- IF then using multiple cells and words
- Allow multiple downloads chrome - Guide
- Photoshop multiple selections - Guide
- How to delete multiple files on mac - Guide
- Instagram can't login multiple devices - Instagram Forum
- If cell contains date then return value ✓ - Excel Forum
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
May 11, 2017 at 02:50 PM
May 11, 2017 at 02:50 PM
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
47310
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
February 15, 2023
11,165
May 11, 2017 at 05:02 PM
May 11, 2017 at 05:02 PM
Hey Marcílio
Another one bites the dust! Good work!
Another one bites the dust! Good work!
May 11, 2017 at 04:56 PM
May 22, 2017 at 03:53 PM