[SOLVED] Trouble combining multiple IF, AND and OR

[Pr0]

Hi.
I need to combine these 3 conditions:

1. =IF(OR(AND(C174="Daughter"), AND(C174="Miss"), AND(C174="Mrs"), AND(C174="Girl")), "Female", "")
2. =IF(OR(AND(C174="Son"), AND(C174="Bishop"), AND(C174="Mr."), AND(C174="Boy")), "Male", "")
3. If the cell is blank leave it blank.

Currently I'm using this syntax (found it googling):

=IF(ISNUMBER(SEARCH("Daughter",C173)),"Female",IF(ISNUMBER(SEARCH("Girl",C173)),"Female",IF(ISNUMBER(SEARCH("Mrs.",C173)),"Female",IF(ISNUMBER(SEARCH("Miss",C173)),"Female",
IF(ISNUMBER(SEARCH("Son",C173)),"Male",IF(ISNUMBER(SEARCH("Boy",C173)),"Male",IF(ISNUMBER(SEARCH("Mr.",C173)),"Male",IF(ISNUMBER(SEARCH("Bishop",C173)),"Male",""))))))))

Gets the job done, but it's not as optimized and elegant.

I've been trying to nest the entire thing, but I can't seem to figure out the logic.
Help?

PR

[AlKey]

Try this one

Please Login or Register  to view this content.

[Pr0]

It doesn't get any more optimized than this.
Thank you AlKey! :D

P