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.

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.

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.

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.

Didn't mean to make you defend your business strategy - that's literally
"your business", just making sure that's what you wanted.

Did the formula help, or is the fact that there are other columns
interfering with things?

"Boss Mary" wrote:

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.