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..
Bookmarks