I. About the functions
ISERROR and IFERROR functions can be used to determine if the result of a formula evaluation is an error. The ISERROR function returns "true" if there is an error, while the IFERROR function can return a custom value in such cases.
ISERROR function
- Formula: ISERROR(value)
- Arguments
- value: The formula whose result needs to be verified for errors. When the result is an error, "true" is returned, otherwise false is returned.
- Function: Check whether a formula contains errors.
IFERROR function
- Formula: IFERROR(value, value_if_error)
- Arguments:
- value: The formula whose result needs to be verified for errors. When the result is not an error, it returns the result of the formula.
- value_if_error: The value to return if there is an error. This parameter is optional.
- Function: Return a custom value when the formula result is an error.
Common error types
Error type | Description |
#N/A | Data is missing. |
#VALUE! | The formula was entered incorrectly or there is an error in a value that is part of the calculation. |
#REF! | The formula references an invalid value. For example, copying a cell that has been deleted. |
#DIV/0! | The divisor is 0 (you cannot divide by 0). |
#NUM! | There is a problem with the numeric values in the formula. |
#NAME? | There is unrecognizable content. |
#NULL! | An incorrect range operator or an incorrect value is used. |
II. Steps
- Open the base and select a table on the left navigation bar.
- Click the + icon next to the rightmost field to add a new field. Enter a field title, select Formula, and click Edit Formula. To edit an existing formula field, double-click its field title.
- Enter the IFERROR or ISERROR function as needed.
- Click Confirm.
III. Use cases
Evaluate whether there is an error
Scenario: Use the ISERROR function to check whether there is an error in the calculation.
Formula: ISERROR([Total value]/[Inventory])
250px|700px|reset
Return specified value when there is an error
Scenario: Use the IFERROR function to check whether there are errors in the calculation, and return blank, if there is an error.
Formula: IFERROR([Total value]/[Inventory],"")
250px|700px|reset