Hi Guys!
Thanks for the quick response! I'll attach the workbook so you can get an idea of what I'm talking about!
So you can see the problem column is the "RATs" column on the far left. Some are worth 20, one is worth 19, and some are worth 10. I basically need to drop the three lowest "percentages", and then the remaining need to go into the 12% of the total grade. But when calculating how much of that 12% the student gets from RATs, I need the earned points/total points because the 10 point assignments contribute half as much to the grade as the 20 point assignments (if that makes sense). Hopefully with the spreadsheet it will make more sense... I find it's easier to explain in person and more difficult to explain with typing
@Beaunydal
Thanks for the formula and help, but I don't think it works exactly! If you remove the three lowest scores manually, you can see the difference. With the -SMALL function, it will remove the lowest number, and not necessarily the lowest percentage. So it removed the 4/10 instead of 5/20, and 4/10 is actually a higher percentage.
Bookmarks