=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