WorksheetFunction.Ceiling_Precise method (Excel)
Returns the specified number rounded to the nearest multiple of significance.
Syntax
expression.Ceiling_Precise (Arg1, Arg2)
expression A variable that represents a WorksheetFunction object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Arg1 | Required | Double | Number - the value that you want to round. |
| Arg2 | Optional | Variant | Significance - the multiple to which you want to round. |
Return value
Double
Remarks
For example, if you want to avoid using pennies in your prices and your product is priced at $4.42, use the formula Ceiling(4.42,0.05) to round prices up to the nearest nickel.
If the significance argument is omitted, the value 1.0 is used.
Depending on the sign of the number and significance arguments, the Ceiling_Precise method rounds either away from or towards zero.
| Sign (Arg1/Arg2) | Rounding |
|---|---|
| -/- | Rounds toward zero. |
| +/+ | Rounds away from zero. |
| -/+ | Rounds toward zero. |
| +/- | Rounds away from zero. |
If either argument is nonnumeric, Ceiling_Precise generates an error.
If number is an exact multiple of significance, no rounding occurs.
Note
The CEILING.PRECISE algorithm is the same as the one used for the ISO.CEILING function.
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.