1. ### 100% rounding

Hi I have an audit template where we have a set of scored criteria. each one marked green = 5 points amber = 3 points red = 0 points We add up all the the score, using aggregate(9,6,range) We then calculate a %age grade using a simple divide total by max possible total formula This works...

Hi everyone, I have a folder for my students, which has a folder for each individual student inside it containing their monthly progress. I wanted to know if there was a way for me to enter data in one "master" spreadsheet and it would auto-populate the individual reports. opening and manually...

Hi everyone, I have a spreadsheet that keeps track of my students' weekly progress with an overall month summary at the end. every day they're graded on different things on a different scale. for example they're given 4 points every day for homework for a total of 20 per week or 80 a month...

Hi guys, I am trying to create a spreadsheet which calculates my students' daily grades and spit out an average at the end of the week. I have certain tasks they do during the day and they're graded for those task for a total of out of 20 points per day. the formula i have right now is just an...
5. ### Need help with this grading sheet using vlookup

i need help with this grading sheet. see picture below. im using vlookup keeps getting an error https://ibb.co/hpsB5x https://ibb.co/b06FXc

hello, I have tried to do this my self but this is abit bigger than my skill set, im trying to make my grading spreedsheet easier for me to read, I have want to have it so that when ever I pass the pass work I want it to come up with pass and then when I pass merit, I want it to say merit, so...
7. ### Formula for Category-Dependent Weighted Grading System

Hey all, Been working on a little project and I seem to have hit a small snag. The workaround would take a long time, so I'm trying to avoid it but we'll see. So essentially I have two tables, a data collection and another table that has mean and standard deviation for each measurement by...

I don't know if there is already related threads regarding my post, i just want to ask for anyone's help on how to create grades range, such as, grades 76 to 79 would be 2.75, 90 to 100 is 1 and all grades lower than 74.99 would be 5 and this is how it would appear thank you very much

### This Week's Hot Topics

• Finding issue in If elseif else with For each Loop
Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
• MsgBox Error
Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
• CELL FORMAT - IF CONDITION
My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
• Show numbers nearly the same
Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...