grading system conditional formatting

Hi!

I am trying to add a 3rd condition on my if function:

=IF(I6="","",IF(OR(D6<74.5,E6<74.5,F6<74.5,G6<74.5,H6<74.5),IF(I6>=75,"SUMMER CLASS"),IF(I6<75,"FAILED","")))

To explain, D6:H6 contains the grade of a student in a particular subject & I6 has the average of the 6 cells (D6:H6). Now, the condition indicates that "SUMMER CLASS" will appear in J6 if there is a grade lower than 74.50 in any of the 6 cells even if the average is >=75 and "FAILED" will appear if the student has an average lower than 75.

The 3rd condition that I wanted to add is for the word "RETAIN" to appear if there are 3 or more <74.50 grades in cells C6:H6 even if the student has an average of >=75.

Thanks for all your help!

*sheet attached

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Are you purposely excluding History (column C) from your original formulas and only adding it for the new condition?

If so,

Please Login or Register  to view this content.

if not

Please Login or Register  to view this content.

What is the priority of conditions....

The formula I gave, follows your condition that if 3 or more appear below 75, then "Retain" is entered and supercedes the PASS/FAIL.

Try this one:

Please Login or Register  to view this content.

Is this it?

Please Login or Register  to view this content.