Information
ISERROR function
TRUE if value is an error. ISERROR works in Sheets with the usual arguments and results, on cells and on live data from the tools you connect.
Syntax
=ISERROR(value) | Argument | Use |
|---|---|
value | required |
On live data
In Sheets, ISERROR sits next to live data from a connected tool: =data.orders.sum(total) totals a table, =list.orders(customer) spills a column's distinct values, and a linked table column such as table.orders[Total] is a range any function accepts.
More information functions
CELLInformation about a cellERROR.TYPENumber of an error typeINFOInformation about the environmentISBLANKTRUE if the cell is emptyISERRTRUE if value is an error other than #N/AISEVENTRUE if the number is evenISFORMULATRUE if the cell holds a formulaISLOGICALTRUE if value is TRUE or FALSEISNATRUE if value is #N/AISNONTEXTTRUE if the value is not textISNUMBERTRUE if value is a numberISODDTRUE if the number is odd
Spreadsheet formulas on live business data
Sheets evaluates 491 spreadsheet functions, on cells and on data read live from your tools.