Thursday, September 3, 2015

Excel Tips & Tricks: The Ugly “#DIV/0”

When you create formulas in Excel worksheets you will often find that your formula is set up correctly, but certain cells will return a result of “#ERROR,” “#N/A,” or “#DIV/0!.” These outputs are generally not desirable when sharing the worksheet with others.

Add the “IFERROR” function to your formula to dictate what is displayed instead ofthe error message. For example, to tell Excel to display “-“ instead of “#DIV/0” whenever it encounters a divide-by-zero error, write the formula as “=IFERROR(A1/B1,”-“) where the characters in quotes at the end are what will display if Excel formula results in an error.

No comments: