Hi,

Use an IF & OR with ISNA() function;

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

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Master


"widman" wrote:

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?