You will often come across the scenario where data is filled into an Excel worksheet and an error occurs that must be dealt with. This is especially relevant when further calculations are based on cells containing an error and you don’t want the error to have a “knock-on” effect.
Required knowledge:
See also:
- IFERROR()
- ISERROR()
- ISERR()
- ISNA()
- ERROR.TYPE()
1. Syntax
=IFNA(value, value_if_na)
value is what it is you want to check for the #N/A (“not available”) error message
value_if_na what it is you want to be returned if the #N/A (“not available”) error message is encountered
Returns value_if_na if the #N/A error message is encountered.
2. Example
Head on over to the VLOOKUP() function tutorial for a practical example.
References:
- Microsoft Support. (no date) IFNA function. Available at: https://support.microsoft.com/en-us/office/ifna-function-6626c961-a569-42fc-a49d-79b4951fd461 (Accessed: 16 April 2024).