Round number upwards to nearest 49 / 99. 1

[Wullie]

Hi all,

Does anyone know of a quick way to round a price upwards to the nearest 99 or 49?

For example:

12.23 would become 12.49
12.52 would become 12.99

Thanks in advance,

Wullie

Fresh Look - Quality Coldfusion Hosting

http://www.tutorial-world.com

The pessimist complains about the wind. The optimist expects it to change. The leader adjusts the sails. - John Maxwell

 

[dakota81]

Try this out:

0.50 * ceil((num + 0.01) / 0.50) - 0.01

 

[Wullie]

Exactly what I was looking for. Thanks.

I won't tell you the messed up calculation I was trying.

Thanks again.

Wullie

Fresh Look - Quality Coldfusion Hosting

http://www.tutorial-world.com

The pessimist complains about the wind. The optimist expects it to change. The leader adjusts the sails. - John Maxwell