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 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 for
http://bit.ly/1PbyQAq

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s