Try this? Current price in A1, this formula in B1
=ROUND(A1*1.05+.5,0)

You can then copy amounts in column B and use Paste Special | Values over
the amounts that were in column A and then do away with column B if you want.

Are you sure you want to round up to next whole $?? An item that was $1.99
goes up to $2.0895 but gets rounded up to $3.00. Good for profit, but... ?

"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.