Excel Tip > Excel Functions List > IFERROR Function in Microsoft Excel

IFERROR Function in Microsoft Excel

Fb-Button

In this article, we will learn how and where we can use Excel formula IFERROR.

IFERROR- This function is used when we get any error by using another formula or by doing the any calculation

The Syntax of IFERROR function: =IFERROR(Value,value_if_error)

Let’s take an example and understand how we can use Excel IFERROR formula.

We have fruits data in range A1:D6. Column A contains Fruits Name, Column B contains Kilograms, Column C contains Rate and in column D, we have returned the amount per kilogram.

image 1

 

Where kilogram is zero the formula is giving #DIV/0! Error. We need a formula that can produce the result as 0 if the kilogram is zero, else show the rate per kilogram.

Follow below given steps:-

  • Enter the formula in cell E2.
  • =IFERROR(C2/B2,"")
  • Press Enter on your keyboard.
  • Copy the same formula in the rest of the cells.
  • The function will return only value including 0.

image 2

 

By Using IFERROR formula, we can ignore error while calculation in Microsoft Excel.

xlsx-1567  Download-IFERROR-xlsx

Previous
Next

Leave a Reply

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

Related Excel Tips

Categories

Terms and Conditions of use

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.