Nested IF, AND formula
Hello,
Trying to get the conditions correct on a nested IF/AND formula in attached file.
The logic for cell B2 is as follows:
IF D2 is blank AND I2:I7 are blank, then B2 is blank
IF D2 is text AND I2:I7 has any blanks, then B2 is "N", else "Y"
Thanks for any help,
kdub
| Attachment | Size |
|---|---|
| IF_AND Post 31Jul13.xlsx | 17.05 KB |
Hi,
Here is your formula
=IF(AND(D2="",I2&I3&I4&I5&I6&I7=""),"",IF(AND(NOT(ISNUMBER(D2)),OR(I2="",I3="",I4="",I5="",I6="",I7="")),"N","Y"))
Hope this helps. Let me know how it goes
Jon
Hi Jon, I think it's almost
Hi Jon,
I think it's almost working, the only thing I see that I might not have made clear.
When D2 is blank AND I2:I7 are all not blank, D2 should be "N".
hen D2 is not blank AND I2:I7 are all not blank, D2 should be "Y".
Thx,
kdub