+ Reply to Thread
Results 1 to 5 of 5

If statement formula with multiple condition

  1. #1
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 & Google Sheet
    Posts
    1,146

    If statement formula with multiple condition

    hi all,

    i am looking some if formula & how to figure it out this problem ;
    name--------expected result-------data1
    john---------- ok----------------- mark "-"
    mark "-"-------- mark "-"-----------mark "-"
    mark "-"--------- mark "_"----------george bush

    criteria :
    1) if col.a contains text and col.c contains mark "-"----result in col.b "ok"
    2) if col.a contains "-" and col.c contains "-" ----result in col.b "-"
    3) if col.a contains "-" and col.c contains text ----result in col.b "-"

    how make it with if statement?

    any assistance would greatly appreciated..

    john m

    cheers

  2. #2
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 & Google Sheet
    Posts
    1,146

    Re: If statement formula with multiple condition

    ups, sorry here corrected..

    only single column (name column)

    name-------expected result ;
    text ------- ok
    mark "-"----- mark "-"
    blank--------blank

    criteria :
    1) if col.a contains text ----result in col.b "ok"
    2) if col.a contains "-" ----result in col.b "-"
    3) if col.a contains blank ----result in col.b-- blank

  3. #3
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 & Google Sheet
    Posts
    1,146

    Re: If statement formula with multiple condition

    here workbook attached..
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    01-16-2014
    Location
    Istanbul, Turkey
    MS-Off Ver
    Excel 2010
    Posts
    35

    Re: If statement formula with multiple condition

    if formula problem.xlsxlook at attached pls

  5. #5
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 & Google Sheet
    Posts
    1,146

    Re: If statement formula with multiple condition

    thanks, bolulusam...
    working well...

+ 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. Multiple condition IF statement PLEASE HELP
    By jam320 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-24-2014, 02:59 PM
  2. Multiple Condition If statement
    By cbjhay2006 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-14-2013, 07:40 PM
  3. [SOLVED] Multiple condition formula help please.
    By nochlin1080 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-25-2012, 03:18 AM
  4. Multiple condition IF statement`
    By floricita in forum Excel General
    Replies: 2
    Last Post: 10-13-2011, 05:41 AM
  5. auto populate a cell using IF statement with multiple condition
    By njoymirror in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 01-30-2009, 03:21 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