exam result marksheet

[ankit bidawatka]

i want to make a marksheet on ms excel using logical formulas. passing criterion are as follows:-

1. exam of 2 group comprising 4 papers in each group.

2. if any student appers in one group only then it is needful to get 40 marks in each four paper and total 200 marks or above in one group to declare pass.


3. If any candidade appers in both groups and if he/she gets 40 marks in each paper and

total 400 marks or above in both group then he/she shall be declared pass in both group.

4. if any student gets 200 or more marks in one group but fails to secure 40 marks in one or more paper then he will be declared 'fail" but if any student fails to secure 40 marks in one or more paper but able to secure 60 or more marks in one or more paper then he will be exempted in that paper(s) in which he receivs 60 or more marks and result will be "fail-ex", along wiht a "E' sign with the 60 or more marks paper. for eg. "60E".

 

[SirJB7]

This topic is the same as last question of this, just a day of difference:

http://chandoo.org/forums/topic/mark-sheet-of-ca-final-exam-on-ms-excel


What you're doing "is called cross-posting and is generally frowned upon in the Blogosphere as it causes people to potentially waste our time when a question is already answered. You should also check and respond to posts and let posters know if they are heading in the write direction or not." Hui's dixit, SIC. And I agree 101%.


If you'd have read the main green sticky post at this forums main page...

http://chandoo.org/forums/topic/phd-forum-posting-rules-etiquette-pls-read-before-posting

...you should have noticed this points:


"Never title your posts as "Urgent", "Priority" "Immediate". It may be Important to you, but not for rest of the members here. These words will be moderated out."


"Consider that the world is operating 24hrs a day. A late post today may well be answered by someone else overnight."


"Cross Posting, generally it is considered poor practice to cross post, that is to post the same question on several forums in the hope of getting a response quicker."


"If you do cross post, please put that in your post."


"Also if you have cross posted and get an answer elsewhere, have the courtesy of posting the answer here so other readers can learn from the answer also, as well as stopping people wasting there time on your answered question."


"If you and a reader have been involved in an ongoing conversation and the conversation suddenly stops, recognize that the person may have gone to bed, even though you have just arrived at work. In the worst case a reader may go on holidays and not get back to the question for a few days."


"Say "Thanks", whenever you can. Recognize when someone has bothered to go to the trouble and time to assist you with your question. Often readers will spend several hours working on a solution to a problem, a line of recognition will go a long way."