ZERO VALUES
 

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

ZERO VALUES
 

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

"Maggie" wrote in message
...
--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

ZERO VALUES
 

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


"Anne Troy" wrote:

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

"Maggie" wrote in message
...
--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

ZERO VALUES
 

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

"Maggie" wrote in message
...
YOU ARE A LIFE SAVER. THANK YOU!!!!!
--
Maggie


"Anne Troy" wrote:

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

"Maggie" wrote in message
...
--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

ZERO VALUES
 

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.


"Anne Troy" wrote:

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

"Maggie" wrote in message
...
YOU ARE A LIFE SAVER. THANK YOU!!!!!
--
Maggie


"Anne Troy" wrote:

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

"Maggie" wrote in message
...
--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