I have a series of prices. I want to round each price up to the nearest ninety-nine cents. So that:
12.00 rounds up to 12.99
56.75 rounds up to 56.99
24.90 rounds up to 24.99
But I can't make this work using round or ceiling. Please help, and thank you.