I have been using the AND function in my spreasheet and it has been working
great until now, when my conditions to be tested have increased to 35. AND
Will only evaluate 30 conditions. What can I do to evaluate all of them?
Formula I have been using is below:

=IF(AND(H11="",I11="",J11="",K11="",L11="",M11="", N11="",O11="",P11="",Q11="",R11="",S11="",T11="",U 11="",V11="",W11="",X11="",Y11="",Z11="",AA11="",A B11="",AC11="",AD11="",AE11="",AF11=""),0,LOOKUP(L ARGE(H11:AL11,1),H11:AL11,$H$8:$AL$8))

Try this alternative

=IF(COUNT(H11:AF11)<25,0,LOOKUP(LARGE(H11:AL11,1) ,H11:AL11,$H$8:$AL$8))

Mike

"bevchapman" wrote:

I have been using the AND function in my spreasheet and it has been working
great until now, when my conditions to be tested have increased to 35. AND
Will only evaluate 30 conditions. What can I do to evaluate all of them?
Formula I have been using is below:

=IF(AND(H11="",I11="",J11="",K11="",L11="",M11="", N11="",O11="",P11="",Q11="",R11="",S11="",T11="",U 11="",V11="",W11="",X11="",Y11="",Z11="",AA11="",A B11="",AC11="",AD11="",AE11="",AF11=""),0,LOOKUP(L ARGE(H11:AL11,1),H11:AL11,$H$8:$AL$8))

Try this:

=IF(COUNTBLANK(H11:AL11),0,LOOKUP(MAX(H11:AL11),H8 :AL8))

--
Biff
Microsoft Excel MVP


"bevchapman" wrote in message
...
I have been using the AND function in my spreasheet and it has been working
great until now, when my conditions to be tested have increased to 35.
AND
Will only evaluate 30 conditions. What can I do to evaluate all of them?
Formula I have been using is below:

=IF(AND(H11="",I11="",J11="",K11="",L11="",M11="", N11="",O11="",P11="",Q11="",R11="",S11="",T11="",U 11="",V11="",W11="",X11="",Y11="",Z11="",AA11="",A B11="",AC11="",AD11="",AE11="",AF11=""),0,LOOKUP(L ARGE(H11:AL11,1),H11:AL11,$H$8:$AL$8))