TRY NEW VERSION

Try now New API BETA

Try out the new view and capabilities of the API documentation

START

ISO_CEILING

ISO_CEILING(arg1., arg2.) → { number | string | boolean }

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. However, if the number or the significance is zero, zero is returned..

Parameters:

Name Type Description
arg1. number
arg2. number

Returns:

Type
number | string | boolean

Example

Copy code
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.ISO_CEILING(-6.7, 2));
builder.SaveFile("xlsx", "ISO_CEILING.xlsx");
builder.CloseFile();

Resulting document