# calculation of points and division in excel

1. ## calculation of points and division in excel

Dear Experts!

I want to calculate the points and division of the students scored in 9 subjects but you have to choose only seven subjects that the students has scored mostly. The marks of the students are shown in terms of A,B,C,D and F where A=1,B=2, C=3,D=4 and F=5. how can i do it? if forexample a students scored A,B,B,B,D,C,C,B,D,A. Manually the student has scored points 13 and Division I.

2. ## Re: calculation of points and division in excel

Perhaps you could post a sample spreadsheet showing what you have and what you would like it to look like. I am not following your request. What is the criteria for establishing the division. Which seven scores should be chosen? Highest value or lowest value?

Alan

3. ## Re: calculation of points and division in excel

you have to choose the seven subjects that a student has perfomed well. here is a solved example but how can i code and solve it?
maso.xlsx

4. ## Re: calculation of points and division in excel

Edward,
I hope this is what you are looking for. Look at the formulae behind all the cells. I changed things up a bit.

Alan

5. ## Re: calculation of points and division in excel

Thank you Alansidman for the reply!
i wanted to calculate the division and points of students as you did early but this time want to calculate if the student got F in Mathematics and other subjects he/she did well then the division should be forexample, points 15 and Division I and it should be points 15 but division III. also if a student was absent during the examination it should give me XXXXXXXX OR ABS. How can this be done? i have made changes on the Attachment and you can also edit the attachment and do according to the above information.

Points 7-17
Division I=7-17, II=18-21, III=21-25,IV=26-30 and Zero=31-35
If it happen that a student has got F in mathematics and he got division I or II, he should be pernalized to Division III but he has the previous points

I have changed the attachment. Please have a look on it

6. ## Re: calculation of points and division in excel

Attached is another solution.

7. ## Re: calculation of points and division in excel

Edward,
I am not sure how to automatically change the Division without the use of VBA and we will need someone else to step in to assist with that as it will involve numerous case statements. You may wish to do some research on Case statements in VBA and attempt it on your own and then post back when you have issues. Here is a link to Case statements, but there are many more out there.

http://www.techonthenet.com/excel/formulas/case.php

However, I was able to give you a fix/workaround if you care to employ it. If any student has an F in any subject, then I have conditionally formatted the division to show up as yellow. Look at the formula for conditional format to see how this was accomplished.

Here is link on conditional formatting

http://www.techonthenet.com/excel/qu...rmat1_2007.php

You had mentioned that the last file was read only. When you download it, save it and rename to make it available to you.

Alan

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

## X vBulletin 4.1.8 Debug Information

• Page Generation 0.07037 seconds
• Memory Usage 9,022KB
• Queries Executed 15 (?)
Template Usage (32):
• (1)footer
• (1)forumrules
• (1)gobutton
• (7)memberaction_dropdown
• (1)navbar
• (4)navbar_noticebit
• (6)option
• (4)postbit_attachment
• (7)postbit_legacy
• (7)postbit_onlinestatus
• (7)postbit_wrapper
• (1)spacer_close
• (1)spacer_open
• (1)tagbit_wrapper

Phrase Groups Available (6):
• global
• inlinemod
• postbit
• posting
• reputationlevel
Included Files (39):
• ./vbseo.php
• ./env.php
• ./vbseo/includes/functions_vbseo.php
• ./vbseo/includes/functions_vbseo_pre.php
• ./vbseo/includes/functions_vbseo_url.php
• ./vbseo/includes/functions_vbseo_createurl.php
• ./vbseo/includes/functions_vbseo_db.php
• ./vbseo/includes/functions_vbseo_vb.php
• ./vbseo/includes/functions_vbseo_seo.php
• ./vbseo/includes/functions_vbseo_misc.php
• ./vbseo/includes/functions_vbseo_crr.php
• ./vbseo/includes/functions_vbseo_cache.php
• ./vbseo/includes/functions_vbseo_hook.php
• ./vbseo/includes/functions_vbseo_startup.php
• ./includes/config.php
• ./global.php
• ./includes/class_bootstrap.php
• ./includes/init.php
• ./includes/class_core.php
• ./includes/functions.php
• ./includes/class_friendly_url.php
• ./includes/class_hook.php
• ./includes/functions_cforum.php
• ./includes/functions_bigthree.php
• ./includes/class_postbit.php
• ./includes/class_bbcode.php
• ./includes/functions_reputation.php
• ./includes/class_bootstrap_framework.php
• ./vb/vb.php
• ./vb/phrase.php
• ./packages/vbattach/attach.php
• ./vb/types.php
• ./vb/cache.php
• ./vb/cache/db.php
• ./vb/cache/observer/db.php
• ./vb/cache/observer.php
• ./includes/functions_notice.php

Hooks Called (47):
• init_startup
• friendlyurl_resolve_class
• database_pre_fetch_array
• database_post_fetch_array
• global_bootstrap_init_start
• global_bootstrap_init_complete
• cache_permissions
• fetch_foruminfo
• global_state_check
• global_bootstrap_complete
• global_start
• style_fetch
• global_setup_complete
• friendlyurl_redirect_canonical
• bbcode_fetch_tags
• bbcode_create
• postbit_factory
• postbit_display_start
• cache_templates
• template_register_var
• parse_templates
• notices_check_start
• notices_noticebit
• process_templates_complete
• reputation_image
• postbit_imicons
• bbcode_parse_start
• bbcode_parse_complete_precache
• bbcode_parse_complete
• postbit_display_complete
• memberaction_dropdown
• postbit_attachment
• tag_fetchbit_complete
• forumrules