IFNA |
IFNA(value, value_if_na) |
Returns the value True or False depending if the value is #N/A. |
value | The argument to check if N/A. |
value_if_na | The value if #N/A is found. |
REMARKS |
* Added in Excel 2013. * You can use the ISNA function to return the value 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 IFERROR function to returns the value or something else if it evaluates to an error. * 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 |
|
1 - Does cell "B1" contain #N/A. 2 - Does cell "B2" contain #N/A. 3 - Does cell "B3" contain #N/A. |
© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top