Rounds a number up to the nearest integer multiple of specified significance. If the number is positive or negative, it is rounded up.
Sample Usage
CEILINGPRECISE(52.5, 10)
CEILINGPRECISE(A4, A5)
Syntax
CEILINGPRECISE(number, [significance])
- number - The number to be rounded.
- significance - [OPTIONAL] The number to whose multiples the value will be rounded.
Examples
CEILINGPRECISE(52.5, 10) returns a value of 60.
CEILINGPRECISE(A4, A5) rounds the number in A4 to the nearest integer multiple of the number in A5.
Notes
- By default, significance is 1 for positive numbers.
- The CEILINGPRECISE function returns the mathematical ceiling irrespective of the signs of number and significance.
- By default, positive numbers with decimal places are rounded up to the nearest integer.
- By default, negative numbers with decimal places are rounded up towards zero to the nearest integer. For example, -2.6 is rounded up to -2.