Conditional Formulat with #ous condiitions Solved/Closed

Question

Hello,

I have to write a formula to account for 6 conditions from 6 different columns.  Originally, I thought it could be done by a simple nested IF formula, but it's not working.

Each column is simply recording a Yes or No response in the form of Y or N.  The calculation in essence should try to determine or COUNT only those rows in which all six columns have a Y response.  Anytime there is a N response in even one column, it should also result in a N response.  With the nested IF formula, it kept saying Y for everything (even when a column had a No response).

=IF(X2="Y","Y",IF(Y2="Y","Y", IF(Z2="Y","Y",IF(AA2="Y","Y",IF(AB2="Y","Y",IF(AB="Y","Y","N"))))))

Thanks for any help!

Trowa · Answer

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

PIA · Answer

Wow, that did it.  Thanks so much, you just saved me so much grief!

Conditional Formulat with #ous condiitions

2 responses

Similar discussions

Subscribe To Our Newsletter!