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

Adding a certain number until minimum is reached
 

one way:

A2: =INT((19999-A1)/5000)*5000+A1

In article ,
"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

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

Adding a certain number until minimum is reached
 

One way:

=IF(A1=20000,A1,A1+CEILING(20000-A1,5000))

(I think....)



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

--

Dave Peterson