Looking for some help after a lot of trial and failure...
I am trying to find a formula that will help me calculate the following:
if(and(M2>=39.4,J2="Female",K2=14),"Meets","Does Not Meet")
if(and(M2>=39.1,J2="Female",K2=15),"Meets","Does Not Meet")
if(and(M2>=38.9,J2="Female",K2=16),"Meets","Does Not Meet")
if(and(M2>=42.5,J2="Male",K2=14),"Meets","Does Not Meet")
if(AND(M2>=43.6,J2="Male",K2=15),"Meets","Does Not Meet")
if(and(M2>=44.1,J2="Male",K2=16),"Meets","Does Not Meet")
I would like to combine all of these into one formula in the same cell. This way I can apply it to my whole class:
1. 41.3 Female 14 Meets
2. 47.4 Male 15 Meets
3. 37.2 Female 14 Does Not Meet
4. 45.8 Male 16 Meets
Thanks for any help...
Bookmarks