Is it possible to evenly increment between start point and end poi
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.
|