Skip to content
English
  • There are no suggestions because the search field is empty.

IFERROR Operation

How to use the IFERROR operation in formulas

Definition

The IFERROR operation allows you to define the output for a field that is an error. 

Example

IFERROR(#error, "N/A")


Result:
N/A

Syntax Guide

IFERROR(value1, value_if_blank)

value1 - The value to test

value_if_blank- The value to return if value1 is blank