TRY NEW VERSION

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