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