Description
The Excel Ceiling.Precise function rounds a supplied number up (regardless of the number's sign), to the nearest multiple of a given number.
The syntax of the function is:
CEILING.PRECISE( number, [significance] )
Where the arguments are as follows:
Note that the arithmetic sign of the [significance] argument is ignored. The supplied number is rounded up for both positive and negative [significance] values.
Ceiling.Precise Function Examples
The following spreadsheet shows the Excel Ceiling.Precise function used with several different significance values, on the positive and negative numbers 22.25 and -22.25.
The functions are shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.
If you get an error from the Excel Ceiling.Precise function, this is likely to be the following :
Common Error
No comments:
Post a Comment