# IFERROR equivalent

cancel
Showing results forย
Did you mean:ย
5 - Automation Enthusiast

It would be very helpful to have a new formula function akin to Excelโs IFERROR, or even add an optional fourth parameter to IF as a branch to be taken if an error occurs in evaluating the expression. e.g., IF([logical argument],[true branch],[false branch],[error branch])

6 - Interface Innovator

Too late for @Luke_Thompson, Iโm sure, but for anyone else who may come across this: I was just seeking the same solution and found the ISERROR function, which can be paired with IF for an IFERROR equivalent.

4 - Data Explorer

Hi Nate, can you share the actual formula you used? Appreciate it.

18 - Pluto

Welcome to the Airtable community!

You can see the documentation for the `ISERROR()` function in the formula field reference. Here is an example usage

``````IF(
ISERROR( {num1} / {num2}),
"you are probably dividing by zero",
IF(
{num1} / {num2} > 1,
"got an answer bigger than 1",
"got an answer less or equal to one"
))
``````
6 - Interface Innovator

It causes extensive calculations to be executed twice :exploding_head:

Definitely, Airtable should have IFERROR(value, value_if_error)

Example of formula I have because of lack of IF ERROR:

``````IF(
ISERROR(LEFT(TRIM({Full Name TL}), SEARCH(" ",TRIM({Full Name TL})) + 1) & ".\n*" & REGEX_EXTRACT({Funding Information Translated}, "City: (.+)\n") & "*"),
"",
LEFT(TRIM({Full Name TL}), SEARCH(" ",TRIM({Full Name TL})) + 1) & ".\n*" & REGEX_EXTRACT({Funding Information Translated}, "City: (.+)\n") & "*")
``````
18 - Pluto

Thatโs just part of the nature of Airtable formulas. Itโs a bit of a pain, but itโs what we have to deal with for now. If you donโt want to repeat the calculation in the formula, you can move the calculation to a different field and then just use the field name twice. Of course, that technique has its own issues as well.

Recently Completed Ideas