Learn to Debug Formulas in Excel
Learn to Debug Formulas in Excel
Learn to Debug Formulas in Excel

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
=IF(D5>22000,650,IF(D5>18000,450,250))

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?

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

three × two =

This site uses Akismet to reduce spam. Learn how your comment data is processed.