+ Reply to Thread
Results 1 to 4 of 4

IF function with TEXT and multiple criteria

  1. #1
    Forum Contributor
    Join Date
    12-21-2004
    Posts
    202

    IF function with TEXT and multiple criteria

    If I am doing this wrong, I apologize. I posted a similar question earlier, which was immediately responded to and solved. Later, it was determined we need to tweek that, so I replied to that "solved issue". But since it doesn't come up like it needs assistance, I was afraid it didn't get answered, so I am putting a new post for my newer version of what I am looking for. If that is wrong, I apologize in advance. I looked for "help" on the subject of adding to a solved post, but couldn't find my answer.

    Here is what I need:

    E2 is an install date
    F2 is a disconnect date
    G2 is where I would like the status to show

    If E2 is populated, G2 should say "Active"
    If F2 is populated, G2 should say "Disc"
    If neither is populated, G2 should say "Vacant"

    Please note, when the disconnect date gets entered into F2, both F2 and E2 will now be populated.

    Thanks again for any assistance.
    Last edited by karstens; 07-26-2012 at 10:22 AM.

  2. #2
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,282

    Re: IF function with TEXT and multiple criteria

    Try

    =IF(E2<>"","Active",IF(F2<>"","Disc","Vacant"))

  3. #3
    Forum Contributor
    Join Date
    07-24-2009
    Location
    Valrico, FL USA
    MS-Off Ver
    Excel 2016
    Posts
    358

    Re: IF function with TEXT and multiple criteria

    An alternate formula to address the situation of F2 populated and E2 blank.

    =IF(COUNTA(E2:F2)=0,"Vacant",IF(COUNTA(E2:F2)=2,"Disc",IF(E2="","Missing Install Date","Active")))

  4. #4
    Forum Contributor
    Join Date
    12-21-2004
    Posts
    202

    Re: IF function with TEXT and multiple criteria

    Awesome...these formulas worked great. I am working on building the rest of the cells now.
    Thanks so much.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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