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