ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Help with #DIV/O! (https://www.excelbanter.com/excel-worksheet-functions/13291-help-div-o.html)

davidadiaz

Help with #DIV/O!
 

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


Steve


=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





All times are GMT +1. The time now is 04:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com