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

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

written by Mike Marko

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 to 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 drop-down and select click Wingdings;

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

Using its 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 the 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.

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

 

P.S. – If you like this post, feel free comment down below and/or share on Facebook.

Free Bootcamp Training Mini-Course

Suggested Articles:
1. Excel Tips – How to Quickly Edit Formulas And Data In Multiple Cells in Excel 2010
2. Excel Tips – How to Select All Cells Matching A Criteria in Excel 2010
3. Your Guide on How to Make Money Blogging

 

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

Author: Mike Marko
Click here to contact Mike
www.IMConsultantServices.com

If you are interested in learning how to make money online, click the following links to learn more about the IPAS2, and get the information to form your own opinion from this Empower Network Review, and Jeunesse.

If you want help marketing online, then check out our services at IM Consultant Services.

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

Facebook Comments