Round up and down to nearest *.99

[Bekah]

I have wholesale number. I need a calculation number:

Wholesale number plus 67% of it ... and then if the cents is < 50, round it down to the next 99 cents. And if 50 or above, round up to the next 99 cents so that:

Wholesale = 6.29 becomes 10.99

Wholesale = 7.19 becomes 11.99

Wholesale = 4.69 becomes 7.99

These are examples I took from previous orders. I can get this part:

Round(Wholesale + (Wholesale * .67); 2)

I can't make it round up or down right to the 99 cents. I tried using IF but it kept weirding on me and the number of cents to adjust kept changing. Ideas please?

[Ender]

How about:

Round(Wholesale * 1.67;0) - .01

[Bekah]

Hi Ender

I ended up with 12.01 (7.19) - so needed to minus 2 cents and 10.5 (6.29) so needed to plus 49 cents -- and this was AFTER I had already rounded so couldn't round again. So i thought I need to force it with IF and that I needed to round to two decimal or they would drop!! Oh brother. Round 0.

I just spent 1 1/2 hours reviewing this so it'd sink in. I won't be caught by something so silly again. I'm looking forward to college math classes after graduate. I think I need them. Thank you!