Get Excel to Remove The Dreaded #DIV/0 Error

BY STANLEY ZAROWIN

Q. I prepare model Excel spreadsheets for different groups of people who generally are not—how should I say it—financially or spreadsheet nimble. So when they see that dreaded #DIV/0 error they panic, even though I’ve explained to them that all it means is that Excel (or anyone else, for that matter) can’t divide a number by 0 and Excel shows it as an error by displaying #DIV/0. Is there a way to eliminate that error message?

A. Well, you can’t change the fundamental laws of mathematics, but you can program Excel to explain to novice users what they must do to correct the “error.” One easy way is to apply the IF() function so that if someone tries to divide a number by 0, instead of showing the dreaded #DIV/0, the cell’s message will read something like this: “Please enter a divisor other than 0.” The formula to do that is:

IF(DIVISOR = 0, “Please enter a divisor other than 0”, DIVIDEND/DIVISOR)

So, if you’re dividing B2 by C2, the formula would be:

=IF(C2=0,“Please enter a divisor other than 0”,B2/C2)

This is what it looks like in Excel—with and without the IF formula:

Of course, you can tailor the message to say something else.

Shortcuts

A fast way to find a name in your Windows’ address books: Click on Start, Search (in Windows 98, it’s Find ), People to open this window:

Highlight People and enter the name (first, last or both) and your computer will search all the Windows databases for matches. Once the name is found, click on Add to address book and it does just that.

To delete a file without it’s automatically going to the Recycle Bin, hold down the Shift key while pressing Delete.

To return to the place in a document where you left off before saving, open the document and press Shift+F5.

For a full list of all the Word commands, their descriptions and default shortcuts, go to www.mvps.org/word/FAQs/General/CommandsList.htm . The list is downloadable in Excel format.

SPONSORED REPORT

How to make the most of a negotiation

Negotiators are made, not born. In this sponsored report, we cover strategies and tactics to help you head into 2017 ready to take on business deals, salary discussions and more.

VIDEO

Will the Affordable Care Act be repealed?

The results of the 2016 presidential election are likely to have a big impact on federal tax policy in the coming years. Eddie Adkins, CPA, a partner in the Washington National Tax Office at Grant Thornton, discusses what parts of the ACA might survive the repeal of most of the law.

QUIZ

News quiz: Scam email plagues tax professionals—again

Even as the IRS reported on success in reducing tax return identity theft in the 2016 season, the Service also warned tax professionals about yet another email phishing scam. See how much you know about recent news with this short quiz.