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.
Rule | Meaning |
|---|---|
| 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. |