Trapping #N/A! error within a cell formula IFNA function can be used. Also use IFNA function to customize the result like replace or show 0 (ZERO) in case of #N/A!.
- value: its mandatory argument refers to value that is checked for #N/A! error
- value_if_na: its mandatory argument where user can put its own value in case of “#N/A” error
The implementation of IFNA function is exactly same as IFERROR function. Let’s take an example where we have list of products and we want to make a dynamic search based on user input to get the sales of input products as shown in below example.
If you notice the result the error value is replaced with “not found” which is passed as value_if_na parameter in the formula. Similarly you can pass any message that you wish to see in case of error.
Next >> Excel Printout a complete reference with Code example