+ Reply to Thread
Results 1 to 5 of 5

IF Statement for contains a word

  1. #1
    Registered User
    Join Date
    01-16-2015
    Location
    North Carolina, USA
    MS-Off Ver
    2007
    Posts
    22

    IF Statement for contains a word

    I need to write an IF Statement to fill cell in Column C with the same number found in Column B, IF the cell in Column A contains the word "Pending". I can do this with no problem if Column A cell just says "Pending", HOWEVER Column A will never ONLY say "Pending"; whenever the cell in Column A contains the word pending, it will always include additional words; so I cannot figure out how to write the IF statement. Any help is appreciated.

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Need Help With a Basic IF Statement

    Try...

    =IF(ISNUMBER(SEARCH("Pending",A1)),B1,"")
    HTH
    Regards, Jeff

  3. #3
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: IF Statement for contains a word

    Or:

    =IF(COUNTIF(A1,"*Pending*"),B1,"")

  4. #4
    Registered User
    Join Date
    01-16-2015
    Location
    North Carolina, USA
    MS-Off Ver
    2007
    Posts
    22

    Re: Need Help With a Basic IF Statement

    Perfect, Jeff. Thank you.

  5. #5
    Registered User
    Join Date
    01-16-2015
    Location
    North Carolina, USA
    MS-Off Ver
    2007
    Posts
    22

    Re: IF Statement for contains a word

    Thank you, 63falcondude.

+ 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] Exclude cells containing a word from a COUNTA statement
    By Bosulli in forum Excel General
    Replies: 5
    Last Post: 03-08-2018, 11:20 AM
  2. Loops and conditional statement in word macor
    By BS Singh in forum Word Programming / VBA / Macros
    Replies: 4
    Last Post: 11-18-2014, 06:57 AM
  3. Including the word ZERO in IF statement
    By doran79 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-26-2014, 09:02 PM
  4. IF statement containing certain word/pattern
    By marshymell0 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 06-13-2013, 03:51 PM
  5. [SOLVED] If Statement to search a certain word in a group
    By trosasco in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-06-2013, 05:20 PM
  6. if then statement in word form
    By justinhampton81 in forum Word Formatting & General
    Replies: 1
    Last Post: 08-25-2011, 10:27 AM
  7. IF Statement and ADD Word
    By meyero90 in forum Excel General
    Replies: 4
    Last Post: 05-06-2010, 08:07 AM

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