Hiding #N/A

[Mick]

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

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

 

[KL]

try this:

=IF(ISNA(yourFormula),"",yourFormula)

KL

 

[Mick]

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

 

[KL]

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

 

[Gord Dibben]

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