+ Reply to Thread
Results 1 to 3 of 3

If/and/or combo?

  1. #1
    Registered User
    Join Date
    09-14-2015
    Location
    dundee
    MS-Off Ver
    2003
    Posts
    3

    If/and/or combo?

    For the passed few hours I have been racking my brains to the point it hurts and am doubting whether or not this can be done, although I am sure it can.

    I think I am looking at a series of if/and/or functions?

    I have a spreadsheet that is has a start date(A1), 3 month date(b1),6 month date (c2), and 12 month date(d2)

    I am looking to have a formula that will apply a 1,2,3,or 4 to cell E2 dependent on the time frame.

    If today's date is less than the 3 month date = 1
    If today's date is greater than 3 month date but less than 6 month date = 2
    if today's date is greater than 6 month date but less than 12 month date = 3
    If todays date is greater than 12 month date = 4

    I think I have the individual formula sorted, which I have put below but I am baffled as to how I can link these all together?

    =today()<A1 = 1
    =if(and(today()>A1,today()<B1,2,"")
    =if(and(today()>c1,today()<d1,3,"")
    =today()>f1=4

    If anyone can help with this at all it would be greatly appreciated, my head is bursting trying to solve this!

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: If/and/or combo?

    How about:

    Please Login or Register  to view this content.
    Cheers,
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

  3. #3
    Registered User
    Join Date
    09-14-2015
    Location
    dundee
    MS-Off Ver
    2003
    Posts
    3

    Re: If/and/or combo?

    Gave it a shot but appears to be giving me a #N/A

+ 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. VBA Userform combo box - need to enable user to add new item if not listed in combo box
    By theshybutterfly in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-14-2015, 07:25 PM
  2. Replies: 19
    Last Post: 09-06-2014, 06:30 PM
  3. Populate 2nd combo with alpha based on 1st combo with 2 columns of numeric codes
    By dovermac in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-15-2014, 10:09 AM
  4. Replies: 8
    Last Post: 12-26-2013, 02:23 PM
  5. [SOLVED] Excel 2010 VBA – Combo Box Options– Clear cell/box in 2nd Combo when 1st Combo selected
    By theshybutterfly in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-17-2013, 07:25 PM
  6. [SOLVED] How to reference a second Combo box’s output based on previous Combo Box’s Row source
    By subbby in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-28-2012, 11:27 AM
  7. [SOLVED] Filtered list for Combo Box ListFillRange - Nested Combo Boxes
    By DoctorG in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-23-2006, 08:20 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1