IF/AND/OR Assistance

[SFCChase]

Probably an easy fix, but I've been staring at this for way too long.

EXAM 1	EXAM 1 RETEST A	EXAM 1 RETEST B	FINAL SCORE
80			80
72	80		76
72	72	80	76
72	72	72	72

I need a formula in cell D2 that will read A2.
If A2 is >=76 it will report the value of A2
If A2 is <76 it will read cell B2. If B2 is >=76 it will report "76" as a value (no matter the score).
If A2 is <76 it will read cell B2. If B2 is <76 it will read cell C2. If C2 is >=76 it will report "76" as a value (no matter the score).
If A2, B2, and C2 are all <76 it will report the value of A2.

I know there's probably an easy nested IF(AND(OR)) Function out there, but I can't get it to return a value based off the results of Cell C2.

All assistance is appreciated.

 

[SFCChase]

Anybody?

 

[jasonb75]

Don't need any AND's / OR's, just progressive IF's.

=IF(A2>=76,A2,IF(B2>=76,76,IF(C2>=76,76,A2)))

For what it's worth, it's best wait around 24 hours before replying to your own thread to bump it to the top. A lot of people (myself included) tend to look at threads that have no replies. By replying to your own thread you are inadvertently removing it from the unanswered threads list and reducing your chance of getting your question answered.
It was only by chance that I had already opened your thread before you bumped it and was working on an answer, otherwise you may have been waiting much longer for someone to look at it.

 

[Fluff]

Another option

=IF(OR(A2>=76,MAX(B2:C2)<76),A2,76)