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
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