Discussion Percentage increase with rounding in excel in Excel
https://techcommunity.microsoft.com/t5/excel/percentage-increase-with-rounding-in-excel/m-p/2050893#M85555
<P>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. </P>Mon, 11 Jan 2021 22:49:52 GMTSheide2021-01-11T22:49:52ZPercentage increase with rounding in excel
https://techcommunity.microsoft.com/t5/excel/percentage-increase-with-rounding-in-excel/m-p/2050893#M85555
<P>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. </P>Mon, 11 Jan 2021 22:49:52 GMThttps://techcommunity.microsoft.com/t5/excel/percentage-increase-with-rounding-in-excel/m-p/2050893#M85555Sheide2021-01-11T22:49:52ZRe: Percentage increase with rounding in excel
https://techcommunity.microsoft.com/t5/excel/percentage-increase-with-rounding-in-excel/m-p/2051694#M85592
<P><LI-USER uid="925468"></LI-USER> Like so?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2021-01-12 at 07.04.18.png" style="width: 349px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/245571i77DAA49A9E5C4CCC/image-size/large?v=1.0&px=999" role="button" title="Screenshot 2021-01-12 at 07.04.18.png" alt="Screenshot 2021-01-12 at 07.04.18.png" /></span></P>Tue, 12 Jan 2021 06:05:01 GMThttps://techcommunity.microsoft.com/t5/excel/percentage-increase-with-rounding-in-excel/m-p/2051694#M85592Riny_van_Eekelen2021-01-12T06:05:01Z