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