Nested Ifs, 3 ANDS condition

[Lifeseeker]

Hi,

I have this logical condition set up, but it's partially working and I dont' know how to get around it.

=IF(H4="y",IF(J4="y",IF(L4="y",IF(ISTEXT(Q4),"Yes","No"))))

It's testing 4 fields. What I want is.....if all 3 fields are "y" AND the Q4 has text in the cell, then I want this formula to return "Yes". Otherwise, return "No".

When I run this formula, it seems that it's only looking at the last if and ignoring the previous 3 fields.

For example....if I change H4 to "n", the formula would return "False" instead of "No". If I delete Q4 cell value, formula does return "No".

Can anyone point in the right direction please?

Thank you

[tigeravatar]

Lifeseeker,

Try using the AND() function:
=IF(AND(H4="y",J4="y",L4="y",ISTEXT(Q4)),"Yes","No")

[Richard Buttrey]

One way,

Please Login or Register  to view this content.

Regards

[tlafferty]

Please Login or Register  to view this content.

[Lifeseeker]

Please Login or Register  to view this content.

ah yes, I actually tested it out by myself as well and I was going to delete the post...lol

=IF(AND(H4="y",J4="y",L4="y",ISTEXT(Q4)), "Yes", "No")

Thank you all