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..
Name | Type | Description |
arg1. | number | |
arg2. | number |
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();