ExcelBanter - Excel formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel formula (https://www.excelbanter.com/excel-discussion-misc-queries/45450-excel-formula.html)

Dave

Excel formula

What is the formula that brings back a zero for an empty cell instead of
0 0 #DIV/0!

Anne Troy

Try =if(iserror(formula),0,formula)
************
Anne Troy
www.OfficeArticles.com

"Dave" wrote in message
...
What is the formula that brings back a zero for an empty cell instead of
0 0 #DIV/0!

All times are GMT +1. The time now is 06:09 AM.