Conditional Formulat with #ous condiitions
Solved/Closed
Related:
- Conditional Formulat with #ous condiitions
- Apply conditional formatting to the selected cells ✓ - Excel Forum
- Conditional formatting 3 color scale percentages ✓ - Excel Forum
- Conditional hyperlink excel ✓ - Excel Forum
- Conditional formatting based on date ✓ - Excel Forum
- Conditional formatting with 4 IF statements - Office Software 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 January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 18, 2010 at 12:33 PM
Feb 18, 2010 at 12:33 PM
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 January 28, 2010
Status
Contributor
Last seen
May 5, 2022
Feb 19, 2010 at 07:57 AM
Feb 19, 2010 at 07:57 AM
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
