Prev: Date calculation
Next: standard error of regression coefficient
From: Turki755 on 2 Nov 2009 06:44
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
From: "David Biddulph" groups [at] on 2 Nov 2009 07:31
=A1*(A$5/A$1)^(1/(ROW(A$5)-ROW(A$1))) in A2, & copy down
--
David Biddulph

"Turki755" <Turki755(a)discussions.microsoft.com> wrote in message
news:162C2D51-1C89-45F5-9DF4-1733F274E50B(a)microsoft.com...
> 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


From: Gary''s Student on 2 Nov 2009 08:09
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
 | 
Pages: 1
Prev: Date calculation
Next: standard error of regression coefficient