+ Reply to Thread
Results 1 to 6 of 6

Nested IF ISERROR Statement

  1. 12-02-2013, 05:11 PM #1
    dash11 is offline
    Registered User
    Join Date
    04-08-2011
    Location
    London
    MS-Off Ver
    O 365
    Posts
    80

    Nested IF ISERROR Statement

    I'm trying to write and IF(ISERROR statement that references a cell's text and determines it's value based off of that and a date cell. Here is what I have:
    =IF(ISERROR(IF(E5="1 - High",B5+2,IF(E5="2 - Medium",B5+5,IF(E5="3 - Low",B5+10))))," ",IF(E5="1 - High",B5+2,IF(E5="2 - Medium",B5+5,IF(E5="3 - Low",B5+10))))

    Column B is a Date Field and Column E is a text.
    Essentially, I'm wanting to say that if any cell in column E says "1 - High", then take the date in column B and add 2 to it. However, in a field where there is NOT a date in column B (or E), then just be BLANK.
    Reply With QuoteRegister To Reply
  2. 12-02-2013, 05:22 PM #2
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,049

    Re: Nested IF ISERROR Statement

    2007 onwards provides IFERROR() function, but it looks like just thhis will do for you?...
    =IF(countif(E:E,"1 - High")>0,B5+2,"")
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 12-02-2013, 05:22 PM #3
    Ron Coderre is offline
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Nested IF ISERROR Statement

    Try this regular formula:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    or maybe this
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    Does that help?
    Last edited by Ron Coderre; 12-02-2013 at 05:24 PM.
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules
    Reply With QuoteRegister To Reply
  4. 12-02-2013, 06:20 PM #4
    dash11 is offline
    Registered User
    Join Date
    04-08-2011
    Location
    London
    MS-Off Ver
    O 365
    Posts
    80

    Thumbs up Re: Nested IF ISERROR Statement

    Thank you kindly! I made corrections using your suggestions and the one that worked was: =IF(COUNTIF(E7,"1 - High"),B7+3,IF(COUNTIF(E7,"2 - Medium"),B7+7,IF(COUNTIF(E7,"3 - Low"),B7+14," ")))
    Reply With QuoteRegister To Reply
  5. 12-02-2013, 06:22 PM #5
    dash11 is offline
    Registered User
    Join Date
    04-08-2011
    Location
    London
    MS-Off Ver
    O 365
    Posts
    80

    Re: Nested IF ISERROR Statement

    Thanks for the suggestion Ron! I didn't get a chance to try it because the first suggestion worked but I'm going to file it away for future reference.
    Reply With QuoteRegister To Reply
  6. 12-03-2013, 03:11 AM #6
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167

    Re: Nested IF ISERROR Statement

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] need help with iserror in nested formula
    By dishguy05 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-18-2013, 12:39 PM
  2. [SOLVED] Nested IF AND statement with timestamp and ISERROR Help
    By LearningatWork in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-11-2012, 12:37 PM
  3. Nested ISERROR?
    By SAsplin in forum Excel General
    Replies: 5
    Last Post: 03-09-2012, 08:18 AM
  4. Nested IF(ISERROR statement
    By JYonker in forum Excel General
    Replies: 2
    Last Post: 12-30-2010, 04:49 PM
  5. Nested If iserror with V lookup?
    By barneyc in forum Excel General
    Replies: 7
    Last Post: 07-03-2009, 07:29 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1