Does Excel have a simple function that allows for a series of numbers to be
generated from start point to end point with a specified number of data
points and even increments? For example:

Start Point: $0.08
End Point: $0.17
Number of Points: 35

and then have it evenly increment from 8 cents to 17 cents with a total of
35 data points. I know how to do it in other programming software but can
find a simple defined formula for Excel.

A1=0.08
B1=0.17
C1=35

in D1 and copy down:


=$A$1+(($B$1-$A$1)/($C$1-1))*(ROW()-1)



"Eric" wrote:

Does Excel have a simple function that allows for a series of numbers to be
generated from start point to end point with a specified number of data
points and even increments? For example:

Start Point: $0.08
End Point: $0.17
Number of Points: 35

and then have it evenly increment from 8 cents to 17 cents with a total of
35 data points. I know how to do it in other programming software but can
find a simple defined formula for Excel.

Put this in the first row:

=FORECAST( ROW(), {0.08,0.17}, {1,35} )

and copy downwards. Voilà.

- David Hilberg

On Jul 15, 1:16 pm, Eric wrote:
Does Excel have a simple function that allows for a series of numbers to be
generated from start point to end point with a specified number of data
points and even increments? For example:

Start Point: $0.08
End Point: $0.17
Number of Points: 35

and then have it evenly increment from 8 cents to 17 cents with a total of
35 data points. I know how to do it in other programming software but can
find a simple defined formula for Excel.