G Guest Mar 6, 2006 #1 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?
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?
G Guest Mar 6, 2006 #2 Hi, Use an IF & OR with ISNA() function; =IF(OR(ISNA(A1),ISNA(B1)),0,A1-B1) Regards, Chris.
D Dave Peterson Mar 6, 2006 #3 =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? Click to expand...
=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? Click to expand...
G Guest Mar 6, 2006 #4 Try something like this: =IF(ISNA(A1-B1),0,A1-B1) Does that help? *********** Regards, Ron XL2002, WinXP-Pro
Try something like this: =IF(ISNA(A1-B1),0,A1-B1) Does that help? *********** Regards, Ron XL2002, WinXP-Pro
