How to Use the CEILING function to round up values to the nearest 100
For this example, all prices have to be rounded up to whole $100 units. To do this, you use the CEILING function. This function returns a number that is rounded up to the nearest multiple of significance.
CEILING(number, significance)
number: The value to be rounded.
significance: The multiple to which the number will be rounded up.
To round up [...]
