Formula to make dollar amounts a round number for payments

[C.j.]

Chart is attached to use. basically I need to find a formula to plug in so when I input premiums into the chart, the installment payments are even numbers like $10,01 instead of $10.012 so that the exact amount can be paid. if I have $10.122 or something like that it is impossible for someone to write a check for that amount since there is no such thing as 1.22 pennies. usually I adjust the down payment up or down to ensure that the installments are round numbers but am looking to find a formula so I can paste in my premiums and it will automatically adjust as needed to round numbers.

[ChemistB]

Not sure what sort of formulas you will be using (or which columns) but can't you just use

=ROUND(your formula, 2)
?

[JohnTopley]

Look at ROUNDUP

See attached