L
Legacy 116183
Guest
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
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