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.