## How to use the ISNA function

**What is the ISNA function?**

The ISNA function returns TRUE if the returned value is a #N/A error.

**What is a #N/A error?**

The #N/A error happens when a value is not available for a formula or found in a given cell range, for example in the VLOOKUP or MATCH functions.

**Other IS functions**

Excel Function | Description |
---|---|

ISBLANK(value) | Returns TRUE if the value is empty, FALSE otherwise |

ISERR(value) | Returns TRUE if the value is any error value except #N/A, FALSE otherwise |

ISERROR(value) | Returns TRUE if the value is any error value, FALSE otherwise |

ISEVEN(value) | Returns TRUE if the value is an even number, FALSE for odd numbers |

ISFORMULA(reference) | Returns TRUE if the cell contains a formula, FALSE otherwise |

ISLOGICAL(value) | Returns TRUE if the value is a logical value (TRUE/FALSE), FALSE otherwise |

ISNA(value) | Returns TRUE if the value is the #N/A error, FALSE otherwise |

ISNONTEXT(value) | Returns TRUE if the value is not text, FALSE if it is text |

ISNUMBER(value) | Returns TRUE if the value is a number, FALSE otherwise |

ISODD(value) | Returns TRUE if the value is an odd number, FALSE for even numbers |

#### Table of Contents

## 1. ISNA Function Syntax

ISNA(*value*)

## 2. ISNA Function Arguments

value |
Required. A cell reference pointing to the value you want to check for #N/A error. |

**What is a cell reference?**

A cell reference lets you "fetch" and use values in other cells in a formula.

There are two types of cell references:

- A1-style reference
- R1C1 reference

The A1-style reference is the default style in Excel, it names columns by letters from A to Z. After Z it starts over with AA, AB, and so on until XFD. Rows are numbered from 1 to 1048576, older Excel versions use less row numbers.

The R1C1-style uses row number and column number like: R1C1, R2C5 and R10C15. Rows are labeled R1, R2, R3 and so on, columns are labeled C1, C2, C3 etc.

The A1-style reference notation is the most common one, here are some examples:

A1 - single cell reference on the same worksheet

A1:D5 - reference to a cell range on the same worksheet

Budget!Z3 - a single cell reference to worksheet Budget

'Budget 2050'!A3 - a single cell reference to a worksheet containing a space character

There are two types of cell references:

- Relative cell references
- Absolute cell references

The examples above are all relative cell references, they change accordingly if a cell is copied and pasted to another cell which absolute cell references do not.

The $ dollar character lets you an absolute cell reference meaning you can lock a cell reference horizontally, vertically or both. Here is one example:

A$1 has a relative column reference but an absolute row reference, this means that the column letter may change if the cell is copied and pasted to cells in another column than A.

## 3. ISNA Function Example

Formula in cell C3:

### 'ISNA' function examples

First, let me explain the difference between unique values and unique distinct values, it is important you know the difference […]

Introduction In this post I am creating a spreadsheet that will calculate stock portfolio performance. To do this I am […]

### Functions in 'Information' category

The ISNA function function is one of many functions in the 'Information' category.

## How to comment

How to add a formula to your comment<code>Insert your formula here.</code>

Convert less than and larger than signsUse html character entities instead of less than and larger than signs.

< becomes < and > becomes >

How to add VBA code to your comment[vb 1="vbnet" language=","]

Put your VBA code here.

[/vb]

How to add a picture to your comment:Upload picture to postimage.org or imgur

Paste image link to your comment.

Contact OscarYou can contact me through this contact form