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
Bookmarks