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

• Tweet
• Share
• Share
• Share
• Share