Spread numbers by setting up a Min and Max

[Turki755]

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

 

[David Biddulph]

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

 

[Gary''s Student]

In A2 enter:
=A1*10 and copy downward