Spread numbers by setting up a Min and Max
 

Hi,

If I want to spread the numbers between two cells, lets say A1 is the
minimum of something and A5 is the maximum, what's the formula to do this?
For example, if A1 is 10 (minimum) and A5 is 100,000 (maximum), by using
such a formula, I will have like the following:
A2= 100, A3= 1,000, A4= 10,000

Thanks

Spread numbers by setting up a Min and Max
 

=A1*(A$5/A$1)^(1/(ROW(A$5)-ROW(A$1))) in A2, & copy down
--
David Biddulph

"Turki755" wrote in message
...
Hi,

If I want to spread the numbers between two cells, lets say A1 is the
minimum of something and A5 is the maximum, what's the formula to do
this?
For example, if A1 is 10 (minimum) and A5 is 100,000 (maximum), by using
such a formula, I will have like the following:
A2= 100, A3= 1,000, A4= 10,000

Thanks

Spread numbers by setting up a Min and Max
 

In A2 enter:
=A1*10 and copy downward
--
Gary''s Student - gsnu200908


"Turki755" wrote:

Hi,

If I want to spread the numbers between two cells, lets say A1 is the
minimum of something and A5 is the maximum, what's the formula to do this?
For example, if A1 is 10 (minimum) and A5 is 100,000 (maximum), by using
such a formula, I will have like the following:
A2= 100, A3= 1,000, A4= 10,000

Thanks