IFNA function

Description

This IFNA function return a custom result when a formula generates an error and a standard result when no error is detected. IFNA is an elegant way to trap and manage errors without using more complicated nested IF statement.

​

Objective

Specific predefined value for error condition.

​

Syntax

=IFNA(value, value_if_error)

​

Arguments

value - value, reference or formula to detect error.

value_if_error - value of return if an error is found.