Shorten formulas

[VBABEGINER]

Dear All,

Pls help me re-design / minimize this formula, if any possibility..

This is one..

=IFERROR(IF((((IFERROR(Z11-Y11,0))+(IFERROR(AA11-Z11,0))+(IFERROR(AB11-AA11,0))+(IFERROR(AC11-AB11,0))+(IFERROR(AD11-AC11,0)))/5)/(AVERAGEIF(Y11:AD11,"<>#N/A"))>0.1, "Up",IF((((IFERROR(Z11-Y11,0))+(IFERROR(AA11-Z11,0))+(IFERROR(AB11-AA11,0))+(IFERROR(AC11-AB11,0))+(IFERROR(AD11-AC11,0)))/5)/(AVERAGEIF(Y11:AD11,"<>#N/A"))<-0.1, "Down","Stable")),"")

This is second..

=IFERROR(IF(AD11=0,"Below Control",IF(AD11>(AVERAGE(IF(NOT(ISNA(W11:AC11)),W11:AC11,"")))+(2*STDEV.P(IF(NOT(ISNA(W11:AC11)),W11:AC11,""))),"Over Control",IF(AD11<(AVERAGE(IF(NOT(ISNA(W11:AC11)),W11:AC11,"")))-(2*STDEV.P(IF(NOT(ISNA(W11:AC11)),W11:AC11,""))),"Below Control","Within Control"))),"")

And, last one..

=IFERROR(IF(N11=0," 0 Flag",IF((N11/((M11+L11)/2)-1)>0.125,"+ Flag",IF((N11/((M11+L11)/2)-1)<-0.125,"- Flag",""))),"")

Additionally, appreciate you all in advance, if you can suggest me how to down / reduce excel workbook size...methods..

Please suggest, that will be great help..

Thanks..

 

[VBABEGINER]

Any help, would appreciate a lot..

 

[VBABEGINER]

Any help on this please..

Dear All,

Pls help me re-design / minimize this formula, if any possibility..

This is one..



This is second..


And, last one..



Additionally, appreciate you all in advance, if you can suggest me how to down / reduce excel workbook size...methods..

Please suggest, that will be great help..

Thanks..