# 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 was added in Excel 2013.* You can use the ISNA function to return the boolean True or False depending if the value is #N/A.* 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 and do not want to use nested IF functions.* You can use the ISERROR function to return True or False depending if the value is an error.* 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.* 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

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