|
|
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
 |
|
|
Thread Tools | Display Modes |
Mar 30th, 2004, 02:33 PM
|
#1 |
|
Join Date: Jun 2002
Posts: 289
|
search for #N/A questions
Hi, I'm trying to find out how to replace #N/A results. I know that this was discussed in previous questions, but when I search for "#N/A" in the search box, I get no results? Could you tell me how to search and find those questions and answers?
|
|
|
|
Mar 30th, 2004, 02:38 PM
|
#2 |
|
MrExcel MVP
Join Date: Feb 2002
Location: California
Posts: 3,857
|
To get rid of N/A in cells you can
A) conditionally format the cells to hide N/A values (i.e. white text) b) use an if statement to check for the error. =If(ISNA(YourEquation,"",YourEquation) The second solution will replace the error with whatever you want, but it does have to evaluate the equation twice so it is less efficient. |
|
|
|
|
Mar 30th, 2004, 02:39 PM
|
#3 |
|
Join Date: Feb 2004
Posts: 70
|
Re: search for #N/A questions
what do you want to do?
do you want to avoid these kind of errors. give me some more info or look at following function "error.type(errorval)" regards |
|
|
|
|
Mar 30th, 2004, 02:42 PM
|
#4 |
|
MrExcel MVP
Join Date: Sep 2002
Location: Alabama/State of Disarray
Posts: 10,473
|
Re: search for #N/A questions
For a thoughtful commentary on how to avoid the #N/A return, see Aladin's posting here.
__________________
just_jon Book of the Month: I'm Not Really an MVP, I Just Play One on TV [j. jon, 2004] 
|
|
|
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
