Conditional Formulat with #ous condiitions
Solved/Closed
Related:
- Conditional Formulat with #ous condiitions
- Excel conditional formatting based on date - Guide
- Conditional formatting if cell contains text - Excel Forum
- Ous download - Download - Musical
- Conditional formatting between two values ✓ - Excel Forum
- Highlight cell if another cell contains any text ✓ - Excel Forum
2 responses
Hi Pia,
You start your formula with this: =IF(X2="Y","Y"
It means that if X2 contains an "Y", your formula cell will contain an "Y" as well no matter what comes next in your formula.
Try this formula instead:
=IF(X2="Y",IF(Y2="Y",IF(Z2="Y",IF(AA2="Y",IF(AB2="Y",IF(AC2="Y","Y","N"),"N"),"N"),"N"),"N"),"N")
Best regards
Trowa
You start your formula with this: =IF(X2="Y","Y"
It means that if X2 contains an "Y", your formula cell will contain an "Y" as well no matter what comes next in your formula.
Try this formula instead:
=IF(X2="Y",IF(Y2="Y",IF(Z2="Y",IF(AA2="Y",IF(AB2="Y",IF(AC2="Y","Y","N"),"N"),"N"),"N"),"N"),"N")
Best regards
Trowa
Wow, that did it. Thanks so much, you just saved me so much grief!
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
18 Feb 2010 à 12:33
18 Feb 2010 à 12:33
Just curious, why do you want so many if ?
=IF(X2 & Y2 & Z2 & AA2 & AB2 & AC2 = "", "", IF(X2 & Y2 & Z2 & AA2 & AB2 & AC2 = "YYYYYY", "Y", "N"))
=IF(X2 & Y2 & Z2 & AA2 & AB2 & AC2 = "", "", IF(X2 & Y2 & Z2 & AA2 & AB2 & AC2 = "YYYYYY", "Y", "N"))
Trowa
>
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
19 Feb 2010 à 07:57
19 Feb 2010 à 07:57
Nice rizvisa1, didn't know that was possible.
And let me thank you on behalf of this forum for the time your taking to help others. Your name is all over this place :).
Keep it up.
Best regards,
Trowa
And let me thank you on behalf of this forum for the time your taking to help others. Your name is all over this place :).
Keep it up.
Best regards,
Trowa
