+ Reply to Thread
Results 1 to 2 of 2

If > Indirect > Match Formula - Can I include an OR function?

  1. #1
    Registered User
    Join Date
    12-31-2015
    Location
    London
    MS-Off Ver
    MS Office 2010
    Posts
    10

    If > Indirect > Match Formula - Can I include an OR function?

    This is the formula that this forum taught me awhile ago to deal with a complex problem:

    Please Login or Register  to view this content.
    What I have realised is that I actually have more than 1 date changing event. So I wondered whether I could make this formula more complex by adding an OR function perhaps (I am guessing here)?

    Please Login or Register  to view this content.
    I don't think this will work, and I am hoping someone can offer a suggestion or solution.

    If context helps. I will try and give an example of what I am trying to achieve (please ignore the fact that the entire set-up is illogical):

    The package will be delivered 14 days after order was made: 27/01/2015 (Date1)
    What day range are you not available? 23/01/2015 (Date2) to 29/01/2015 (Date3)
    What day range is no-one available? 22/01/2015 (Date4) to 31/01/2015 (Date5)

    Date1 will need to be amended (hence my original code) depending on whether Date2 is before or after the delivery date.

    The problem I have now is that I need to do the same for Date4, and if at all possible, within the same cell.

    Any help would be appreciated as always.
    Last edited by Drakanish; 02-17-2016 at 08:54 AM. Reason: Title

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,575

    Re: Forum taught to me by this forum, requires a tweak

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

+ 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] Forum Expert to Forum Guru
    By NeedForExcel in forum The Water Cooler
    Replies: 4
    Last Post: 09-16-2015, 09:02 AM
  2. Hi All... I am new to this forum and I have a purpose to join this forum.
    By sansri005 in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 09-04-2015, 04:57 AM
  3. Forum Expert vs Forum Guru
    By TMS in forum The Water Cooler
    Replies: 21
    Last Post: 07-02-2013, 08:18 PM
  4. This forum requires that you wait 30 seconds between searches
    By Pepe Le Mokko in forum Suggestions for Improvement
    Replies: 2
    Last Post: 04-07-2013, 11:49 PM
  5. New to the forum, Old (and self taught) to Excel
    By skiwoods in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 03-09-2013, 11:27 AM
  6. Replies: 22
    Last Post: 10-31-2012, 01:29 PM
  7. New to the Forum, Self taught on Excel
    By 1crazycajun in forum Hello..Introduce yourself
    Replies: 3
    Last Post: 08-14-2012, 09:01 PM

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