+ Reply to Thread
Results 1 to 3 of 3

Help for if condition formula result only either hit or miss from mulitple condition

  1. #1
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010
    Posts
    497

    Help for if condition formula result only either hit or miss from mulitple condition

    Hi any one help me out i little find difficulties to solve it
    i enclosed excel sheet with this thread

    i want result either (hit or miss)
    "if its tier 1 in a column check - if activity start date/time less than (10:00:00 a.m) then check also activity date/end date should be completed same day activity before (23:00:00 pm)
    if its tier 1 in a column check - if activity start date/time greater than (10:00:00 a.m) then check also activity date/end date should be completed next day activity before (23:00:00 pm)


    eg. If activity start time is 4/5/2013 9:30 am then end time should be same day 4/5/2013 22:59 pm result hit , if not met condition miss.
    Eg. If activity start time is 4/5/2013 10:30 am then end time next day 4/6/2013 23:00:00 result hit if not met condition miss."



    "if its (tier 2 or 3 or 4) in a column check - if activity start date/time less than (10:00:00 a.m) then check also activity end date/time should be completed next day activity before (23:00:00 pm)
    if its (tier 2 or 3 or 4) in a column check - if activity start date/time greater than (10:00:00 a.m) then check also activity end date/time should be completed after twoday from activity start date -time should before (23:00:00 pm)


    eg. If activity start time is 4/5/2013 9:30 am then end time should be next day 4/6/2013 before 22:59 pm -result hit , if not met condition miss.
    Eg. If activity start time is 4/5/2013 10:30 am then end time should be next two day 4/7/2013 23:00:00 - result hit if not met condition miss."
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Lemice's Avatar
    Join Date
    04-13-2013
    Location
    Somewhere.
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: Help for if condition formula result only either hit or miss from mulitple condition

    Hello,

    You can try this formula
    Please Login or Register  to view this content.
    Paste it on E2 and drag it down.

    Here is your sample with the formula.
    Attached Files Attached Files
    (copy pasta from Ford)
    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

    Regards,
    Lem

  3. #3
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010
    Posts
    497

    Re: Help for if condition formula result only either hit or miss from mulitple condition

    Ya Its works I want calculate sunday also if start date is saturday tier 1 same day or tier 2,3,4 monday 11pm

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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