One way:

=IF(ISNA(your_formula(...)),0,your_formula(...))

--
Biff
Microsoft Excel MVP


"scott" wrote in message
...
In my ss I am using Lookup. It is doing just want I want it to do except
in
some cells I am getting a #N/A erro. Is there away to show this error as a
zero. Thanks