Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DIsplay a value of the cell calculation is #N/A
I have numerious calculations occuring in cells. Many times if certain values
cannot be calculted, #N/A appears. I would like the field to display "Null" or "Nothing" if the error appears. How can this be done? I want a different display instead of #N/A. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
DIsplay a value of the cell calculation is #N/A
One way:
Assuming your original formula is something like: =VLOOKUP(A1,J:K,2,FALSE) you can trap the error: =IF(ISNA(MATCH(A1,J:J,FALSE)),"Nothing",VLOOKUP(A1 ,J:K,2,FALSE)) In article , BZeyger wrote: I have numerious calculations occuring in cells. Many times if certain values cannot be calculted, #N/A appears. I would like the field to display "Null" or "Nothing" if the error appears. How can this be done? I want a different display instead of #N/A. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
DIsplay a value of the cell calculation is #N/A
Add the ISNA function.
e.g. =IF(ISNA(VLOOKUP(H9,$C$2:$F$35,3,FALSE)),"",VLOOKU P(H9,$C$2:$F$35,3,FALSE)) Will return a blank looking cell if result is #N/A For "Null" type Null between the double quotes in formula Gord Dibben MS Excel MVP On Wed, 17 Oct 2007 14:56:02 -0700, BZeyger wrote: I have numerious calculations occuring in cells. Many times if certain values cannot be calculted, #N/A appears. I would like the field to display "Null" or "Nothing" if the error appears. How can this be done? I want a different display instead of #N/A. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
DIsplay a value of the cell calculation is #N/A
On Oct 17, 5:56 pm, BZeyger wrote:
I have numerious calculations occuring in cells. Many times if certain values cannot be calculted, #N/A appears. I would like the field to display "Null" or "Nothing" if the error appears. How can this be done? I want a different display instead of #N/A. =IF(ISNA(yourCalculation),"",yourCalculation) or =IF(ISNA(yourCalculation),"Null",yourCalculation) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In excel can I display a cell based on a calculation (eg M(14/2)? | Excel Programming | |||
Can I display a cell based on a calculation (eg M(14/2)? | Excel Worksheet Functions | |||
Save cell display but not calculation | New Users to Excel | |||
Using rounded numbers for display, but not for the calculation. | Excel Discussion (Misc queries) | |||
IF formula to display a product of a calculation | Excel Programming |