Syntax
CEILING(number,significance)
The CEILING function syntax has the following arguments:
Number : Required. The value you want to round.
Significance : Required. The multiple to which you want to round.
Note:
If either argument is nonnumeric, CEILING returns the #VALUE! error value.
Regardless of the sign of number, a value is rounded up when adjusted away from zero. If number is an exact multiple of significance, no rounding occurs.
If number is negative, and significance is negative, the value is rounded down, away from zero.
If number is negative, and significance is positive, the value is rounded up towards zero.
No comments:
Post a Comment