grade

  1. L

    Average pay wage per grade

    I have to find the average pay wage per grade. For instance, M4 and P5 fall under the grade of 19. Therefore, I should calculate (M4+P5)/2. For grade 18 I should calculate (M4+P4)/2, and so on. For grades like Execs-E0 I should find the average of grade E0 because this is the only grade which...
  2. K

    IF Statement to find Grade Level

    Hi all! Our school require all students to have 23 credits to graduate. For the students to be in 9th grade, they must have less than 6 credits. To be in 10th grade they must have between 6 and 11.99 credits. To be in 11th grade, they must have between 12 and 16.99 credits. To be in 12th grade...
  3. M

    Help needed with userform label and Index/Match.

    Hi all, I'm looking for some help with getting userform label's caption to be the result of an index/match formula. Here's the setup: Two sheets, each with a table. Sheet1 has Table1, Sheet2 has Table2. Both tables are generally set up the same as far as column titles go. The userform is...
  4. O

    a 'character' is spoiling my 'averages'

    Hi all, I am averaging grades across a term but on occasion have been using an 'x' to denote work not completed. I've realised that using any character halves the reported average grade. I'd like to include characters to denote certain things when no grade has been taken in. Can anyone explain...
  5. M

    Averaging A Named Range

    I've read quite a lot on this topic but still can't get my code to work... I've got a sheet that contains student test scores. Its sorted by grade level and I want to average all the scores over each grade. My macro moves down the grade level column and inserts blank rows to separate all the...
  6. L

    Students' grade scores calculation in division base.

    <tbody> Cand. No Lit Civ His Kisw Bios Math Engl Phy Chem DIV PONTS 0001 37 45 67 89 90 23 23 34 0002 24 56 78 90 34 12 17 88 45 0003 56 78 90 78 X 33 45 55 0004 23 34 45 58 78 89 87 76 0005 X X X X X X X X ABS -- 0006 56 78 90 87 65 76 54 45 23 0007 56 78 54 45 39 00...
  7. R

    Auto populate by drop down list

    Hi everyone! I have a delicate question about Excel which I'm not really good at ^^ and I hope that you can help me. Here's what I want to do: I would like some Cells to be populated in a certain way when I choose a specific value in a drop down menu. What I've got so far: I've created the...
  8. E

    Using Excel to Validate Grades

    Hi there, I am trying to create a formula in which a passing grade (A, B, or C) in a second semester math class validates a failing score (D or F) from the first semester. I have grades in two separate columns and want to add an additional column that checks to see if the semester 2 grade...
  9. P

    plot chart with grade data but not scores

    Hi everyone, I have a set of academic scores data that categorized into grades A (>85), B(>70), C (>55), D (>40), E (40 and below). Any idea how could I plot a chart in Excel (perhaps line chart with marks?) showing the grades but not the actual score values? I am using Excel 2010. Test No. ||...
  10. S

    IF Formula for Class Grades

    I am attempting to create an IF or IF(AND formula that I can use to display the letter grade I earned based off of a certain percentage criteria. I have had trouble creating this formula myself. Hopefully someone can help. Please refer to my notes below to examine the criteria. Let me know if...
  11. L

    Interpolate between data - NOT WORKING?

    Hi, I have a list with data for vehicles' speed vs grade%. I'm currently using this formula but is suspecting that this is not very accurate and gives errors: =FORECAST(I10,OFFSET(speed_loaded1,MATCH(I10,grade_loaded1,1)+1,0,2),OFFSET(grade_loaded1,MATCH(I10,grade_loaded1,1)+1,0,2)) Can...
  12. L

    How to include A* GCSE Grades in a VLOOKUP Table?

    I use excel as my school mark book. This involves needing to convert grades (letters) into numbers and vice versa. I am able to use a vlookup table for the majority of this. However I have found an anomoly when trying to include grades at A-star (A*). I have included a table like this to show...
  13. X

    Predicted Grade comparison to Total grade help

    Basically I am making a grading sheet. I have two cells a predicted grade one and total grade one, these both contain the according grade i.e No Award, Pass, Merit or Distinction I want to compare these so that it in a separate cell if for example there predicted grade was a pass and they got a...
  14. W

    Grading on a Curve - Formula question

    I'm trying to help a friend that is a teacher and wants to make a spreadsheet that grades on a curve. I've seached and found the following - assuming Grades are in A10:A20, then (A10-AVERAGE(A$10:A$20))/STDEV(A$10:A$20) gives the standard deviation of a particular score. Also, I found...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top