1 Attachment(s)

HELP - Excel Formula - HELP

A colleague is working on an Excel spreadsheet for Target GCSE grades, she has formulas for most things, however, we really need to see if there is a formula for the time taking bit!

Each Grade in **columns C** through to **Z** are worth a certain amount of points, (A1=58; A= 52; B=46; C=40; D=34;E=28;F=22;G=16 which is the GCSE point scoring system) column AG is the total scored for all the GCSEs taken – for example Student 2 scored 372, he took 9 GCSE, but we want the score for the top 8 grades, so we subtract the lowest GCSE score which is ‘D’ worth 34 points this is shown in column AH. Total Points score subtract AF-2 should equal Total Points Score (Best 8)

*Could a formula be created to work out the score of the bottom GCSE grades, ie: if they took 10 GCSE’s you would want a formula to subtract the lowest 2 grade scores and insert the result in column AH.

*Could a formula be created to subtract the AF-2 from the Total Points Scored?

I’m afraid I’ve never had to work out such complicated formula’s but if someone can help that would be wonderful ;)

Oh and if you don't read this until even months later and you think you can help, please reply, because it would just be wonderful to have the formula for future GCSE Gradesheets.

Thank you

Kirsty