Learn to Debug Formulas in Excel
Have you ever wondered how to Debug a complex Formula and fix the error quickly?? We all know how painful it is when an excel formula returns a mysterious error and we don’t know what is causing it.
Assuming we have a simple formula like this
and we want to know whats happening with in the IF()
Select the cell with formula.
Now click on the formula bar
Just select the parts the formula and press F9 (for eg: the second if() formula)
This will evaluate only the selected part and replaces it with the result as shown in the pic
Using this technique you can narrow down the errors to particular range or values causing it.
Now that you know where the error is occurring you can wrap that part of formula with an ISERROR() formula to avoid unpleasant surprises.
What is your favorite way of handling errors?