Discussion Re: Rounding to the nearest number from a list in Excel
https://techcommunity.microsoft.com/t5/excel/rounding-to-the-nearest-number-from-a-list/m-p/3491791#M150116
<P><LI-USER uid="1420021"></LI-USER> </P><P>I assume you are referring to the practice of pricing $12.00 goods at $11.95? Round to the nearest whole number price point and subtract the 1cent, 5cents, $1, $5 depending on the amount and your policy. Note, this does not alter the original value, only the value shown by the copy.</P>Fri, 10 Jun 2022 09:26:12 GMTPeter Bartholomew2022-06-10T09:26:12ZRounding to the nearest number from a list
https://techcommunity.microsoft.com/t5/excel/rounding-to-the-nearest-number-from-a-list/m-p/3491669#M150114
<P>Hi all</P><P>I am looking at a way of quickly rounding a large list of prices to the nearest psychological price point from a separate list of prices?</P><P>Any help would be greatly appreciated?</P>Fri, 10 Jun 2022 08:56:36 GMThttps://techcommunity.microsoft.com/t5/excel/rounding-to-the-nearest-number-from-a-list/m-p/3491669#M150114Ryepatterson2022-06-10T08:56:36ZRe: Rounding to the nearest number from a list
https://techcommunity.microsoft.com/t5/excel/rounding-to-the-nearest-number-from-a-list/m-p/3491791#M150116
<P><LI-USER uid="1420021"></LI-USER> </P><P>I assume you are referring to the practice of pricing $12.00 goods at $11.95? Round to the nearest whole number price point and subtract the 1cent, 5cents, $1, $5 depending on the amount and your policy. Note, this does not alter the original value, only the value shown by the copy.</P>Fri, 10 Jun 2022 09:26:12 GMThttps://techcommunity.microsoft.com/t5/excel/rounding-to-the-nearest-number-from-a-list/m-p/3491791#M150116Peter Bartholomew2022-06-10T09:26:12ZRe: Rounding to the nearest number from a list
https://techcommunity.microsoft.com/t5/excel/rounding-to-the-nearest-number-from-a-list/m-p/3491830#M150117
Hi, thanks for this, unfortunately, the rule changes at various prices, for those below 200USD they would be priced at the nearest .99, whereas anything above 200USD would be priced to the nearest whole dollar but ending in 9 for example 205 would become 209, 314 would become 309Fri, 10 Jun 2022 09:32:17 GMThttps://techcommunity.microsoft.com/t5/excel/rounding-to-the-nearest-number-from-a-list/m-p/3491830#M150117Ryepatterson2022-06-10T09:32:17ZRe: Rounding to the nearest number from a list
https://techcommunity.microsoft.com/t5/excel/rounding-to-the-nearest-number-from-a-list/m-p/3492132#M150120
<P><LI-USER uid="1420021"></LI-USER> </P><P>This works a solution through using 365 but a complete set of rules would be needed before the solution is 'packaged' to remove the helper table.</P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 788px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/379273iEB238C61CAECEE0E/image-size/large?v=v2&px=999" role="button" title="image.png" alt="image.png" /></span></P><P> </P>Fri, 10 Jun 2022 10:38:25 GMThttps://techcommunity.microsoft.com/t5/excel/rounding-to-the-nearest-number-from-a-list/m-p/3492132#M150120Peter Bartholomew2022-06-10T10:38:25Z