IFNA

IFNA(value, value_if_na)

Returns the value or something else if it evaluates to #N/A.

value	The argument to check if N/A.
value_if_na	The value if #N/A is found.

REMARKS

* This function provides a way to handle #N/A errors without catching any other errors.
* This function is often used to trap and handle errors returned from lookup functions XLOOKUP and XMATCH.
* If "value" is an empty cell, then value = "".
* If "value" is an array formula, then an array of results is returned.
* You can use the IF function to return the value based on whether a certain condition is True or False.
* You can use the IFERROR function to returns the value or something else if it evaluates to an error.
* You can use the IFS function when you have multiple conditions.
* You can use the ISERROR function to return True or False depending if the value is an error.
* You can use the ISNA function to return the boolean True or False depending if the value is #N/A.
* You can use the ISREF function to return True or False depending if the value is a cell reference.
* You can use the ERROR.TYPE function to return the number corresponding to a particular error value in a cell.
* This function was added in Excel 2013.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A	B
1	=IFNA(B1, "its na") = its na	=NA() = #N/A
2	=IFNA(B2, "its na") = 3	3
3	=IFNA(B3, "its na") = 0
4	=IFNA(VLOOKUP("NoMatch",B1:C3,2,False), "Not Found") = "Not Found"

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