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