Nested IF(AND Formula Error Message

**wesley.mitchell** · 01-27-2010, 01:49 PM

I am entering the following Nested IF(AND statement into a cell and getting a message stating "You've entered too many arguments for this function." Any idea on what formula I can use to get the needed information into this cell based on the fact that there are different inputs that can be entered into the related cell that will trigger the needed respons in the working cell?

=IF(AND(K1051="Down",L1051<2),"Yes","",IF(AND(K1051="Partially Down",L1051<2),"Yes",""))

Thank you in advance and have a great day!

Wes Mitchell

**NBVC** · 01-27-2010, 02:02 PM

You don't need the middle "" part...

=IF(AND(K1051="Down",L1051<2),"Yes",IF(AND(K1051="Partially Down",L1051<2),"Yes",""))

or since both have same results....

=IF(OR(AND(K1051="Down",L1051<2),AND(K1051="Partially Down",L1051<2)),"Yes","")

or

=IF(AND(ISNUMBER(SEARCH("Down",K1052)),L1052<2),"Yes","")

or

=IF(AND(RIGHT(K1052,4)="Down",L1052<2),"Yes","")

**wesley.mitchell** · 01-27-2010, 06:19 PM

NBVC,

Thank you for the assistance with this! After inputting your formula and making a few small changes (that I had wrong in the formula from the start) I was able to get the result that I was looking for. This was a big help and has kept me from banging my head against the wall.

Thanks again and have a great day!

Wes Mitchell