search for #N/A questions

[poikl]

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?

[DRJ]

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.

[Patrick Alexander]

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

[just_jon]

For a thoughtful commentary on how to avoid the #N/A return, see Aladin's posting here.