Use Excel ISNA Function if you want to test a value for #N/A error. In simple words, it will return TRUE if the cell or value you have specified has #N/A error, else it will return FALSE.
- value A cell reference or a value which you want to test.
More Information on Excel ISNA Function
- It will only consider #N/A, ignore other error values.
- You can enter #N/A directly into the function.
In the below example, we have used ISNA to check different error values. we only got TRUE in the case of #N/A error value.
To learn more about Excel ISNA Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.