| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Averaging Letters and Numbers
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Averaging Letters and Numbers
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) wrote in message ups.com... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom Formating Letters to Numbers while Displaying Letters | Excel Worksheet Functions | |||
| Columns now numbers rather than letters how do i get letters back | Excel Discussion (Misc queries) | |||
| Count only Letters in cells that contain both letters and numbers | Excel Worksheet Functions | |||
| Averaging letters | Excel Worksheet Functions | |||
| Averaging Numbers when 2 numbers in one cell | Excel Worksheet Functions | |||
Linear Mode
