Results 1 to 11 of 11

How to match cell with three text criteria?

Threaded View

  1. 12-26-2012, 01:36 AM #1
    jewellove
    jewellove is offline
    Forum Contributor
    Join Date
    10-26-2012
    Location
    malaysia
    MS-Off Ver
    Excel 2010
    Posts
    138

    How to match cell with three text criteria?

    I have this info:

    Mohd Abdul bin Razak
    Fatima binti Nor
    Tan Mae Ling

    My formula is =IF(ISNUMBER(SEARCH("bin",B1)),"Male", ""). My question is how to construct in such a way that if B1 cell contains "bin" return is Male, if B1 contains "binti" answer is Female, if no binti and bin, just blank.

    Thank you and Merry Christmas..
    Attached Files Attached Files
    Last edited by jewellove; 12-26-2012 at 01:37 AM. Reason: edit
    Reply With QuoteRegister To Reply
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1