software

If cel C1 is A1-B1, how can I get C1 to show 0 if one of A1 or B1 is #N/A
instead of C1 ending up also #N/A?Hi,

Use an IF amp; OR with ISNA() function;

=IF(OR(ISNA(A1),ISNA(B1)),0,A1-B1)

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Masterquot;widmanquot; wrote:

gt; If cel C1 is A1-B1, how can I get C1 to show 0 if one of A1 or B1 is #N/A
gt; instead of C1 ending up also #N/A?
gt;

=if(iserror(a1-b1),0,a1-b1)
widman wrote:
gt;
gt; If cel C1 is A1-B1, how can I get C1 to show 0 if one of A1 or B1 is #N/A
gt; instead of C1 ending up also #N/A?

--

Dave Peterson

Try something like this:

=IF(ISNA(A1-B1),0,A1-B1)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;widmanquot; wrote:

gt; If cel C1 is A1-B1, how can I get C1 to show 0 if one of A1 or B1 is #N/A
gt; instead of C1 ending up also #N/A?
gt;