ISO_CEILING
function ISO_CEILING(arg1.: number = null, arg2.: number = null): number | string | booleanDescription
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
- arg1.
numberdefault: null - arg2.
numberdefault: null
Returns
number | string | booleanTry It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.ISO_CEILING(-6.7, 2));