hi there,

I have to create a formula in excel that will list 601 evenly spaced points in between the numbers (-2,10) and i have no clue how to go about this. Thanks for all the help! (Talking)

Printable View

- Aug 30th 2009, 04:21 PMmx15need help with excel formula
hi there,

I have to create a formula in excel that will list 601 evenly spaced points in between the numbers (-2,10) and i have no clue how to go about this. Thanks for all the help! (Talking) - Aug 30th 2009, 08:43 PMWilmer
- Aug 30th 2009, 09:38 PMaidan
for 1 evenly spaced point between -2 & 10

$\displaystyle \dfrac{10 - (-2)}{2}$ = 6

-2, -2+6*1, 10

or

-2, 4, 10

--

for**2**evenly spaced points

$\displaystyle \dfrac{10 - (-2)}{2+1}$ = 4

-2, -2+4*1, -2+4*2, 10

or

-2, 2, 6, 10

--

for**11**evenly spaced points

$\displaystyle \dfrac{10 - (-2)}{11 +1 }$ = 1

-2, -2+1*1, -2+1*2, -2+1*3, ... , 10

or

-2, -1, 0, 1, 2, 3, 4, ...

--

for**99**evenly spaced points

$\displaystyle \dfrac{10 - (-2)}{99 +1 }$ = 0.12

-2, -2+0.12*1, -2+0.12*2, -2+0.12*3, ... , 10

or

-2, -1.88, -1.76, -1.64, ...

--

There is a pattern.

For 601 evenly spaced points between -2 and 10, well, that is left as as exercise for the reader.

- Aug 30th 2009, 09:51 PMpickslides
put -2 in A1

put 10 in A603

put =A1+($A$603-$A$1)/602 in A2 and fill down to A602 - Aug 30th 2009, 09:53 PMpickslides
Each cell should grow by $\displaystyle 0.0199335548172757$

- Aug 31st 2009, 05:50 AMWilmer
If you make that 599 instead, you get 12/600 = .02; more manageable...

Anyhow, my point is: WHY list 599 numbers in between -2 and 12:

[-2] - 1.98, - 1.96, ...... 11.96, 11.98 [12] ?

WHAT is the purpose?

Isn't it enough for you to know that if 2 post holes are dug, ONE post

in between will create TWO sections? Or n posts will create n+1 sections?