+ Reply to Thread
Results 1 to 3 of 3

If Statement help

  1. #1
    Registered User
    Join Date
    10-30-2017
    Location
    Lexington Park, MD
    MS-Off Ver
    2016
    Posts
    7

    Angry If Statement help

    I have hit a wall on this if statement. I have a bunch of items to choice from in F and based off of those must add a certain number of days to date in H with output to I. I have gotten it to do this so far by the below formula, but if there is a value in F but no date in H it gives a date that is wrong. I would like to add an option that if H is blank output is nothing.


    =IF(OR(F2="T3",F2="T3R",F2="NACLC", F2="ANACI"),(H2+3558),IF(OR(F2="SSBI",F2="PPR",F2="SBPR",F2="T5",F2="T5R"),(H2+2098)))

  2. #2
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Re: If Statement help

    =if(h2>0,if(or(f2="t3",f2="t3r",f2="naclc", f2="anaci"),(h2+3558),if(or(f2="ssbi",f2="ppr",f2="sbpr",f2="t5",f2="t5r"),(h2+2098))),"")

  3. #3
    Registered User
    Join Date
    10-30-2017
    Location
    Lexington Park, MD
    MS-Off Ver
    2016
    Posts
    7

    Re: If Statement help

    OMGOSH thank you so much!!!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] i have an if then statement that works, how to make it work as a with or case statement
    By dmcgov in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 06-03-2016, 03:34 PM
  2. [SOLVED] If statement to select data - nested statement - assistance
    By petitesouris in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-29-2015, 09:55 PM
  3. compile error expected line number statement end statement
    By mattress58 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-18-2014, 10:12 AM
  4. VBA Compile Error : line number or label or statement or end of statement
    By excellearner121 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-04-2013, 06:41 PM
  5. Replies: 4
    Last Post: 06-01-2012, 10:05 AM
  6. Replies: 4
    Last Post: 05-16-2012, 05:33 PM
  7. [SOLVED] Utilize a Select Case Statement in Target Intersect Statement
    By max57 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-29-2009, 08:55 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1