IFERROR equivalent


#1

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])


#2

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.