Professor Excel

IFERROR: How to Handle Error Messages in Excel

When your formula produces an error in Excel – for example #N/A or #VALUE? – you got two options: Solve the error or use it in your calculation. Solving is usually a good idea but not always possible. So let’s take a look at how to deal with errors in Excel formulas using the IFERROR formula.

[…]

How to Solve Errors in Excel

A troublesome topic when it comes to creating large Excel models is Error Checking. Excel offers an Error Checking function in the Formulas ribbon which let’s you jump to the next error. Error in this case are all the cells showing an Excel error message as #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, and #VALUE!.

How to Deal with Circular References in Excel

You opened an Excel file and it immediately showed an error message saying that there is a circular reference. What to do now?