ISO_CEILING
Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance regardless of the sign of the number.
The number is always rounded up regardless of its sing.
Syntax
expression.ISO_CEILING(arg1, arg2);
expression - A variable that represents a ApiWorksheetFunction class.
Parameters
| Name | Required/Optional | Data type | Default | Description |
|---|---|---|---|---|
| arg1 | Required | ApiRange | ApiName | number | The numeric value to round up. | |
| arg2 | Optional | ApiRange | ApiName | number | The multiple of significance to round up to. If it is omitted, the default value of 1 is used. If it is set to zero, the function returns 0. |
Returns
number
Example
- Code
- Result
let worksheet = Api.GetActiveSheet();
let func = Api.GetWorksheetFunction();
worksheet.GetRange("A1").SetValue(func.ISO_CEILING(-6.7, 2));