ExcelBanter - #div/0!

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

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

- - #div/0! (https://www.excelbanter.com/excel-discussion-misc-queries/173215-div-0-a.html)

Dave

#div/0!

How can you suppress the #DIV/0! error

Mike H

#div/0!

Test for zero

=IF(B1=0,"",A1/B1)

Mike

"Dave" wrote:

How can you suppress the #DIV/0! error

All times are GMT +1. The time now is 10:39 AM.