Range of numbers equation
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
|