Maggie,

Try a formula like

=IF(A2=0,0,A1/A2)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"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