Microsoft Office Forums - View Single Post - [Solved] Hide Divide by Zero Option?

Thread: [Solved] Hide Divide by Zero Option?

View Single Post

Old

12-13-2013, 02:26 PM

SteveBump

SteveBump is offline

SteveBump uses Windows 7 64bit

Windows 7 64bit SteveBump uses Office 2010 64bit

SteveBump uses Office 2010 64bit

Office 2010 64bit

Novice

The original poster

Join Date: Oct 2013

Posts: 24

SteveBump is on a distinguished road

Default

Hide Divide by Zero Option?

I've seen a few tips on how to hide "#DIV/0!" using an IF statement. I.e., =IF(A2=0,"",A1/A2)

Any chance Microsoft has decided to make this a global option so it could be checked once rather than applying an IF statement to all of the cells where the calculation might apply?

Reply With Quote