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.









Share:

No comments

Post a Comment

© UVAFinance | All rights reserved.
Blog Layout Created by pipdig