SIGN
function SIGN(arg1: number = null): number | string | booleanDescription
Returns the sign of a number: 1 if the number is positive, zero if the number is zero, or -1 if the number is negative.
Parameters
- arg1
numberdefault: null Is any real number.
Returns
number | string | booleanTry It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.SIGN(12));