View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default Adding a certain number until minimum is reached

Try this:
A1: (some number less than 20,000)
Select from A1 down through A50
EditFillSeries
Series in: Columns
Step: 5000
Stop Value: 20000
Click [OK]

Does that help?

***********
Regards,
Ron


"dk" wrote:

I'm having problem figuring out how to do this.

If I have a number that is less that 20,000 in one cell, I want the next
cell to add to it in multiples of 5,000 until a miniumum 20,000 is reached.
I was wondering if anyone could help me with this.

Thanks