Use IFERROR function in Excel to handle the Error Messages

Sometime you have a nice table and some cell will bring the error messages like the following ones:

#DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, and #VALUE!.

How can we replace them? For this Excel has the IFERROR function.

If Excel detects an error in your formula, it will allow you set the value of the cell to whatever value you want.

Look at the following example. We want to calculate the profit by substracting the B2-A2. But if B2 is not sold, then there is a error message saying #VALUE!

sales price error

So to handle this, we use the IFERROR(Value, Value if error). If there is an error, we enter "not sold yet".


This can also be done a bit differently with ISERR or ISERROR function.


So this was the base to handle errors and I hope it helped you.

Download the sheet from here.

Please Tweet, Like or Share us if you enjoyed.