What does =#N/A do in excel?

[Rick]

I have in a cell =#N/A and it displays a value however I don't quite
understand what the formula is doing? Any insights?

 

[Ashish Mathur]

Hi,

What is the formula in the cell?

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Jacob Skaria]

Hi Rick

Your formula has returned an unexpected value. You can handle this using the
function ISNA() which returns True if the formula returns #N/A.

Let us know the scenario and formula to check why the #N/A occurs

If this post helps click Yes

 

[Fred Smith]

#N/A means "Not available". It's most commonly returned from a lookup where
the search value is not found. However, there are other reasons, all
explained in Help.

If you want more specifics, post the formula which gave the error.

Regards,
Fred.

 

[Rick]

The actual formuala in the cell is =#N/A

I am unable to determine how it is returning a value in the cell?

Thanks

 

[Rick]

The actual formuala in the cell is =#N/A

I am unable to determine how it is returning a value in the cell?

Thanks

 

[Rick]

The actual formuala in the cell is =#N/A

I am unable to determine how it is returning a value in the cell?

Thanks

 

[Rick Rothstein]

This is what the help files say about the NA function, which what you posted
is an alternate for (see the Remarks section)...

Returns the error value #N/A. #N/A is the error value that means "no value
is available." Use NA to mark empty cells. By entering #N/A in cells where
you are missing information, you can avoid the problem of unintentionally
including empty cells in your calculations. (When a formula refers to a cell
containing #N/A, the formula returns the #N/A error value.)

Syntax: NA( )

Remarks
===========
- You must include the empty parentheses with the function name. Otherwise,
Microsoft Excel will not recognize it as a function.

- You can also type the value #N/A directly into a cell. The NA function is
provided for compatibility with other spreadsheet programs.