View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey
 
Posts: n/a
Default Range of numbers equation

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