Results 1 to 1 of 1

The Logical function IFERROR in Microsoft Excel 2010

This is a discussion on The Logical function IFERROR in Microsoft Excel 2010 within the Applications forums, part of the Tutorials category; The Logical function IFERROR in Microsoft Excel 2010 After going through the following tutorial, you will be familiarized with the ...

  1. #1
    Senior Member
    Join Date
    Jun 2010
    Posts
    870

    Default The Logical function IFERROR in Microsoft Excel 2010

    The Logical function IFERROR in Microsoft Excel 2010


    After going through the following tutorial, you will be familiarized with the usage and the syntax of the IFERROR logical function that is present in Excel application.


    Description

    The IFERROR function when entered along with a formula returns a value that you specify if the formula evaluates to an error; otherwise it returns the actual result of the formula. You can make use of the IFERROR function to handle and Trap errors in formulas in Excel application.


    Syntax

    The IFERROR function has the following syntax

    =IFERROR(value, value_if_error)

    Where

    ‘value’ is the argument or the condition that you want to check for errors.

    ‘value_if_error’ is the value that you specify and want to be returned if the formula evaluates to an error. The following types of errors are evaluated: #NUM!, #NAME!, #REF!, #N/A, #VALUE! or #NULL!.


    NOTE: - if the value_if_error’ argument is omitted or empty, the IFEREROR function returns an empty string value (,,,). If the value argument is an array formula, the function returns an array of results for each cell that is specified in the value argument.


    Example

    Refer the figure below for examples on the IFERROR function


    Figure



    So, this is how you can use the IFERROR function to handle and trap errors in formulas in the Excel Application.



    Read other Applications
    Last edited by jagadish; 09-21-2010 at 01:17 PM.

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •