software

When working with a formula at returns a #N/A I would like it to display a
quot;0quot; instead

=IF(ISNA(formula),0,formula)--

Regards,

Peo Sjoblom

nwexcelsolutions.com
quot;DarnTootnquot; gt; wrote in message
...
gt; When working with a formula at returns a #N/A I would like it to display a
gt; quot;0quot; instead
Try

=IF(ISNA(your formula),0,your formula)quot;DarnTootnquot; wrote:

gt; When working with a formula at returns a #N/A I would like it to display a
gt; quot;0quot; instead

Thank you for your help... it works for me... can't believe I had forgotten
that formula... anywho, thanks again

quot;Peo Sjoblomquot; wrote:

gt; =IF(ISNA(formula),0,formula)
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; nwexcelsolutions.com
gt;
gt;
gt;
gt; quot;DarnTootnquot; gt; wrote in message
gt; ...
gt; gt; When working with a formula at returns a #N/A I would like it to display a
gt; gt; quot;0quot; instead
gt;
gt;
gt;