NO NAMA NILAI TOTAL NILAI NILAI HURUF
UTS UAS PRAKTIKUM
1 JOKO 70 80 80 76 A
2 SUSANTO 70 90 70 78 A
3 JOHAN 80 75 80 78 A
4 MERRY 90 75 90 84 A
5 ENDAH 80 75 80 78 A
6 BAIM 90 65 60 74 B
7 TEDJO 85 75 75 79 A
8 RIKA 70 75 85 75 B
9 SHINTA 90 85 80 86 A
10 BELLA 65 80 75 73 B

KET :
NILAI TOTAL = (UTS*40%)+(UTS*40%)+(PRAKTIKUM*20%)

NILAI HURUF =
A=76-100
B= 66-75
C=56-65
D=46-55
E>45

rumus : total nilai 1 =(C6*40%)+(D6*40%)+(E6*20%)
2 =(C7*40%)+(D7*40%)+(E7*20%)
3 =(C8*40%)+(D8*40%)+(E8*20%)
4 =(C9*40%)+(D9*40%)+(E9*20%)
5 =(C10*40%)+(D10*40%)+(E10*20%)
6 =(C11*40%)+(D11*40%)+(E11*20%)
7 =(C12*40%)+(D12*40%)+(E12*20%)
8 =(C13*40%)+(D13*40%)+(E13*20%)
9 =(C14*40%)+(D14*40%)+(E14*20%)
10 =(C15*40%)+(D15*40%)+(E15*20%)

: nilai huruf 1 =IF(F6>75,"A",IF(F6>65,"B",IF(F6>45,"C",IF(F6>44,"D"))))
2 =IF(F7>75,"A",IF(F7>65,"B",IF(F7>45,"C",IF(F7>44,"D"))))
3 =IF(F8>75,"A",IF(F8>65,"B",IF(F8>45,"C",IF(F8>44,"D"))))
4 =IF(F9>75,"A",IF(F9>65,"B",IF(F9>45,"C",IF(F9>44,"D"))))
5 =IF(F10>75,"A",IF(F10>65,"B",IF(F10>45,"C",IF(F10>44,"D"))))
6 =IF(F11>75,"A",IF(F11>65,"B",IF(F11>45,"C",IF(F11>44,"D"))))
7 =IF(F12>75,"A",IF(F12>65,"B",IF(F12>45,"C",IF(F12>44,"D"))))
8 =IF(F13>75,"A",IF(F13>65,"B",IF(F13>45,"C",IF(F13>44,"D"))))
9 =IF(F14>75,"A",IF(F14>65,"B",IF(F14>45,"C",IF(F14>44,"D"))))
10 =IF(F15>75,"A",IF(F15>65,"B",IF(F15>45,"C",IF(F15>44,"D"))))