What does =#N/A do in excel?

  • Thread starter Thread starter Rick
  • Start date Start date
R

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?
 
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
 
#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.
 
The actual formuala in the cell is =#N/A

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

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

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

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

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

Thanks
 
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.
 
Back
Top