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.
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.