Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-23-2023, 01:52 PM
Oluagbe1 Oluagbe1 is offline Auto calculation of Percentage, Position and Grade of students Windows 10 Auto calculation of Percentage, Position and Grade of students Office 2019
Novice
Auto calculation of Percentage, Position and Grade of students
 
Join Date: Feb 2019
Posts: 8
Oluagbe1 is on a distinguished road
Default Auto calculation of Percentage, Position and Grade of students

Hello everyone.
Please I need help with this spreadsheet. I have 12 subject in total on the spreadsheet.
My students offered 10 while some offered 11 out of the 12 subjects.
Now, I need to calculate the underlisted.


Percentage: to calculate this, those students that offered 10 subjects, their total should be divided by 10 and those that offered 11 subjects, their total be divided by 11

Position: In finding the position, the student with the highest percentage comes 1st, followed by the next in line. Also note that if we have 3 students with the same percentage, it means that position will be repeated 3 times e.g if we have 69.05 appearing 3 times for 3 different students, the position will appear as 3rd, 3rd and 3rd, it means the next position will be 6th as there will not be 4th and 5th because of the reoccurrence of 3rd.

Grade: In grading, the percentage column will be used. From there we can deduce 0 – 29 as F, 30 – 39 as “E”, 40 – 49 as “D”, 50 – 59 as “C”, 60 – 69 as “B” and 70 and above as “A”

Remark: in getting the remark, 3 criteria will be used. Each student must score 50% and above in English Language, Mathematics and must have 50 and above percentage. Is the student meets this criteria, the Remark column returns a “PASS” else “Failed” and if a student did not partake in any of the exam i.e 0 in percentage the remark returns absent

Thank you in anticipation
Attached Files
File Type: xlsx sample SCORE TEMPLATE 1.xlsx (21.9 KB, 1 views)

Last edited by Oluagbe1; 11-24-2023 at 09:11 AM. Reason: To change the prefix to solved.
Reply With Quote
  #2  
Old 11-23-2023, 05:44 PM
p45cal's Avatar
p45cal p45cal is online now Auto calculation of Percentage, Position and Grade of students Windows 10 Auto calculation of Percentage, Position and Grade of students Office 2021
Expert
 
Join Date: Apr 2014
Posts: 855
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

See attached
Attached Files
File Type: xlsx msofficeforums51689sample SCORE TEMPLATE 1.xlsx (22.3 KB, 1 views)
Reply With Quote
  #3  
Old 11-24-2023, 09:09 AM
Oluagbe1 Oluagbe1 is offline Auto calculation of Percentage, Position and Grade of students Windows 10 Auto calculation of Percentage, Position and Grade of students Office 2019
Novice
Auto calculation of Percentage, Position and Grade of students
 
Join Date: Feb 2019
Posts: 8
Oluagbe1 is on a distinguished road
Default Great job

Quote:
Originally Posted by p45cal View Post
See attached
Thank you very much.
This work very well for me. I appreciate your efforts much.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
percentage calculation formula yoyo4 Excel 10 11-15-2017 11:44 AM
Macro needed for time calculation and auto insert ballst Excel Programming 8 05-21-2015 03:54 PM
Auto calculation of Percentage, Position and Grade of students Calculation of Percentage Completion of Summary Tasks raminraiszadeh Project 2 04-06-2015 06:38 AM
Auto calculation of Percentage, Position and Grade of students How to prevent the auto-calculation of the '% Complete' field in MS Project Professional 2013? VivekG1 Project 1 02-06-2015 05:33 AM
Auto calculation of Percentage, Position and Grade of students Need help creating a formula for student grade johnnykhan Excel 2 04-03-2012 02:28 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:35 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft