WorksheetFunction.Ceiling_Math method (Excel)
Rounds a number up to the nearest integer or to the nearest multiple of significance.
expression.Ceiling_Math (Arg1, Arg2, Arg3)
expression A variable that represents a WorksheetFunction object.
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Arg1 | Required | Double | The value that you want to round. |
| Arg2 | Optional | Variant | The multiple to which you want to round. |
| Arg3 | Optional | Variant | When given and nonzero, this function will round away from zero. |
Double
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.