Streamlining a long IF=(AND formula ??
 

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 to
speed up resources on my slow PC which has a hundred of these formulae
on a single sheet.

Can anyone shorten this:

=IF(AND(R2="ON",E2="YES IT
IS",F5<=G26,F6=M26,F7=M26,F8=M26,F9=M26,F10=M 26,F11=M26,F12=M26,F13=M26,F14=M26,F15=M26,F1 6=M26,F17=M26,F18=M26,F19=M26,F20=M26,F21=M2 6,F22=M26,F23=M26,F24=M26),"DO
IT","NOT YET")

Thanks,

Dave


--
David.Allen297
------------------------------------------------------------------------
David.Allen297's Profile: http://www.excelforum.com/member.php...o&userid=27820
View this thread: http://www.excelforum.com/showthread...hreadid=473307

its your criteria that needs streamlining!!!!!
--
paul
remove nospam for email addy!



"David.Allen297" wrote:


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 to
speed up resources on my slow PC which has a hundred of these formulae
on a single sheet.

Can anyone shorten this:

=IF(AND(R2="ON",E2="YES IT
IS",F5<=G26,F6=M26,F7=M26,F8=M26,F9=M26,F10=M 26,F11=M26,F12=M26,F13=M26,F14=M26,F15=M26,F1 6=M26,F17=M26,F18=M26,F19=M26,F20=M26,F21=M2 6,F22=M26,F23=M26,F24=M26),"DO
IT","NOT YET")

Thanks,

Dave


--
David.Allen297
------------------------------------------------------------------------
David.Allen297's Profile: http://www.excelforum.com/member.php...o&userid=27820
View this thread: http://www.excelforum.com/showthread...hreadid=473307

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



David.Allen297 wrote:

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 to
speed up resources on my slow PC which has a hundred of these formulae
on a single sheet.

Can anyone shorten this:

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

Thanks,

Dave