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.