Prices on most items are $500.00 to several thousand dollars, so the amount
when rounded up is insignificant. I did not mention that I have three colums
that are connected so when price is increased in one the prices in the others
also increase accordingly.

"JLatham" wrote:

Forgot to mention, in B1
=ROUNDUP(A1*1.05,0)
will yield same results as the other formula.

"Boss Mary" wrote:

I need to increase the prices on my pricelist by 5%, the resulting amounts
also have to be rounded up to the next $ amount. I have tried putting 1.05
in an unused cell, copying, then using paste special, with value and multiply
checked. This gets the % but the numbers are not rounded.