View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default expanding numbers?

How were the numbers 80, 93, 123... arrived at starting with 75, 30000 and
20?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"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