Is there a way to find the lowest & highest number in a range of columns, and
perform a calculation on them, e.g. %change (to-fm)/fm% Thanks

What relationship do "to" and "fm" have to the lowest and highest number?

If "to" is the lowest number in columns A:J, and "fm" is the highest
number in columns A:J:

=MIN(A:J)/MAX(A:J) - 1

formatted as a percentage.

In article ,
"nastech" wrote:

Is there a way to find the lowest & highest number in a range of columns, and
perform a calculation on them, e.g. %change (to-fm)/fm% Thanks

thanks!

"JE McGimpsey" wrote:

What relationship do "to" and "fm" have to the lowest and highest number?

If "to" is the lowest number in columns A:J, and "fm" is the highest
number in columns A:J:

=MIN(A:J)/MAX(A:J) - 1

formatted as a percentage.

In article ,
"nastech" wrote:

Is there a way to find the lowest & highest number in a range of columns, and
perform a calculation on them, e.g. %change (to-fm)/fm% Thanks

thanks again. :) that was good, found that a similar equation I have, is
using up alot of memory in my file. Equation is for same range, but using
"choices" of 2, 3, or 4 periods of input (so I repeated the same equation, 4
times: 1st time is if end of day: 1st column emptied): was wondering if
there might be a simpler way to calculate? thanks

=IF(AK9="","",
IF(AND(AL9<"",COUNTA(AL9:AM9)<0,OR($O$2={"",".", 2})),IF(AK9AVERAGE(AL9:AM9),"U",IF(AK9<AVERAGE(AL 9:AM9),"D","F")),
IF(AND(COUNTA(AM9:AN9)<0,OR($O$2={"",".",2})),IF( AK9AVERAGE(AM9:AN9),"U",IF(AK9<AVERAGE(AM9:AN9)," D","F")),
IF(AND(COUNTA(AL9:AN9)<0,$O$2=3),IF(AK9AVERAGE(A L9:AN9),"U",IF(AK9<AVERAGE(AL9:AN9),"D","F")),
IF(AND(COUNTA(AL9:AO9)<0,$O$2=4),IF(AK9AVERAGE(A L9:AO9),"U",IF(AK9<AVERAGE(AL9:AO9),"D","F")),"")) )))



"JE McGimpsey" wrote:

What relationship do "to" and "fm" have to the lowest and highest number?

If "to" is the lowest number in columns A:J, and "fm" is the highest
number in columns A:J:

=MIN(A:J)/MAX(A:J) - 1

formatted as a percentage.

In article ,
"nastech" wrote:

Is there a way to find the lowest & highest number in a range of columns, and
perform a calculation on them, e.g. %change (to-fm)/fm% Thanks