Hiding #N/A

  • Thread starter Thread starter Mick
  • Start date Start date
M

Mick

Can anyone help please with how to hide #N/A please?

I have tried conditional formatting but cant get the settings right.
 
Thanks "KL"

I'm sorry I must be missing something.

I have tried entering your suggestion in both conditional formatting and
directly in a cell using "My Formula" and neither seem to work (most likely
me at fault).

Can you help further please?

Regards

Mick
 
Mick,

If for example your formula that returns #NA! is
=VLOOKUP(A1,$B$1:$D$10,2,FALSE), then do this

=IF(ISNA(VLOOKUP(A1,$B$1:$D$10,2,FALSE)),"",VLOOKUP(A1,$B$1:$D$10,2,FALSE))

Regards,
KL
 
Mick

Either trap for the error as KL shows or if you want to use CF.......

Select the cell or cells to CF

CF>Formula is: =ISNA(cellref) Remove $ signs if Excel sticks them in
cellref.

Format>Font>Color>White

OK your way out.

Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conditional format cells with formula 11
Inside Base Series Label Showing #N/A 0
Conditional Formatting #n/a 2
Hiding or changing #N/A value 9
Hide Columns based on a cell value 10
Access Textbox - Hide Cursor 0
conditional formatting - problem with text cell value from formula 2
Set add function ignore #N/A 1

Back
Top