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