Jan 11 2021 02:49 PM
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.