|Connect us with


IFERROR in Excel

IFERROR In Excel | IFERROR Syntax | How to Use

Note:-Before starting any Formula or Function you need to add (=)

IFERROR Using this function we can replace errors like NA,#DIV/0!, etc..in formulas which means it gives alternate text instead of the above errors. you can use this IFERROR function to handle errors in a formula. This chapter describes the formula syntax and usage of the IFERROR function in Microsoft Excel. While applying some formula or Function in excel, if we get the above errors, we can use IFERROR to avoid these errors. this IFERROR function is coming under Excel Logical Functions Category.

Syntax:-=IFERROR(value, value_if_error)

In the below-given examples, you can easily understand how the IFERROR function works.

IFERROR Function in Excel

In the above example, I have some data and I am trying to get % of that data. but in one of those records, there is no target value. so in % column, it is showing #DIV/0! Error.

While using Vlookup in Excel, SUMIF in Excel, and IF Functions we may find this kind of errors. using IFERROR we can ignore those errors.

How IFERROR works in Excel Or How to give the alternate text to Errors using IFERROR Function?

IFERROR Function in Excel

Here what we did we just replaced that kind of error with IFERROR Function.we have added "No Target for this Record" instead of #DIV/0! Error. Similarly, we can replace our own text for these kinds of errors like #NUM!,#NAME?,#N/A,#VALUE!..etc

After watching the video you can download below sample sheet. and it helps you to do practice more. please subscribe for more videos on our youtube channel. if you like our tutorial please share it on Facebook and Youtube below.


To Get FREE Excel Shortcut Keys
       



Previous

Next



YOUR COMMENTS ARE MOST IMPORTANT TO US:

0 Comments



Why basictutorials.in ?

● To Learn Tutorials in a Simple Way.

● To Learn Excel Basics With Downloadable Samples.

● To Learn HTML With Sample Website Code.

● To Learn PowerPoint Presentations.

● To Learn MS Word for Offical use.