Menu
EXCEL IFNA FUNCTION
Excel IFNA Function Introduction
If the formula returns #N/A, this function returns the value you provide; otherwise, it returns the formula’s result. In Excel 2013, this function was introduced.
Description of Excel IFNA Function
Syntax:
=IFNA(value, value_if_na)
Parameter list:
- The formula that is examined for the #N/A error value is called value.
- If the formula evaluates to the #N/A error value, value if na is the value to return.
Step By Step Guide of IFNA Function
For example,
- In this formula =IFNA(VLOOKUP(“Richa”,$A$5:$B$10,0),“Not found”),
- if the name “Richa” does not exist in the lookup table, the #N/A error will be returned, and the IFNA function will return Not Found, as indicated at the end of the calculation.
Key Points
- IFNA considers an empty cell (Value or Value_if_na) as an empty string value (“”).
- IFNA produces an array of results for each cell in the range specified in value if Value is an array formula.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
