WorksheetFunction.ISO_Ceiling method (Excel)
Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance.
expression.ISO_Ceiling (Arg1, Arg2)
expression A variable that represents a WorksheetFunction object.
Name | Required/Optional | Data type | Description |
---|---|---|---|
Arg1 | Required | Double | Number - The value to be rounded. |
Arg2 | Optional | Variant | Significance - The optional multiple to which number is to be rounded. If significance is omitted, its default value is 1. NOTE: The absolute value of the multiple is used, so that the ISO_Ceiling function returns the mathematical ceiling irrespective of the signs of number and significance. |
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.