# 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.