| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What does =#N/A do in excel?
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What does =#N/A do in excel?
Hi,
What is the formula in the cell? -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Rick" wrote in message ... 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What does =#N/A do in excel?
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 -------------- Jacob Skaria "Rick" wrote: 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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What does =#N/A do in excel?
#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" wrote in message ... 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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=#N/A question
The actual formuala in the cell is =#N/A
I am unable to determine how it is returning a value in the cell? Thanks |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=#N/A question
The actual formuala in the cell is =#N/A
I am unable to determine how it is returning a value in the cell? Thanks |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=#N/A question
The actual formuala in the cell is =#N/A
I am unable to determine how it is returning a value in the cell? Thanks |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What does =#N/A do in excel?
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. -- Rick (MVP - Excel) "Rick" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
