ZERO VALUES

[Guest]

--A1=1 AND A2=1 AND WHEN I DIVIDE A1 BY A2 THEN IN A3 I GET 1. HOWEVER, WHEN
BOTH A1 AND A2 EQUAL ZERO THEN I WOULD LIKE A3 TO EQUAL ZERO IN STEAD OF THE
#DIV/0 VALUE WHEN BOTH ARE ZERO. SO THERE STILL
NEEDS TO BE A DIVISION CALCULATION BUT WHEN THEY ARE BOTH ZERO IT WOULD THEN
BE ZERO IN A3.--


Maggie

 

[Anne Troy]

=if(iserror(yourformula),0,yourformula).
************
Anne Troy
www.OfficeArticles.com

 

[Guest]

YOU ARE A LIFE SAVER. THANK YOU!!!!!
--
Maggie

=if(iserror(yourformula),0,yourformula).
************
Anne Troy
www.OfficeArticles.com

 

[Anne Troy]

Cool. But I'd much rather be a Snickers!!
Glad to help.
************
Anne Troy
www.OfficeArticles.com

 

[Guest]

Here is my formula:

Specificity %([Sum Of SumOfTrue (-)]/([Sum Of SumOfTrue (-)]+[Sum Of
SumOfFalse (+)]))*100)

In my case, the Sum of SumOfTrue (-) will sometimes be a sum of zero but any
of these totals could have a zero sum.

Thanks for any and all help.