|I'm not sure if this is what you are looking for, so try it and let us know:|
This will return a blank cell unless there is a value in any one or more of the cells L7,N7 and O7. IF(COUNTA(...)
If there is a value in any of those cells and the SUM is <80, it will return "80 minus that SUM". IF(SUM(...)
If there is a value in any of those cells and the SUM is >=80, it will return a blank cell. (No more points needed)
The one thing that is not clear to me is whether a student can get more than the MAX points for any one of those criteria.
For example, a 40 in Participation, a 40 on the Tues exam and a 5 on the Thur exam would give them 85 points, but it wouldn't meet the criteria listed. Are those grades possible or are the MAX values you mention the MAX that will be awarded?
Do you see the difference? Whether or not my formula will work depends on the answer to that question.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.