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...
The basic concept would be something like this. Make sure that the columns that record height and weight just record the number in meters and kilos, respectively (i.e., don't add words to the numeric measurements).
=IF(AND(Sex="M",Age>=22,Height>=1.7,Weight<=80,GPA>=3.8),"Qualifies","Fails")
I am assuming you can figure out the changes to make for the women.
