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.

Looking forwad to get your excellence reply!!!!
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

Attached is another solution.

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