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.

wrote in message
...
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.




Try this

In E2 put = (B292)*(C292)*(D292) + (B284)*(C284)*(D284)
In F2 put = IF(E2=2, "A roll", "")
In G2 put =IF(E2=1, "B roll", "")

Geoff

"GB" wrote in message
...

wrote in message
...
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.




Try this

In E2 put = (B292)*(C292)*(D292) + (B284)*(C284)*(D284)
In F2 put = IF(E2=2, "A roll", "")
In G2 put =IF(E2=1, "B roll", "")

Geoff



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

= IF((B292)*(C292)*(D292)=1,"A roll",IF((B284)*(C284)*(D284)=1,"B
roll",""))

Jerry

One way:

E2: =CHOOSE((MIN(B2:D2)=85)+(MIN(B2:D2)=93)+1,"","B" ,"A")

In article ,
wrote:

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.