Need better way than an infinite IF formula

Hello,

My situation is this: I have a cell (referred to as Cell A) that will end up being really any number positive or negative. Depending on what cell A is, certain financing needs to take place in multiples of $5000's that bring that balance back over 0 or nothing if it is already above zero. I've figured out how to use an if statement to do this but I can't infinitely go down and keep adding multiples of 5000.

Similarily, if Cell A is greater than 1000 it needs to pay off the financing in another line in multiple of $1000's. I've created a sub-schedule to take care of interest, principal remaining, etc so I just need the basics.

Here's an idea of what the format looks like:

Cash excess (deficit): Cell A - determined by previous cells that don't matter
Financing: (need formula) - multiples of 5000 to bring cell a over 0
Financing Repayment: (need formula) - multiples of 1000 if cell a has enough to cover without going below 0

Thank you.

This formula will give you the number of multiples of 5000:

=INT(cellA/5000)

You might need a +1 at the end so that if cellA = 7,500 it will return 2 instead of 1 (for example). You can then multiply all that by 5000 to get the amount needed, i.e.:

=(INT(cellA/5000) +1)*5000

Hope this helps.

Pete

Here's my new formula which I believe to be correct for the first one: =IF(B168<0,-INT(B168/5000)*5000,0)
I'm assuming the second part would use a very similar formula, I'll work on it. Thanks for the help