Jun 10 2022 01:56 AM
Hi all
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?
Any help would be greatly appreciated?
Jun 10 2022 02:26 AM
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.
Jun 10 2022 02:32 AM
Jun 10 2022 03:38 AM
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.