Thread: ZERO VALUES
View Single Post
  #1   Report Post  
Maggie
 
Posts: n/a
Default 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