IFERROR function in excel - Excel in a minute – Basics of Excel for Beginners | Easy Tips & Trick

2 years ago
5

How to use IFERROR Function in Excel?

Linktr.ee : https://linktr.ee/excelyourexcel

Instagram: www.instagram.com/excelyourexcel/

**First 1000 Subscribers to get 1 Hour of Recorded session free of cost**

Please register yourself on following form: https://forms.gle/YgdfNJmxiLUx1fwc8

Video 4: How to use IFERROR Function in Excel?

In this video, we have explained you simple use case of “IFERROR Function”.

What Does It Do ?
You can use the IFERROR function to trap and handle errors in a formula. IFERROR returns a value you specify if a formula evaluates to an error; otherwise, it returns the result of the formula.

Syntax
= IFERROR(value, value_if_error)

The IFERROR function syntax has the following arguments:
 value Required. The argument that is checked for an error.
 value_if_error Required. The value to return if the formula evaluates to an error.
The following error types are evaluated: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!.

#ExcelEducation #ExcelTraining #ExcelTutorial #ExcelTips #ExcelSkills #ExcelLearning #ExcelClass #ExcelGuidance #ExcelBasics #ExcelInterview #Learn #Tips #Business #Learnathome #Online #Tutorial #Teaching #Motivation #Transpose
#MicrosoftOffice #MicrosoftExcel #Office365 #ExcelSpreadsheets
#Excelyourexcel #SuperExcel

Super Excel Basics Series - There are going to be multiple series, each consisting of 10 videos explaining basic excel tips and tricks.

Please like, comment, share and subscribe us to take full advantage of the series.

Loading comments...