I need to create a formual to round to the nearest based on the rules below.
Is there a macro that can do this?

If price is below $50.00 Round up to a .99 ending
If price is $50.01 to $100.00 Round up or down to the nearest 4.99 or 9.99
ending
If price is $100.01 to $500.00 Round up to a 9.99 ending
If price is $500.01 to $1000.00 Round up to nearest 19.99 €“ 39.99 €“ 49.99 €“
69.99 €“ 89.99 or 99.99 ending
If price is $1000.01 to $2000.00 Round up to nearest 29.99 €“ 49.99 €“ 69.99
or 99.99 ending
If price is $2000.01 and up Round up to 49.99 or 99.99 ending



--
lmo