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!
for 1 evenly spaced point between -2 & 10
= 6
-2, -2+6*1, 10
or
-2, 4, 10
--
for 2 evenly spaced points
= 4
-2, -2+4*1, -2+4*2, 10
or
-2, 2, 6, 10
--
for 11 evenly spaced points
= 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
= 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.
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?