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

 AB
1=IFNA(B1,"its na") = its na=NA() = #N/A
2=IFNA(B2,"its na") = 33
3=IFNA(B3,"its na") = 0 

1 - Does cell "B1" contain #N/A.
2 - Does cell "B2" contain #N/A.
3 - Does cell "B3" contain #N/A.

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