Evaluating more than 30 conditions using a formula


B

bevchapman

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="",U11="",V11="",W11="",X11="",Y11="",Z11="",AA11="",AB11="",AC11="",AD11="",AE11="",AF11=""),0,LOOKUP(LARGE(H11:AL11,1),H11:AL11,$H$8:$AL$8))
 
Ad

Advertisements

M

Mike H

Try this alternative

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

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top