Excel Tips – How to Eliminate Divide by Zero Errors and Add Checkmarks in Excel 2010

Close

Excel Tips – How to Eliminate Divide by Zero Errors and Add Checkmarks in Excel 2010

In this tutorial we will cover two tips: how to eliminate divide by zero errors, and also how to add a checkmark, all in Excel 2010.

How to Eliminate Divide by Zero Errors

One question I’m asked is how to get rid of the divide by zero errors, #DIV/0!

It’s common to get #DIV/0! errors in worksheets that contain formulas with division operations. This error results from the divisor part of a division formula referring to a cell that is blank or has a zero value.

There is no perfect solution for this problem. Most times you’ll want to know if a formula is trying to divide a number by zero, but there may be times where you want to suppress this error for reporting purposes.

In the past we had to use one of these IF formulas to avoid this error.

=IF(D2=0,””,C2/D3) or =IF(D2=0,0,C2/D2)

But starting in Excel 2007, Excel introduced a new Excel function called IFERROR.

With this function you need include your formula only once.

=IFERROR(C2/D2,0) or =IFERROR(C2/D2,””)

You can modify the formula to display either a blank or a zero whenever the formula results in an error.

Keep in mind that, technically, a ‘blank’ or ‘zero’ answer is incorrect. You cannot divide a number by zero. Use this with caution.

How to Add Checkmarks

There are several ways to create a checkmark or checkbox in an Excel worksheet. Here are a few of them.

Insert a Symbol

1) From the Insert tab click the Symbol command in the Symbols group;

2) In the Symbol dialog box, on the Symbols tab, click the Font dropdown and select click Wingdings;

3) Scroll down to the bottom of the list and you will find find several check mark symbols. Select the symbol that you want, click the Insert button and then Close.

Using it’s Character Code with Wingdings Font

Change the font of the cells where you want to place the checkbox to Wingdings.

– Hold down the ALT key and type 0252 on the numeric keypad (not the top row of keys).

If you want a matching X…

Create checkmark in Excel 2007, 2010, 2013 – Hold down the ALT key and type 0251 on the numeric keypad.

You can also create the above two symbols in boxes.

Create checkmark in Excel 2007, 2010, 2013 – Hold down the ALT key and type 0254 on the numeric keypad.

Create red x in box in Excel 2007, 2010, 2013 – Hold down the ALT key and type 0253 on the numeric keypad.

Try changing to font color, bolding and increasing the font size.

Add a CheckBox control

You can add selectable Check Box controls on your worksheet which you can check or uncheck by clicking on them.

 

For more Excel tips check out How to Quickly Edit Formulas and How to Select All Cells Matching a Criteria.

If this article was of value to you, please comment below and share.

By the way, please be free to check out our own Facebook Fan Page: Bren & Mike Prosperity Tips.

Excel Tips - How to Quickly Edit Formulas And Data In Multiple Cells in Excel 2010

Author: Mike Marko
Twitter: @mikemarko1
Skype: r.mike.marko
Facebook: mike.marko.37
Facebook Fan Page: Bren & Mike Prosperity Tips
Email: info@intendhomes.com

Article: Excel Tips – How to Eliminate Divide by Zero Errors and Add Checkmarks in Excel 2010

Get Free Email Updates!

Signup now and receive an email once I publish new content.

I will never give away, trade or sell your email address. You can unsubscribe at any time.

About The Author

Mike Marko

We at IM Marketing Consultant Services are your total internet marketing solutions company. We can help you look at the "big picture" and optimize your internet marketing. I have six sigma lean training; and when you combine that with internet marketing, helps get results that affect your business bottom line. I practice Law of Attraction, and have been investing in real estate since 2008. We have learned to make online marketing the ultimate path to prosperity in business and love teaching it to others.