ERROR_TYPE
function ERROR_TYPE(arg1: any = null): number | string | boolean
Description
Returns a number matching an error value..
Parameters
- arg1
any
null Is the error value for which you want the identifying number, and can be an actual error value or a reference to a cell containing an error value.
Returns
number | string | boolean
Try It
const oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
var nonPositiveNum = 0;
var logResult = oFunction.LOG(nonPositiveNum);
oWorksheet.GetRange("B3").SetValue(logResult);
oWorksheet.GetRange("C3").SetValue(oFunction.ERROR_TYPE(logResult));