N
function N(arg1: any = null): number | string | booleanDescription
Converts non-number value to a number, dates to serial numbers, TRUE to 1, anything else to 0 (zero).
Parameters
- arg1
anydefault: null Is the value you want converted.
Returns
number | string | booleanTry It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.N(false));