1. ### Calculating average of weighted grades in ever-expanding table

I am creating a gradebook which has users add new evaluations through a VBA userform. Each new evaluation is added to the next empty column in the worksheet. Two of the data entered are the Category and the Points. In the sheet Settings!K2:L17, the Category code (column K) is associated with...
2. ### Help with Formula for Gradebook

Hi, I am a Kindergarten teacher and I am trying to create a formula that would allow me to enter my test grades in. It would automatically give it a four point value. I.E. if my test was ten points, and I entered 10 in column c than a 4 would appear in column d. If I entered a 0-3 than...
3. ### Teacher - Gradebook - Assign a value to a String

I am trying to do something that I have no idea how to approach with Excel. I want to assign a value to a text string. Actually, i want to assign a formula to a text string, which will be used in another formula. If a student hands in a homework late, then I want to type an "L" as his grade...
4. ### Pass/Fail question

"Hi, and thanks in advance for any help! I am trying to automate some the functions of my student's English progress, based on individual test scores. There are 5 data and 1 results columns. 2 of the tests have a fail/pass component that even if the cumulative score would be enough to pass...
5. ### my round formula rounds up too far

Hello, welcome and nice board you have here. i have used it a bit but this is the first time i needed to ask a question. my question: I have this formula: =(IF(SUM(G22:AG22),ROUND(SUM(G22:AG22)/\$G\$19,2),"")) which was made from a gradebook template that i am using for my girlfriend but the...

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

### Which adblocker are you using?

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

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