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!
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.