An "AND" inside an "OR inside an "IF"

[Charliebrown190]

Hello everyone:

Need some wisdom here. I am trying to nest 2 "AND" conditionals within an "OR" within an "IF". It works like this: first it has to check gender and a number, say female and >98 -or- male and >102. If the gender and the number are true, then "whatever name", if not true, "this other name". I am having trouble nesting the "and"s inside the "OR". Suggestions?

Thank you very much for any help you can provide.

[jasoncw]

See if this works, assuming the gender is in A1 and number in A2:

=IF(OR(AND(A1="female",A2>98), AND(A1="male",A2>102)),"whatever name","this other name")

HTH

Jason

[Charliebrown190]

Thank you Jason:

This worked like a charm. Take care.