Percentage increase with rounding in excel

Copper Contributor

I have a pricing sheet for 2021 that contains a few thousand prices.  How can I incorporate a percentage increase and round that number to the nearest multiple of $5.00?  For example, I know I can copy 104% and use the multiply/value in paste to increase the percentage by 4%.  Is there a way to automatically round that result to the nearest $5.00 increment as well?  ex.  A1 is $65,676.00.  I use the 4% copy/paste special increase to get to $68,303.04.  I want that result to show as $68,305.00.  

1 Reply