Hide Divide by Zero Option?

		Microsoft Office Forums > Microsoft Excel > Excel
Hide Divide by Zero Option?

FAQ

Thread Tools

Display Modes

12-13-2013, 02:26 PM

SteveBump

Windows 7 64bit Hide Divide by Zero Option?

Office 2010 64bit

Novice

Join Date: Oct 2013

Posts: 24

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?

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to divide into group	tomlam	Excel Programming	2	05-20-2013 09:46 PM
How to total 12 columns and divide them to get a percentage	Triscia	Word Tables	1	01-15-2013 07:39 AM
formula divide by serio error	vthomeschoolmom	Excel	1	04-18-2012 02:29 PM
divide page into 4 parts	aclark17	Word	4	01-17-2012 09:04 AM
Divide by zero error	doublejoy	Excel	1	08-22-2009 03:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:53 PM.