Excel Tutorial – IFNA

The IFNA function in Microsoft Excel is a useful tool for handling errors that occur in formulas. It allows you to specify a value to display if the formula returns the #N/A error value, which indicates that the formula could not be completed due to an invalid argument or a missing value.

Here’s how to use the IFNA function:

1. Open a blank Excel spreadsheet.
2. In the cell where you want to display the result of the IFNA function, type the following formula: =IFNA(formula, value)
3. Replace “formula” with the cell reference or formula that you want to test. This is the formula that may return the #N/A error value.
4. Replace “value” with the value that you want to display if the formula returns the #N/A error value. This can be a cell reference, a constant value, or another formula.
5. Press Enter to calculate the result. If the formula returns a value other than #N/A, the result will be the value of the formula. If the formula returns the #N/A error value, the result will be the value specified in the second argument.

Here’s an example of how you might use the IFNA function:

• Display a value of 0 if the formula in cell A1 returns the #N/A error value: =IFNA(A1, 0)
• Display the value in cell B1 if the formula in cell A1 returns the #N/A error value: =IFNA(A1, B1)