+ Reply to Thread
Results 1 to 4 of 4

Multiple logical test - excel problem help please

  1. #1
    Registered User
    Join Date
    09-18-2015
    Location
    Malaysia
    MS-Off Ver
    EXCEL 2013
    Posts
    20

    Multiple logical test - excel problem help please

    Hi, i am stuck in the formula.
    A = TARGET COMPLETION DATE (example 15/09/2015)
    B = ACTUAL COMPLETION DATE (example 14/09/2015)
    C = STATUS (MEET SCHEDULE OR BEHIND SCHEDULE)
    D = A cell which able to show ICON SETS base on data from C. If Meet Schedule, show a Green Circle. If Behind Schedule, show a Red Circle.

    I want to create a formula to justify C.
    Condition as following:

    if A or B is blank, then C = blank.
    But:
    if B<=A, then C = MEET SCHEDULE
    if B>A, then C = BEHIND SCHEDULE

    Please help.....

  2. #2
    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
    52,926

    Re: Multiple logical test - excel problem help please

    Hi, welcome to the forum

    perhaps this...

    =if(OR(A1="",B1=""),"",if(B1<=A1,"MEET SCHEDULE","BEHIND SCHEDULE"))
    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

  3. #3
    Registered User
    Join Date
    09-18-2015
    Location
    Malaysia
    MS-Off Ver
    EXCEL 2013
    Posts
    20

    Re: Multiple logical test - excel problem help please

    THANKS. Any idea on the Red and green icon?

  4. #4
    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
    52,926

    Re: Multiple logical test - excel problem help please

    Take a look at using Conditional Formatting for that

+ 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. Logical test false values skip to next row for next test
    By Schecter89 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-23-2018, 06:36 AM
  2. Logical test, vlookup +several items problem
    By Bernis in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-18-2014, 03:21 AM
  3. IF function performing logical test on multiple cells
    By Omni in forum Excel - New Users/Basics
    Replies: 11
    Last Post: 12-01-2012, 01:37 AM
  4. Logical test problem
    By itsunclebill in forum Excel General
    Replies: 5
    Last Post: 02-08-2010, 10:03 AM
  5. Logical test function problem
    By VwmanTom in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-10-2008, 07:19 PM
  6. Logical test function problem
    By VwmanTom in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-09-2008, 10:58 PM
  7. [SOLVED] Logical Test if statements with text--Excel 2002
    By Don Guillett in forum Excel General
    Replies: 3
    Last Post: 11-02-2005, 07:35 PM
  8. [SOLVED] How do I use Roundup in a logical test in excel
    By DC in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-09-2005, 02:06 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