Formula to Check if a Cell Contains #N/A
Sometimes you will have a formula in a series of cells and in some of those cells there is an error and the cell displays #N/A. #N/A indicates "Not Applicable" or "Not Available". #N/A can come in for a variety of reasons. In my case, I encountered it while using the VLOOKUP formula where the value could not be referenced.
Now in another cell I wanted to check if this cell had a proper value before proceeding with further operation. Suppose you have #N/A coming in from a formula in Cell C1, and you want to check if it has #N/A in another cell D1, then in cell D1, you can use the following formula:
=ISNA(C1)
or
\=ISERROR(C1)
Both these formulas return a TRUE or FALSE. WHile ISNA is specifically to catch #N/A error, ISERROR can be used to catch all kinds of errors such as #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!
I hope this helps!
Data Science in Finance: 9-Book Bundle
Master R and Python for financial data science with our comprehensive bundle of 9 ebooks.
What's Included:
- Getting Started with R
- R Programming for Data Science
- Data Visualization with R
- Financial Time Series Analysis with R
- Quantitative Trading Strategies with R
- Derivatives with R
- Credit Risk Modelling With R
- Python for Data Science
- Machine Learning in Finance using Python
Each book includes PDFs, explanations, instructions, data files, and R code for all examples.
Get the Bundle for $39 (Regular $57)Free Guides - Getting Started with R and Python
Enter your name and email address below and we will email you the guides for R programming and Python.