#N/A

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
 
P

Pete_UK

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
 
B

Bob Umlas

you can also set the printing to not show errors:
Page Setup/Sheet Tab/Display Cell Errors as <blank>
Bob Umlas
Excel MVP
 
P

Pete_UK

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
 
Top