If/Or Function help please

[Legacy 116183]

I need some help with an if/or function with options

This function works fine for the females on the spearsheet:

=IF(C3="Female",IF(E3="Yes",0,IF(E3="No",9.5,IF(F3="Social",16.5,IF(F3="Resigned",16.5,IF(G3="New to Membership",16.5,""))))),"")

But if C3 = Male, how do I set it up ?

If C3 were male, I'd like IF(E3="Yes",0,IF(E3="No",9.35,IF(F3="Social",13.85,IF(F3="Resigned",13,85,IF(G3="New to Membership",13.85,
I know I could hvae a column next to the one for females, or use helper cells elsewhere on the spreadsheet, but I'd really like it all in one function if that's possible. If only to learn.

Thanks

 

[DanteAmor]

Try this:

=IF(C3="Female",IF(E3="Yes",0,IF(E3="No",9.5,IF(O(F3="Social",F3="Resigned",G3="New to Membership"),16.5,""))),
IF(C3="Male",IF(E3="Yes",0,IF(E3="No",9.35,IF(O(F3="Social",F3="Resigned",G3="New to Membership"),13.85,""))),""))

 

[Fluff]

Another option

=IF(E3="Yes",0,IF(C3="Female",IF(E3="No",9.5,IF(OR(F3={"Social","Resigned"},G3="New to Membership"),16.5,"")),IF(C3="Male",IF(E3="No",9.35,IF(OR(F3={"Social","Resigned"},G3="New to Membership"),13.85,"")),"")))

 

[Legacy 116183]

Thanks very much for your response. It's kind of you to try and help me.

I shall give them a try.

 

[Fluff]

Glad we could help, let us know how it goes.