Hello, So I am a Newbie to this forum and have read several of the post but have not been able to find the answer to my issue.
I am trying to create an IF/AND formula to score a students' assessment
Student is assessed in three fields and received one score for each field.
Final score is a compilation of the three individual scores.
These are stored in a spreadsheet.
If the result in cell A2>=70, B2>=70 and C2>=72, the student gets a mark of "High Pass"
If the result in cell A2>=50, B2>=50 and C2>=50, the student gets a mark of "Pass"
Anything else gets a mark of "No Pass"
below is what I tried, but received a #VALUE! error
=IF(AND($A2>=70,$B2>=70,$C2>=72),"High Pass"," "),IF(AND($A2>=50,$B2>=50,$C2>=50),"Pass","No Pass")
Help, Please.
I am trying to create an IF/AND formula to score a students' assessment
Student is assessed in three fields and received one score for each field.
Final score is a compilation of the three individual scores.
These are stored in a spreadsheet.
If the result in cell A2>=70, B2>=70 and C2>=72, the student gets a mark of "High Pass"
If the result in cell A2>=50, B2>=50 and C2>=50, the student gets a mark of "Pass"
Anything else gets a mark of "No Pass"
below is what I tried, but received a #VALUE! error
=IF(AND($A2>=70,$B2>=70,$C2>=72),"High Pass"," "),IF(AND($A2>=50,$B2>=50,$C2>=50),"Pass","No Pass")
Help, Please.
