IFNA(value, value_if_na)

Returns the value True or False depending if the value is #N/A.

valueThe argument to check if N/A.
value_if_naThe value if #N/A is found.

Remarks

* Added in Excel 2013.
* If "value" is an empty cell, then value = "".
* If "value" is an array formula, then an array of results is returned.
* For the Microsoft documentation refer to support.office.com

 ABC
1=IFNA(C1,"its na") = its na =NA() = #N/A
2=IFNA(C2,"its na") = 3 3
3=IFNA(C3,"its na") = 0  

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top