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...
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...
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...
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...
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...
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...
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...
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. ||...
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...
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...
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...
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...
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 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.