Tamilnadu exam results 2012, tamilnadu 12th results 2012, HSC results 2012, plus 2 exam result,10 th results, higher secondary education result,indian.
Meanwhile, on 28 May 2018 for the first score of the students themselves and the temporary certificate of Examination website (www.dge.tn.nic.in) can be downloaded from. Go to the Internet can download to their registration number and date of birth certificate indicating the score. Steps to Download TN 10th SSLC Mark sheet /Score Card through Online: 1. Go to: www.dge.tn.nic.in Website. And Click '10th SSLC Mark sheet' Download Link.
Then enter your Respective register number. Then Press Submit Option. Update: 31.5.2018 (Available Now) Download & Verification of SSLC Mark sheet 2018: - Server I New - Server II New - Server I - Server II.
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.
Maximum marks is 100 for each paper.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 or both 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 with a 'E' sign with the 60 or more marks paper. Here is a method that works. However it is nigh impossible to get an E to turn up next to a score for Fail-Exempt, because adding a column for the E will create circular references. Excel 2010 A B C D E F G H I J K L M N O P 1 Exam scores 2 3 Exam1 Exam2 Result 4 P1 P2 P3 P4 Tot1 P1 P2 P3 P4 Tot2 TotOv Exam1 Exam2 5 H Grant 40 50 40 70 200 0 200 Pass 6 S Johansson 0 50 60 60 40 210 210 Pass 7 O Bloom 30 60 80 50 220 30 30 80 80 220 440 Fail-Ex Fail 8 J Depp 40 40 40 40 160 40 40 40 40 160 320 Fail Fail 9 B Willis 60 60 50 70 240 40 80 80 60 260 500 Pass Pass 10 F Astaire 30 80 60 60 230 40 80 80 50 250 480 Fail-Ex Pass 11 N.
Thanks sijpie, plz consider following table-A B C D E F G H I J K L M N O P 1 Exam scores 2 3 Exam1 Exam2 Result 4 P1 P2 P3 P4 Tot1 P1 P2 P3 P4 Tot2 TotOv Exam1 Exam25 H Grant 40 50 40 70 200 0 200 Pass 6 S Johansson 0 50 60 60 40 210 Pass7 O Bloom 30 60E 80E 50 220 30 30 80 80 220 440 Fail-Ex Fail-Ex8 J Depp 40 40 40 40 160 40 40 40 40 160 320 Fail Fail9 B Willis 60 60 50 70 240 40 80 80 60 260 500 Pass Pass10 F Astaire 30 80E 60E 60E 230 30 80E 80E 50 240 470 Fail-Ex Fail-Ex11 N. Jean 60 40 100 30 30 130 12 ANKIT 60 70 80 80 290 40 41 42 40 163 453 PASS PASS. A B C D E F G H I J K L M N O P 1 Exam scores 2 3 Exam1 Exam2 Result 4 P1 P2 P3 P4 Tot1 P1 P2 P3 P4 Tot2 TotOv Exam1 Exam2 5 H Grant 40 50 40 70 200 0 200 Pass 6 S Johansson 0 50 60 60 40 210 210 Pass 7 O Bloom 30 60E 80E 50 220 30 30 80 80 220 440 Fail-Ex Fail 8 J Depp 40 40 40 40 160 40 40 40 40 160 320 Fail Fail 9 B Willis 60 60 50 70 240 40 80 80 60 260 500 Pass Pass 10 F Astaire 30 80E 60E 60E 230 30 80E 80E 50 240 470 Fail-Ex Fail-Ex 11 N. Jean 60 40 100 30 30 130 12 P Anka 60 70 80 80 290 40 41 42 40 163 453 Pass Pass. Cell Formula L5 =SUM( H5:K5) M5 =+L5+F5 O5 =IF( COUNT( B5:E5)=40,SUM( B5:E5,H5:K5)=400),'Pass',IF( AND( MIN( B5:E5)=40,SUM( B5:E5)=200),'Pass',IF( AND( MIN( B5:E5)=30,MAX( B5:E5)=60,COUNTIF( B5:E5,'=30')=1,SUM( B5:E5)=200),'Fail-Ex','Fail')))) P5 =IF( COUNT( H5:K5)=40,SUM( B5:E5,H5:K5)=400),'Pass',IF( AND( MIN( H5:K5)=40,SUM( H5:K5)=200),'Pass',IF( AND( MIN( H5:K5)=30,MAX( H5:K5)=60,COUNTIF( H5:K5,'=30')=1,SUM( H5:K5)=200),'Fail-Ex','Fail')))) F5 =SUM( B5:E5). A B C D E F G H I J K L M N O P 1 Exam scores 2 3 Exam1 Exam2 Result 4 P1 P2 P3 P4 Tot1 P1 P2 P3 P4 Tot2 TotOv Exam1 Exam2 5 H Grant 40 50 40 70 200 0 200 Pass 6 S Johansson 0 50 60 60 40 210 210 Pass 7 O Bloom 30 60E 80E 50 220 30 30 80 80 220 440 Fail-Ex Fail 8 J Depp 40 40 40 40 160 40 40 40 40 160 320 Fail Fail 9 B Willis 60 60 50 70 240 40 80 80 60 260 500 Pass Pass 10 F Astaire 30 80E 60E 60E 230 30 80E 80E 50 240 470 Fail-Ex Fail-Ex 11 N. Jean 60 40 100 30 30 130 12 P Anka 60 70 80 80 290 40 41 42 40 163 453 Pass Pass.
Cell Formula L5 =SUM( H5:K5) M5 =+L5+F5 O5 =IF( COUNT( B5:E5)=40,SUM( B5:E5,H5:K5)=400),'Pass',IF( AND( MIN( B5:E5)=40,SUM( B5:E5)=200),'Pass',IF( AND( MIN( B5:E5)=30,MAX( B5:E5)=60,COUNTIF( B5:E5,'=30')=1,SUM( B5:E5)=200),'Fail-Ex','Fail')))) P5 =IF( COUNT( H5:K5)=40,SUM( B5:E5,H5:K5)=400),'Pass',IF( AND( MIN( H5:K5)=40,SUM( H5:K5)=200),'Pass',IF( AND( MIN( H5:K5)=30,MAX( H5:K5)=60,COUNTIF( H5:K5,'=30')=1,SUM( H5:K5)=200),'Fail-Ex','Fail')))) F5 =SUM( B5:E5) Thanks sir, consider following condition. Excel 2010 A B C D E F G H I J K L M N O P 1 Exam scores 2 3 Exam1 Exam2 Result 4 P1 P2 P3 P4 Tot1 P1 P2 P3 P4 Tot2 TotOv Exam1 Exam2 5 H Grant 40 50 40 70 200 0 200 Pass 6 S Johansson 0 50 60 60 40 210 210 Pass 7 O Bloom 30 60E 80E 50 220 30 30 80E 80E 220 440 Fail-Ex Fail-Ex 8 J Depp 40 40 40 40 160 40 40 40 40 160 320 Fail Fail 9 B Willis 60 60 50 70 240 40 80 80 60 260 500 Pass Pass 10 F Astaire 30 80E 60E 60E 230 30 80E 80E 50 240 470 Fail-Ex Fail-Ex 11 N.