Hiding #N/A
 

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

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

Mick


---
Outgoing mail is certified Virus Free by AVG.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.802 / Virus Database: 545 - Release Date: 26/11/2004

try this:

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

KL


"Mick" wrote in message
...
Can anyone help please with how to hide #N/A please?

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

Mick


---
Outgoing mail is certified Virus Free by AVG.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.802 / Virus Database: 545 - Release Date: 26/11/2004

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" <lapink2000(at)hotmail.com (former ) wrote in
message ...
try this:

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

KL


"Mick" wrote in message
...
Can anyone help please with how to hide #N/A please?

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

Mick


---
Outgoing mail is certified Virus Free by AVG.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.802 / Virus Database: 545 - Release Date: 26/11/2004





---
Outgoing mail is certified Virus Free by AVG.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.802 / Virus Database: 545 - Release Date: 26/11/2004

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)),"",VLOOKU P(A1,$B$1:$D$10,2,FALSE))

Regards,
KL


"Mick" wrote in message
...
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" <lapink2000(at)hotmail.com (former ) wrote in
message ...
try this:

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

KL


"Mick" wrote in message
...
Can anyone help please with how to hide #N/A please?

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

Mick


---
Outgoing mail is certified Virus Free by AVG.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.802 / Virus Database: 545 - Release Date: 26/11/2004





---
Outgoing mail is certified Virus Free by AVG.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.802 / Virus Database: 545 - Release Date: 26/11/2004

Mick

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

Select the cell or cells to CF

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

FormatFontColorWhite

OK your way out.

Gord Dibben Excel MVP

On Tue, 30 Nov 2004 09:09:13 -0000, "Mick" wrote:

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

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