Result Sheet Old Division
|
A |
B |
C |
D |
F |
I |
J |
K |
L |
|
|
Roll |
Name |
B1 |
B2 |
E1 |
E2 |
Total |
Pass/Fail |
Division |
|
|
1 |
101 |
tipu |
90 |
80 |
90 |
80 |
|||
|
2 |
102 |
hasan |
80 |
70 |
80 |
70 |
|||
|
3 |
103 |
nijam |
50 |
40 |
50 |
40 |
|||
|
4 |
104 |
jeasan |
40 |
40 |
40 |
40 |
কেউ যদি রেজাল্ট এ ৭৫০ নম্বর পায় তাহলে ”স্টার” পাবে,৬০০ নম্বর পায় ১ম বিবাগ,৪৫০ নম্বর পায় ২য় বিভাগ ৩৩০ নম্বর পায় ৩য় বিভাগ এবং এক বিষয় পেল করলে পাস করবে না
Total এর সূত্র হল :
=sum(C2:F2) press enter
Pass / fail এর সূত্র হল :
=IF(MIN(C2,D2,E2,F2)<33, "FAIL ", "PASS ")
DIVISION এর সূত্র হল:
=IF(M2>=750, "STAR ",IF(M2>=600, "1ST DIV ",IF(M2>=450, "2ND DIV ",IF(M2>=330,"3RDDIV", "FAIL ")))) press enter
RESULT SHEET NEW G.P.A
|
A |
B |
C |
D |
E |
F |
G |
H |
I |
J |
K |
L |
M |
N |
O |
P |
||
|
1 |
Result Sheet |
||||||||||||||||
|
2 |
|||||||||||||||||
|
3 |
|||||||||||||||||
|
4 |
Bangla |
English |
Accounting |
Islam |
3rd Subject |
4th Subject |
|||||||||||
|
5 |
Roll |
Name |
Marks |
GPA |
Marks |
GPA |
Marks |
GPA |
Marks |
GPA |
Marks |
GPA |
Marks |
GPA |
Total GPA |
Pass/Fail |
|
|
6 |
101 |
Resha |
80 |
50 |
98 |
75 |
87 |
80 |
|||||||||
|
7 |
102 |
Anika |
40 |
70 |
45 |
78 |
41 |
55 |
|||||||||
|
8 |
103 |
Nodi |
41 |
47 |
77 |
79 |
47 |
74 |
|||||||||
|
9 |
104 |
Sakib |
41 |
55 |
77 |
39 |
55 |
45 |
|||||||||
|
10 |
105 |
Juthy |
85 |
66 |
88 |
80 |
78 |
78 |
|||||||||
IF(C6>80,5,IF(C6>=70,4,IF(C6>=60,3.5,IF(C6>=50,3,IF(C6>=40,2,IF(C6>=33,1,IF(C6<33,0)))))))
TOTAL GPA :
=IF(D6-0,"F", IF(F6=0,"F", IF(H6=0,"F", IF(J6=0,"F", IF(L6=0,"F",(D6+F6+H6+J6+L6)+IF(N6>=2,N6-2))/5)))) Press Enter
Pass/Fail :
=If(MIN(D6,F6,H6,J6,L6)<1,"Fail", "Pass") Press Enter
No comments:
Post a Comment