Streamlining a long IF=(AND formula ??

[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

 

[Guest]

its your criteria that needs streamlining!!!!!

 

[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