Forum Discussion
if function
I need a function with if and, it is necessary have different considerations to be accept depends on the gender For the men's basketball team, they must be at least 22 years old, have a minimum hei...
Did you really mean a max age of 21 for women? In the following, I assumed that you meant min age. But you can easily change the formula if it's really max.
Let's say:
Gender in column B (B2 and down), as M or F.
Age in column C.
Height in column D.
Weight in column E.
Grade point average in column F.
In - for example - G2:
=IF(OR(AND(B2="M", C2>=22, D2>=1.7, E2<=80, F2>=3.8), AND(B2="F", C2>=21, D2>=1.6, E2<=65, F2>=3.8)), "Accept", "Reject")
You can use other text strings of course.
Fill down.