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.
It means it gives alternate text instead of the above errors. you can use this IFERROR function to handle errors in a formula.
This tutorial 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.
IFERROR function is coming under Excel Logical Functions Category.
In the below given examples, you can easily understand how the IFERROR function works.
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.
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.
0 Comments
* 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.