Q: How do you troubleshoot a formula that is giving you an error in Excel?

A: “Trial and Error” has to be the most effective ways to learn something new. Most of the stuff I learned in my life is through that. Be it insurance or excel or programming. My learning has always gone up when I make a mistake. [ I am sure most you agree with me…
So in this installment of spreadcheats we will learn about errors. Those annoying #SOMETHING!s that you see when your excel formulas

have something wrong with them.
#DIV/0! Formula Error
This is the easiest of all. When you divide something with 0, you see this error. For eg. a cell with the formula =23/0 would return in this error.
How to fix #DIV/0 error?
Simple, do not divide the value by Zero. You know the answer anyway.
#NAME? Formula Error ]

Expert answered|jher000|Points 3020|

Rating

There are no new answers.

26,915,581 questions answered

There are no comments.