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 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,F16>=M26,F17>=M26,F18>=M26,F19>=M26,F20>=M26,F21>=M26,F22>=M26,F23>=M26,F24>=M26),"DO IT","NOT YET")

Thanks,

Dave

[paul]

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>=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),"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
>
>

[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



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,F16>=M26,F17>=M26,F18>=M26,F19>=M26,F20>=M26,F21>=M26,F22>=M26,F23>=M26,F24>=M26),"DO
>IT","NOT YET")
>
>Thanks,
>
>Dave
>
>
>
>