- SpreadJS Overview
- Getting Started
- JavaScript Frameworks
- Best Practices
- Features
- SpreadJS Designer
- SpreadJS Designer Component
- Touch Support
-
Formula Reference
- Formula Overview
-
Formula Functions
- Barcode Functions
- Compatibility Functions
- Database Functions
- Date and Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Logical Functions
- Lookup and Reference Functions
- Math and Trigonometric Functions
- Statistical Functions
- Sparkline Functions
- Text Functions
- Web Functions
- Other Functions
- RegEx Functions
- Import and Export Reference
- Frequently Used Events
- API Documentation
- Release Notes
IFERROR
This function evaluates a formula and returns a value you provide if there is an error or the formula result.
Syntax
IFERROR(value, error)
Arguments
This function has these arguments:
Argument | Description |
|---|---|
value | Value or expression to evaluate |
error | Value to return if the formula returns an error |
Remarks
The following error types are evaluated, #VALUE!, #REF!, #NUM!, #NAME?, #DIV/O, #N/A, or #NULL
Data Types
Accepts any type of formula for the value. Returns any data type.
Example
IFERROR(A3/A5,"dogs")