Thursday 20 April 2017

Excel - Microsoft Excel IFNA Function (excel 2013)

Description

Returns the value you specify if the formula returns the #N/A error value; otherwise returns the result of the formula.
Syntax
IFNA(value, value_if_na)


The IFNA function syntax has the following arguments.

Example
The workbook below shows examples of this function. Inspect them, change existing formulas, or enter your own formulas to learn how the function works


No comments:

Post a Comment