#N/A

  • Thread starter Thread starter Sven
  • Start date Start date
S

Sven

Somtimes with my formula's I have #N/A.
But when you print or show the file to someone, it doesn't look very nice
like that.

Can I put some extra formula in it of with conditional format?
I already thried with conditional format but I can't find it.

Thanks in advance

Greetz sven
 
If your formula is a VLOOKUP, for example, then you will get #N/A if
there is no exact match. You can get round it by:

=IF(ISNA(vlookup_formula),"",vlookup_formula)

Hope this helps.

Pete
 
you can also set the printing to not show errors:
Page Setup/Sheet Tab/Display Cell Errors as <blank>
Bob Umlas
Excel MVP
 
Thanks for feeding back, Sven.

Sven had emailed me directly, and I was able to help him to translate
into Dutch:

IF => ALS, ISNA => ISNB (for future reference in the archives).

Pete
 
Back
Top