=IF(AK30=1,SUM(AB30,SUM(AG30:AJ30)*0.2,MIN(AG30:AJ30)*-0.05,MAX(AG30:AJ30)*0.05))

I assume that AB30 contains the score for homework and AJ the Final.

=IF(AK30=0,AB30+SUM(AG:AJ)*0.2),AB30+SUM(AG:AI)*0.2-MIN(AG:AI)*0.05+AJ*0.25)

Aladin

Celia: You'll probably right about the "Final" being the MAX of AG30:AJ30.

Just curious: Why ask the student how s/he wants her/his score be computed, instead of assigning the best outcome according the rules you specified?

The best outcome then would be (using Celia's formula):

=MAX(SUM(AB30,SUM(AG30:AJ30)*0.2,MIN(AG30:AJ30)*-0.05,MAX(AG30:AJ30)*0.05))

Aladin

Just curious: Why ask the student how s/he wants her/his score be computed, instead of assigning the best outcome according the rules you specified? The best outcome then would be (using Celia's formula): =MAX(SUM(AB30,SUM(AG30:AJ30)*0.2,MIN(AG30:AJ30)*-0.05,MAX(AG30:AJ30)*0.05)) Aladin

Actually, the final doesn't have to be the maximum

of the other scores:

I've assumed homework in AB, AG-AI are tests,

AJ is the final, and AK is the switch:

1. Student's choice is binding:

=IF(AK30=1,(AB30*.2)+SUM(AG30:AI30)*.2-MIN(AG30:AI30)*.05+AJ30*.25,AB30*.2+SUM(AG30:AJ30))

2. Excel makes best choice:

=(AB30*.2)+SUM(AG30:AI30)*.2+max(AJ30*.25-MIN(AG30:AI30)*.05,AJ30*.2)

Good luck!

Okay, first of all, thanks for all your suggestions

It's nice to know that 1) There are people out there

who are much smarter than I am and 2) They're helpful,

too.

I was able to combine a couple of your suggestions,

which led me to the answer.

If anyone is interested, here's the formula I came

up with in the end:

=IF(AK30=1,AB30+SUM(AG30:AI30)*0.2-MIN(AG30:AI30)*0.05+AJ30*0.25,AB30+SUM(AG30:AJ30)*0.2)