=if(isna(YourFormula),"",YourFormula)
or, in Excel2007 and newer:
=iferror(YourFormula,"")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel











"rvtrails" wrote in message
...
I would like to format an #N/A result to a blank cell or with a 0 when
instead of the #N/A.

Can anyone assist in how to accomplish that?
Thanks!
Linda