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

“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|

Question

Asked 6/15/2011 7:29:47 PM

0 Answers/Comments

Rating

There are no new answers.

17,971,225 questions answered

There are no comments.