Checks whether a value is an error other than #N/A, and returns TRUE or FALSE.
| Name | Type | Description |
| arg1 | any | Is the value you want to test. Value can refer to a cell, a formula, or a name that refers to a cell, formula, or value. |
builder.CreateFile("xlsx");
const oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("B3").SetValue("45")
var result = oFunction.ISERROR("B3");
oWorksheet.GetRange("C3").SetValue(result)
builder.SaveFile("xlsx", "ISERROR.xlsx");
builder.CloseFile();