Subject: RE: $$Excel-Macros$$ $$Excel-Macro$$ - Optimize Formula
Date: Mon, 1 Aug 2011 12:50:31 +0800
Hi,
Try this:
=IF(A5<=$T$5,$S$5,IF(A5<=$T$6,$S$6,IF(A5<=$T$7,$S$7,IF(A5<=$T$8,$S$8,IF(A5<=$T$9,$S$9,IF(A5<=$T$10,$S$10,""))
The multiple IF statement
2011 17:50:12 -0700
> Subject: $$Excel-Macros$$ $$Excel-Macro$$ - Optimize Formula
> From: velocity...@gmail.com
> To: excel-macros@googlegroups.com
>
> Any help in shortening or optimizing this formula would be great. Im
> limited by the nested if statements to match week numbers (colu
Any help in shortening or optimizing this formula would be great. Im
limited by the nested if statements to match week numbers (column s)
and week ended date (Column T), and continue to bog down the
recalculations. It does work, but slows things down.I'm using it
to determine if a date falls
