Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-13-2013, 02:26 PM
SteveBump SteveBump is offline Hide Divide by Zero Option? Windows 7 64bit Hide Divide by Zero Option? Office 2010 64bit
Novice
Hide Divide by Zero Option?
 
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
  #2  
Old 12-13-2013, 08:00 PM
BobBridges's Avatar
BobBridges BobBridges is offline Hide Divide by Zero Option? Windows 7 64bit Hide Divide by Zero Option? Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Not that I've heard. And it isn't clear to me how they would—that is, it seems to me that everyone who wants to use it would like a different output. You want a null character string, but someone else might want a different calculation.

But that's speculation. To answer your question, I haven't heard any talk of such an option.
Reply With Quote
  #3  
Old 12-14-2013, 07:58 AM
SteveBump SteveBump is offline Hide Divide by Zero Option? Windows 7 64bit Hide Divide by Zero Option? Office 2010 64bit
Novice
Hide Divide by Zero Option?
 
Join Date: Oct 2013
Posts: 24
SteveBump is on a distinguished road
Default

Thanks for the reply. Rather than pick which format or option to choose, they could simply leave it up to the user. In other words:

Display #DIV/0! error as: _____________

And then the user could put in " ", 0, -, etc.

Oh well. Just a suggestion. Thanks again.
Reply With Quote
  #4  
Old 12-14-2013, 08:48 AM
BobBridges's Avatar
BobBridges BobBridges is offline Hide Divide by Zero Option? Windows 7 64bit Hide Divide by Zero Option? Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Ok, I have to admit that's a workable idea. I hadn't thought of that.
Reply With Quote
  #5  
Old 12-15-2013, 09:53 PM
macropod's Avatar
macropod macropod is online now Hide Divide by Zero Option? Windows 7 32bit Hide Divide by Zero Option? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by SteveBump View Post
Rather than pick which format or option to choose, they could simply leave it up to the user. In other words:

Display #DIV/0! error as: _____________

And then the user could put in " ", 0, -, etc.
No Excel version to date has supported that, and I doubt MS is about to introduce such a change - it would probably break backwards compatibility, meaning worksheets using it couldn't be used on older systems. Somehow I doubt users would welcome such unsupported features: (a) causing crashes; or (b) being converted to text instead of formulae.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to divide into group tomlam Excel Programming 2 05-20-2013 09:46 PM
Hide Divide by Zero Option? How to total 12 columns and divide them to get a percentage Triscia Word Tables 1 01-15-2013 07:39 AM
Hide Divide by Zero Option? 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 06:04 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft