To show "0" instead of #N/A

widman · Mar 6, 2006

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?

Chris Marlow · Mar 6, 2006

Hi,

Use an IF & OR with ISNA() function;

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

Regards,

Chris.

Dave Peterson · Mar 6, 2006

=if(iserror(a1-b1),0,a1-b1)

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?

Ron Coderre · Mar 6, 2006

Try something like this:

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

Does that help?

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

XL2002, WinXP-Pro