View Single Post
  #2   Report Post  
Steve
 
Posts: n/a
Default


=IF(ISERROR(your equation),0,your equation)

"davidadiaz" wrote in message
...

I need assistance with this entry. I get this #DIV/! in the middle of
of a calculation, which will not add up properly. How can I relace it
with a 0 (Zero), which then the calculation will then come out right.
Thanks to all


--
davidadiaz
------------------------------------------------------------------------
davidadiaz's Profile:
http://www.excelforum.com/member.php...o&userid=19980
View this thread: http://www.excelforum.com/showthread...hreadid=345692