View Single Post
  #4   Report Post  
RagDyer
 
Posts: n/a
Default Zero values in formula

One way:

=IF(A2,A1/A2,0)

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Maggie" wrote in message
...
My formula is A1/A2 however if they are both Zero values it is producing

the
#DIV/O! If there are Zeros in A1 and A2 how do I get the product to also

be
Zero in A3?


--
Maggie