In this article, we will learn where and how we can use Excel formula IFERROR.
What is IFERROR function?
The IFERROR function Returns a value you specify if a formula evaluates to an error;
otherwise, returns the result of the formula.
Where do we use IFERROR function?
We use this function when we want to show value or any other text instead of error.
How do we use IFERROR function?
Let’s take an example and understand:-
We have agent’s sales data, in which we have details of Agent name, No. of sales, sales amount. For few agents, we do not have no. of sales so cells are blank and we want to return average sales amount for every agent.
In Excel, if we divide the one cell with the blank cell then formula returns #DIV/0! Error as result. As shown in below image:-
Now we want that if we divide the sales amount with no. of sales then formula should return blank instead of #DIV/0!
To ignore #DIV/0! Error, we will use IFERROR function; follow below steps:-
Conclusion: - Whenever you want to ignore error while using the function and formulas in Excel, you can use this formula.
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at firstname.lastname@example.org
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.