Help with Conditional Formating and IF (or any other formula)

[edge37]

Hi, please help me on the following. Given the example table of grades:

	STUDENT	MATH	PHYSICS	CHEMISTRY	BIOLOGY	ENGLISH	SOCIOLOGY	PHILOSOPHY	PSYCHOLOGY	SPANISH	ACCOUNTING	RELIGION	P.E.	INFORMATICS	AVERAGE	HONOR ROLL
1	Justina Leask	91	91	91	84	98	91	91	91	91	91	91	91	91	91.00
2	Russell Gomez	91	91	91	91	91	91	91	91	91	94	96	91	91	92.00
3	Doria Venegas	70	88	78	78	78	78	78	78	78	78	78	78	78	78.15
4	Joaquin Cargle	95	95	95	83	95	95	95	95	95	95	95	95	99	94.38
5	See Ball	89	89	89	86	79	79	79	79	79	79	79	91	98	84.23

<tbody>
</tbody>

In the honor roll column at the end I want to determine who is OUTSTANDING (those who have an average >= 91, and have NO grade lower than 91); or DISTINGUISH (those who also have an average >= 91, but they have a a grade less than 90.5 in their notes). In the table we have students 1, 2, and 4 with grades >= 91, Student 2 have all notes equal or higher than 91, so he's OUTSTANDING, but 1 and 4 have each one note from 79.5 to 90.4 (in red) so they are DISTINGUISH. I can determine with conditional formating to highlight the note that is less than 90.5 but my question is: Can I use IF (or any other formula) to fill the Honor Roll column, based on the >=91 average and the note less than 90.5 in their grades I highlighted, with either OUTSTANDING, DISTINGUISH an empty space for those who don't apply?

Thanks for your help

 

[Joyner]

Hello, try this: (assumes data including headings starting in cell A1)

=IF(MIN(B2:O2)>=91,"OUTSTANDING",IF(AND(MIN(B2:N2)<90.5,O2>=91),"DISTINGUISH",""))

 

[edge37]

Working like a charm. You are great, mate, thanks.

 

[Joyner]

you are welcome