Streamlining a long IF=(AND formula ??

D

David.Allen297

Hi all,

I'm new to Excel and have at last written a formula that works! :)

My problem is that it is extremely long and I want to shorten it t
speed up resources on my slow PC which has a hundred of these formula
on a single sheet.

Can anyone shorten this:

=IF(AND(R2="ON",E2="YES I
IS",F5<=G26,F6>=M26,F7>=M26,F8>=M26,F9>=M26,F10>=M26,F11>=M26,F12>=M26,F13>=M26,F14>=M26,F15>=M26,F16>=M26,F17>=M26,F18>=M26,F19>=M26,F20>=M26,F21>=M26,F22>=M26,F23>=M26,F24>=M26),"D
IT","NOT YET")

Thanks,

Dav
 
R

Roger Govier

Hi David

Since you are testing that all of the range F6:F4 have to be >=M26, you
could replace all of those tests with a single MIN() test

=IF(AND(R2="ON",E2="YES IT IS",F5<=G26,MIN(F6:F24)>=M26),"DO IT","NOT YET")


Regards

Roger Govier
 

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

Top