+ Reply to Thread
Results 1 to 4 of 4

IS ERROR with nested if statement

  1. #1
    Registered User
    Join Date
    08-01-2012
    Location
    glasgow
    MS-Off Ver
    Excel 2003
    Posts
    14

    IS ERROR with nested if statement

    I'm trying to make the the following line

    Please Login or Register  to view this content.
    deal with error handling but i just can't seem to get the sytax for iferror correct. At the moment when C62 and E59,D59,C59 are blank I'm getting the #NUM error.

    Thanks for any help
    Last edited by renden; 08-06-2012 at 05:46 AM.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: IS ERROR with nested if statement

    Please Login or Register  to view this content.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: IS ERROR with nested if statement

    IFERROR will not work in 2003 version

    Use instead

    =IF(ISERROR(IF($C$62="",DATE($E$59,$D$59,$C$59),DATE($E$62, $D$62,$C$62))),"",IF($C$62="",DATE($E$59,$D$59,$C$59),DATE($E$62, $D$62,$C$62)))
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  4. #4
    Registered User
    Join Date
    08-01-2012
    Location
    glasgow
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: IS ERROR with nested if statement

    Thanks guys. Ace_XL code seems to do the job!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1