Try something like this:

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

Does that help?

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

XL2002, WinXP-Pro


"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?