View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default 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.