Roundup/Ceiling to 2 decimals using a whole #

I'm trying to use either the roundup or ceiling function to convert a number x to a number divisible by 12 to 2 decimal places.

Example - $18.69 is current number. The correct formula would deliver $18.72

Evenly divisible by the number of units "12" - just not to the whole number.

I've tried =ceiling(18.69,12) and it returns $24.00

bchalifoux,

A simple workaround would be to multiply by 100 so there is no decimal, and then divide by 100 after conversion:
=CEILING(A2*100,12)/100

Hope that helps,
~tigeravatar

Thanks!! That worked.