Averaging Letters and Numbers

  • Thread starter Thread starter alistair.douglas
  • Start date Start date
A

alistair.douglas

I'm currently working on a gradebook, and as the british system for
grading is 5a 5b 5c etc. rather than just plain grades, I want to know
what would be the easiest way to create a formula to show the Maximum
grade they've acheived, their lowest grade and their average grade.

Any insights would be appreciated.
 
One way would be to create a weighted helper column, average that, and
un-weight.

The difficulty comes when you have say 5a and 4a, what is the average of
that, or more precisely, what is the rule for calculating the average?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting multiple memberships 1
Excel Formulas 3
How to calculate progress between grades like 4a and 6c 3
control ms access report grouping at run time 0
Letter grades average 3
How to Weight Grades vs. Averaging Student Grades 2
Where to put the Grade Average? 9
Array Function to do a Sum of VLookUps that translate a letter gra 3

Back
Top