Range of numbers equation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
thanks!

JE McGimpsey said:
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.
Click to expand...
 
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(AK9>AVERAGE(AL9:AM9),"U",IF(AK9<AVERAGE(AL9:AM9),"D","F"))
IF(AND(COUNTA(AM9:AN9)<>0,OR($O$2={"",".",2})),IF(AK9>AVERAGE(AM9:AN9),"U",IF(AK9<AVERAGE(AM9:AN9),"D","F"))
IF(AND(COUNTA(AL9:AN9)<>0,$O$2=3),IF(AK9>AVERAGE(AL9:AN9),"U",IF(AK9<AVERAGE(AL9:AN9),"D","F"))
IF(AND(COUNTA(AL9:AO9)<>0,$O$2=4),IF(AK9>AVERAGE(AL9:AO9),"U",IF(AK9<AVERAGE(AL9:AO9),"D","F")),"")))))
 
Back
Top