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

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