| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tracking GPA
On Apr 15, 10:22*am, pdberger
wrote: The easiest way would be to set up a column to compute the individual lookup values, and then a separate cell to average them. *You can make it a lot more complex than that, but that's the simplest. " wrote: On Apr 15, 9:45 am, pdberger wrote: Your VLOOKUP formula isn't set up right. *The syntax is =VLOOKUP(item-to-check,lookup-range,column-offset) So * * * * * * * A * * * * * * * * B 1 * * * * * *A * * * * * * * * 4 2 * * * * * *B * * * * * * * * *3 3 * * * * * *C * * * * * * * * *2 4 * * * * * *D * * * * * * * * 1 5 * * * * * *F * * * * * * * * 0 6 7 * * * * * A * * * * *=VLOOKUP(A7,A1:B5,2,FALSE) Check the Excel help on this function. " wrote: On Apr 15, 8:18 am, nathan_savidge wrote: A combination of the 2 would work. *Have a table with your grades and the the points then in your average use a vlookup based on the results, so the A's (my school report :o) ) will then be entered, but the average value will be calculated on its points i.e. 4. let me know if you need any help. " wrote: I want to enter my kids' grades by class (A through F, with a point value for each grade) and have a formula calculate their GPA quarter over quarter, year over year, and by subject. *So the spreadsheet might look like: * * *A * * * * *B * * * * *C * * * * *D * * * * *E * * * * *F 1 2 * * * * * * * * * * * * * * * * * * * * * * *Grade * * Pt. Value 3 * * * * * * * * * * * * * * * * * * * * * * * *A * * * * * 4 4 *Class * * Student 1 * Student 2 * * * * * * * B+ * * * * *3.5 5 *English 9 * * A * * * * *A * * * * * * * * * *B * * * * * 3 6 *Math 9 * * * *C * * * * *B * * * * * * * * * *C+ * * * * *2.5 7 *Music * * * * * * * * * *A * * * * * * * * * *C * * * * * 2 8 *Theater * * * A * * * * * * * * * * * * * * * D+ * * * * *1.5 9 *PE * * * * * *A * * * * *A * * * * * * * * * *D * * * * * 1 10 History 9 * * B * * * * *C+ * * * * * * * * * F * * * * * 0 11 Biology 9 * * C * * * * *B .... and so on ... Where the classes are listed in column A, the students are in columns B & C, and the grading scale is a group of cells off to the right. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| tracking | Excel Discussion (Misc queries) | |||
| How to insert tracking numbers into my webpage for RMA tracking | Excel Discussion (Misc queries) | |||
| Tracking Changes | Excel Discussion (Misc queries) | |||
| tracking changes | Excel Discussion (Misc queries) | |||
| tracking changes | Excel Worksheet Functions | |||
Threaded Mode
