Ceiling rounds a number up to the nearest specified significance.
CEILING( [Number], [Significance] )
Number is the number to round.
Significance is the number to which this function finds the nearest (higher valued) multiple of.
|CEILING(123.456, 9)||Rounds the number 123.456 up to the nearest multiple of 9. The resulting value is 126.|
|CEILING(-1.234,1)||Rounds the number -1.234 up to the nearest multiple of 1. The resulting value is -1.|