Honor Roll Help

  • Thread starter Thread starter HappyGilmore
  • Start date Start date
H

HappyGilmore

Method or formula please :)

In column A I have student names
In column B,C,D (labeled Math, Science, Social Studies) I have their
six weeks grades.
To make "B" honor roll, students may have nothing below an 85 in all
subjects. To make "A" honor roll students may have nothing below a 93
in all subjects.

I can get both honor rolls by sorting for roll "B", then sorting "B"
for "A", but I just know there is a way to do this in one simple
formula.

Appreciate the time and the help.
 
Method or formula please :)

In column A I have student names
In column B,C,D (labeled Math, Science, Social Studies) I have their
six weeks grades.
To make "B" honor roll, students may have nothing below an 85 in all
subjects. To make "A" honor roll students may have nothing below a 93
in all subjects.

I can get both honor rolls by sorting for roll "B", then sorting "B"
for "A", but I just know there is a way to do this in one simple
formula.

Appreciate the time and the help.
Click to expand...



Try this

In E2 put = (B2>92)*(C2>92)*(D2>92) + (B2>84)*(C2>84)*(D2>84)
In F2 put = IF(E2=2, "A roll", "")
In G2 put =IF(E2=1, "B roll", "")

Geoff
 
GB said:
Try this

In E2 put = (B2>92)*(C2>92)*(D2>92) + (B2>84)*(C2>84)*(D2>84)
In F2 put = IF(E2=2, "A roll", "")
In G2 put =IF(E2=1, "B roll", "")

Geoff
Click to expand...

Or, you can combine it into one cell, although it's a bit more complex:

= IF((B2>92)*(C2>92)*(D2>92)=1,"A roll",IF((B2>84)*(C2>84)*(D2>84)=1,"B
roll",""))

Jerry
 
Back
Top