Using Excel to Validate Grades

[EVargas]

Hi there,
I am trying to create a formula in which a passing grade (A, B, or C) in a second semester math class validates a failing score (D or F) from the first semester. I have grades in two separate columns and want to add an additional column that checks to see if the semester 2 grade validates semester 1. So, student 1 would be validated, student 2 didn't need to be validated, and student 3's grade should not be validated.

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]Semester 1 math[/TD]
[TD="align: center"]Semester 2[/TD]
[TD="align: center"]Grade Validated?[/TD]
[/TR]
[TR]
[TD]Student 1[/TD]
[TD]D[/TD]
[TD]A[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Student 2[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Student 3[/TD]
[TD]F[/TD]
[TD]D[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[jarjarbingie]

Hi there,
I am trying to create a formula in which a passing grade (A, B, or C) in a second semester math class validates a failing score (D or F) from the first semester. I have grades in two separate columns and want to add an additional column that checks to see if the semester 2 grade validates semester 1. So, student 1 would be validated, student 2 didn't need to be validated, and student 3's grade should not be validated.

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]Semester 1 math[/TD]
[TD="align: center"]Semester 2[/TD]
[TD="align: center"]Grade Validated?[/TD]
[/TR]
[TR]
[TD]Student 1[/TD]
[TD]D[/TD]
[TD]A[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Student 2[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Student 3[/TD]
[TD]F[/TD]
[TD]D[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

D2 = IF(AND(OR($B2="D",$B2="F"),OR($C2="A",$C2="B",$C2="C")),"Yes","No")

 

[Marcelo Branco]

Welcome to Mr Excel

Try something like this
Formula in D2 copied down
=IF(OR(B2={"A";"B";"C"}),"No need",IF(OR(C2={"A";"B";"C"}),"Validated","Not validated"))

Hope this helps

M.