What is the use of IFERROR function?
IFERROR Function in Excel check a value and it returns the value if there is no error or else it returns the specified value_if error
What is the syntax of IFERROR function?
IFERROR( value, value_if_error )
value : value to be checked
value_if_error : value to be returned if the given value is error
IFERROR Function in Excel – Examples
Example 1: Returns the actual value 2000 as it is not found any error
Example 2: Returns “error” asthe given value is an error
Example 3: Returns the actual value 4000 as it is not found any error
Example 4: Returns “error” asthe given value is an error
Reference:
Please refer the below article for more Logical Excel functions.
Logical Excel Formulas
Please refer the below article for more Excel Functions.
Excel Formulas | Home
Save Up to 85% LIMITED TIME OFFER
A Powerful & Multi-purpose Templates for project management. Now seamlessly manage your projects, tasks, meetings, presentations, teams, customers, stakeholders and time. This page describes all the amazing new features and options that come with our premium templates.
