Hi experts,
I need help setting up formulas to round pricing (some very specific rules):
-If less than $100, rounds to nearest $, no cents
-If $100-$105, rounds to $99
- Between$100 -$500 - price ends in 5 or 9, but 5 never follows 0 (no $105 => 109 instead, no $205=> 209 instead etc)
- Between $500-$1000 – Price ends in 5 or 9; 515 is the lowest; never use 0 (515, 615, 699, 799 etc)
- Over $1,000 rounds to $25/$50/$75/$99 increments
I hope you will be able to help!
Bookmarks