Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-06-2011, 02:52 PM
edward masoya edward masoya is offline calculating  points and division in excel Windows XP calculating  points and division in excel Office 2007
Novice
calculating  points and division in excel
 
Join Date: May 2011
Posts: 1
edward masoya is on a distinguished road
Question calculating points and division in excel

Dear Experts!



suppose you are an academic officer and you want to display the results of your students in term of points and divisions. students did 9 subjects but you have to choose only seven subjects that they did better. here is an attachment of students scores. the major problem is to code that is to assign A=1,B=2,C=3,D=4,F=5. the other problem is to choose seven subjects out of 9 that he/she did better and then sum the points.
here is attachment of it. if you open the attachement sheet three you will see some important information. Points start from 7 up to 35. where division one =7-17,II=18-21,III-22-25,IV=26-30 AND DIV O=31-35. How can you it?
Attached Files
File Type: xlsx maso.xlsx (14.1 KB, 17 views)
Reply With Quote
  #2  
Old 05-09-2011, 06:31 AM
OTPM OTPM is offline calculating  points and division in excel Windows 7 32bit calculating  points and division in excel Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi Edward

Please see attached spreadsheet. I believe this is what you are after. You can hide the calculation columns if you dont want to display them.
Kind regards
Tony
Attached Files
File Type: xlsx maso(1).xlsx (19.4 KB, 20 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Specific and no other interaction points? anevins PowerPoint 0 03-20-2011 11:37 AM
calculating  points and division in excel Calculating age at date jamierbooth Excel 2 02-22-2011 03:35 AM
Calculating Form Fields in Microsoft Word wubba80 Word 1 06-25-2010 12:42 AM
Indent Points in Word 07 crackinthekraken Word 0 01-19-2010 03:54 PM
calculating  points and division in excel division zero escape? gmyls Excel 2 05-22-2009 02:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:03 PM.


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