# IFNA

## “IFNA”

Used for – “IFNA” function in MS Excel is used to performs a specified task in case formula you typed have tendency to ends up or results as #NA! error in any case or any set of data you processed through formulas.

Syntax – IFNA(value, value_if_na).
Value –The value is any formula/reference cell, you typed or calculated which may results #NA! error at any instant with any set of data.
Value_if_na – This is the value you want see as a result when your said value results a #NA! error. It can be a number/text/formula.

Example – Following example will clear the IFNA function:-
 A B C D E F G H I 1 #N/A =IFNA(A1,”CHECK”) 2 =NA() =IFNA(A2,”CHECK”) 3 =IFNA(A3,”CHECK”) 4 1 =IFNA(A4,”CHECK”) 5 =A4/A3 =IFNA(A5,”CHECK”) 6 7

And result you get as under:-
 A B C D E F G H I 1 #N/A CHECK 2 #N/A CHECK 3 0 4 1 1 5 #DIV/0! #DIV/0! 6 7

Note:- The IFERROR Function will work only if the result you got after calculation is ends up with #NA! error. In case any other type of error result after calculation it will show the same error as a result