+ Reply to Thread
Results 1 to 4 of 4

IF statement with multiple true false variables

  1. #1
    Registered User
    Join Date
    07-29-2014
    Location
    Seattle, Washington
    MS-Off Ver
    MS 2010
    Posts
    2

    IF statement with multiple true false variables

    Hi all I need some assistance on a formula ive been trying to create for several hours...

    What I want to happen is to have the IF statement look at three cells, and if all meet the criteria then say "Complete", if not say "Incomplete"


    Two criteria are as follows
    IF(F4=G4="Reviewed") and IF(H4="Approved")
    How do I combine these two statements so that if both are met, it returns "Complete" and if one or the other or both aren't met, it returns "Incomplete"

    Thanks,
    Tom

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,498

    Re: IF statement with multiple true false variables

    try=if(and(f4="Reviewed",G4="reviewed,H4="approved"),"Complete","Incomplete")
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Registered User
    Join Date
    07-29-2014
    Location
    Seattle, Washington
    MS-Off Ver
    MS 2010
    Posts
    2

    Re: IF statement with multiple true false variables

    That worked, thanks much

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,498

    Re: IF statement with multiple true false variables

    Great, glad to help and thanks for the feedback.

+ 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. Replies: 3
    Last Post: 04-20-2014, 05:08 AM
  2. [SOLVED] I need an IF statement that has more than True and False
    By Legend Rubber in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-18-2012, 07:00 AM
  3. If statement with a range and true/false statement
    By aarleblanc in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-20-2012, 06:34 PM
  4. True false statement with dates
    By hrclark in forum Excel General
    Replies: 3
    Last Post: 10-18-2011, 11:42 AM
  5. calculating true false from group of variables
    By tammy25 in forum Excel General
    Replies: 5
    Last Post: 11-28-2010, 11: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