The best way to do this is
=if(isna(myformula),"",myformula)

--
Don Guillett
SalesAid Software

"Todd" wrote in message
...
I am using a formula that returns #N/A frequently and I am wondering if
there is a way using conditional formatting or a different format feature
to
not have those returns show? All the #N/A make the worksheet look
cluttered.

TIA


Todd