Adding a certain number until minimum is reached

[dk]

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

 

[JE McGimpsey]

one way:

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

 

[Ron Coderre]

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

Does that help?

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

 

[Dave Peterson]

One way:

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

(I think....)