View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default expanding numbers?

I don't know if this is what you're asking, but assuming your examples where
*not* actual examples, but just numbers you picked off the top of your head,
you might try something like this:

A1 = 75
B1 = 30000
C1 = 20
D1=(B1-A1)/(C1-1)
Which returns 1575

Now, click in A1, and drag down the fill handle, using the *right* mouse
button, to A20.

After releasing the mouse, and while the range is *still* selected, at the
bottom of the dialog window, click on "Series".
Enter 1575 into the "Step Value" box, then <OK.

Is that what you're after?
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"Pendal" wrote in message
...
I'm not sure how to title this post. But this is what i want to do.

I need to take two variable numbers say 75 and 30000.

Then I need to step out the difference over a variable amount of cells. in
this case say 20 cells.

the output should look something like this.

75
80
93
123
178
320
....
....
....
30000

is there anyway to do this without lines and lines of code?

thanks