HASIL YUDISIUM SEMESTER | ||||||||||||||||||
POLITEKNIK UNAND PADANG |
Macam macam
fungsi rumus formula:
1. SUM
Berfungsi sebagai menjumlahkan
data yang akan dijumlahkan.
Cara menggunakannya
·
Tekantanda (=)
·
KetikSUM(edit data sel yg akan dijumlahkan)
·
Lalu, Tekan ENTER
2. AVERAGE
Untuk Mengetahui rata-rata data
selygakandiketahuinilainya
Cara:
·
Tekan tanda (=)
·
Average (edit data yang
akandirata-ratakan)
·
Lalu, klik Enter
3. MAX
Untuk Mengetahui nilai tertinggi,
Cara nya:
·
Tekan (=)
·
Max (edit data pada sel)
·
Lalu, klik Enter
4. MIN
Untuk Mencari nilai terkecil,
Caranya:
·
Tekan =
·
Min(edit data padasel)
·
Enter
5. Countif
Berfungsi untuk mencari banyak
data suatu sel
6. IF
Untuk Menentukan nilai yang
akandicari.,
Contoh:
=IF(C9>=80,"A",IF(C9>=70,"B","C"))
kemudian tekan enter.
NO | N A M A | MK 1 | MK 2 | MK3 | MK4 | Jumlah | IP | JML NILAI D | JML NILAI E | Status | ||||||||
3 | Madion | 89.0 | A | 4 | 77.0 | B | 3 | 81.0 | A | 4 | 65 | C | 2 | 312.0 | 3.08 | 0 | 0 | lulus |
1 | Jhoni Eka Putra | 90.0 | A | 4 | 84.0 | A | 4 | 81.0 | A | 4 | 58 | D | 1 | 313.0 | 3.00 | 1 | 0 | lulus |
11 | Patrio Soneta | 87.0 | A | 4 | 80.0 | A | 4 | 81.0 | A | 4 | 50.5 | D | 1 | 298.5 | 3.00 | 1 | 0 | lulus |
2 | Andri Fahmi | 80.0 | A | 4 | 56.0 | D | 1 | 81.0 | A | 4 | 70.5 | B | 3 | 287.5 | 2.92 | 1 | 0 | lulus |
10 | Zalvinaldi | 91.0 | A | 4 | 74.0 | B | 3 | 71.0 | B | 3 | 61 | C | 2 | 297.0 | 2.83 | 0 | 0 | lulus |
5 | M.Arif | 60.0 | C | 2 | 84.0 | A | 4 | 79.0 | B | 3 | 60 | C | 2 | 283.0 | 2.75 | 0 | 0 | lulus |
9 | Ezzuari Hasril | 90.0 | A | 4 | 74.0 | B | 3 | 81.0 | A | 4 | 50.5 | D | 1 | 295.5 | 2.75 | 1 | 0 | lulus |
17 | Erizal | 85.0 | A | 4 | 83.0 | A | 4 | 73.0 | B | 3 | 53.5 | D | 1 | 294.5 | 2.75 | 1 | 0 | lulus |
18 | Afdila | 87.0 | A | 4 | 83.0 | A | 4 | 74.0 | B | 3 | 50.5 | D | 1 | 294.5 | 2.75 | 1 | 0 | lulus |
4 | Husni Wenti | 88.0 | A | 4 | 81.0 | A | 4 | 81.0 | A | 4 | 44 | E | 0 | 294.0 | 2.67 | 0 | 1 | tidak lulus |
27 | Syukri Hamdani | 90.0 | A | 4 | 60.0 | C | 2 | 81.0 | A | 4 | 55 | D | 1 | 286.0 | 2.50 | 1 | 0 | lulus |
40 | Muhammad Abrar | 87.0 | A | 4 | 73.0 | B | 3 | 74.0 | B | 3 | 55.5 | D | 1 | 289.5 | 2.50 | 1 | 0 | lulus |
13 | Vera Arizona | 55.0 | C | 2 | 71.0 | B | 3 | 81.0 | A | 4 | 50.5 | D | 1 | 257.5 | 2.42 | 1 | 0 | lulus |
22 | Riki Juwito | 86.0 | A | 4 | 59.0 | D | 1 | 61.0 | C | 2 | 70.5 | B | 3 | 276.5 | 2.42 | 1 | 0 | lulus |
31 | Rivo Stephano | 95.0 | A | 4 | 80.0 | A | 4 | 73.0 | B | 3 | 42.5 | E | 0 | 290.5 | 2.42 | 0 | 1 | tidak lulus |
43 | Marlina | 80.0 | A | 4 | 58.0 | D | 1 | 70.0 | B | 3 | 64 | C | 2 | 272.0 | 2.33 | 1 | 0 | lulus |
12 | Reni Juita | 89.0 | A | 4 | 69.0 | C | 2 | 72.0 | B | 3 | 56 | D | 1 | 286.0 | 2.25 | 1 | 0 | lulus |
24 | Noviardi | 92.0 | A | 4 | 58.0 | D | 1 | 82.0 | A | 4 | 52.5 | D | 1 | 284.5 | 2.25 | 2 | 0 | lulus |
25 | Mhd Arfansyah | 89.0 | A | 4 | 60.0 | C | 2 | 82.0 | A | 4 | 45 | E | 0 | 276.0 | 2.17 | 0 | 1 | tidak lulus |
29 | Boni Firma Putra | 85.0 | A | 4 | 70.0 | B | 3 | 71.0 | B | 3 | 42.5 | E | 0 | 268.5 | 2.17 | 0 | 1 | tidak lulus |
42 | Afdianto | 92.0 | A | 4 | 84.0 | A | 4 | 63.0 | C | 2 | 43 | E | 0 | 282.0 | 2.17 | 0 | 1 | tidak lulus |
47 | Juprial | 76.0 | B | 3 | 46.0 | D | 1 | 73.0 | B | 3 | 65 | C | 2 | 260.0 | 2.17 | 1 | 0 | lulus |
14 | Andre Devara | 55.0 | C | 2 | 71.0 | B | 3 | 81.0 | A | 4 | 46 | E | 0 | 253.0 | 2.08 | 0 | 1 | tidak lulus |
16 | Tomi Firmansyah | 84.0 | A | 4 | 46.0 | D | 1 | 69.0 | C | 2 | 67.5 | C | 2 | 266.5 | 2.08 | 1 | 0 | lulus |
21 | Derit Wirrya Fitri | 60.0 | C | 2 | 83.0 | A | 4 | 73.0 | B | 3 | 43 | E | 0 | 259.0 | 2.08 | 0 | 1 | tidak lulus |
26 | Fitri Yulia M | 86.0 | A | 4 | 58.0 | D | 1 | 68.0 | C | 2 | 64 | C | 2 | 276.0 | 2.08 | 1 | 0 | lulus |
6 | Yazril Mahdi | 45.0 | C | 2 | 59.0 | D | 1 | 77.0 | B | 3 | 68.5 | C | 2 | 249.5 | 2.00 | 1 | 0 | lulus |
8 | Rizki Rahmat | 45.0 | C | 2 | 69.0 | C | 2 | 69.0 | C | 2 | 62.5 | C | 2 | 245.5 | 2.00 | 0 | 0 | lulus |
45 | Dien Novita | 81.0 | A | 4 | 49.0 | D | 1 | 72.0 | B | 3 | 58 | D | 1 | 260.0 | 2.00 | 2 | 0 | lulus |
19 | Misdar Fitri Yeni | 73.0 | B | 3 | 56.0 | D | 1 | 66.0 | C | 2 | 66 | C | 2 | 261.0 | 1.92 | 1 | 0 | tidak lulus |
20 | Hendri Yadi | 30.0 | C | 2 | 55.0 | D | 1 | 81.0 | A | 4 | 58 | D | 1 | 224.0 | 1.92 | 2 | 0 | tidak lulus |
33 | Irsal | 70.0 | B | 3 | 49.0 | D | 1 | 67.0 | C | 2 | 68 | C | 2 | 254.0 | 1.92 | 1 | 0 | tidak lulus |
36 | Citra Anisa Putri | 87.0 | A | 4 | 67.0 | C | 2 | 70.0 | B | 3 | 47.5 | E | 0 | 271.5 | 1.92 | 0 | 1 | tidak lulus |
37 | Syafriandi | 86.0 | A | 4 | 69.0 | C | 2 | 75.0 | B | 3 | 43.5 | E | 0 | 273.5 | 1.92 | 0 | 1 | tidak lulus |
39 | Julia Efanda | 91.0 | A | 4 | 69.0 | C | 2 | 73.0 | B | 3 | 43 | E | 0 | 276.0 | 1.92 | 0 | 1 | tidak lulus |
41 | Kardimas | 88.0 | A | 4 | 76.0 | B | 3 | 66.0 | C | 2 | 43 | E | 0 | 273.0 | 1.92 | 0 | 1 | tidak lulus |
46 | Yusnita | 89.0 | A | 4 | 46.0 | D | 1 | 81.0 | A | 4 | 45 | E | 0 | 261.0 | 1.92 | 1 | 1 | tidak lulus |
15 | Meri Gusnita | 58.0 | C | 2 | 83.0 | A | 4 | 69.0 | C | 2 | 45 | E | 0 | 255.0 | 1.83 | 0 | 1 | tidak lulus |
38 | Ima Hidayatul Fahmi | 55.0 | C | 2 | 70.0 | B | 3 | 72.0 | B | 3 | 42.5 | E | 0 | 239.5 | 1.83 | 0 | 1 | tidak lulus |
7 | Suherdian | 55.0 | C | 2 | 58.0 | D | 1 | 66.0 | C | 2 | 69 | C | 2 | 248.0 | 1.75 | 1 | 0 | tidak lulus |
23 | Andres Boni Fatio | 88.0 | A | 4 | 56.0 | D | 1 | 69.0 | C | 2 | 58 | D | 1 | 271.0 | 1.75 | 2 | 0 | tidak lulus |
48 | Febrianto Nasution | 90.0 | A | 4 | 44.0 | D | 1 | 68.0 | C | 2 | 58.5 | D | 1 | 260.5 | 1.75 | 2 | 0 | tidak lulus |
28 | Afrinal Efendi | 81.0 | A | 4 | 69.0 | C | 2 | 66.0 | C | 2 | 45 | E | 0 | 261.0 | 1.67 | 0 | 1 | tidak lulus |
50 | Agus Sutrisno | 80.0 | A | 4 | 58.0 | D | 1 | 74.0 | B | 3 | 42.5 | E | 0 | 254.5 | 1.67 | 1 | 1 | tidak lulus |
32 | Sugging Probowo | 65.5 | C | 2 | 69.0 | C | 2 | 75.0 | B | 3 | 43 | E | 0 | 252.5 | 1.58 | 0 | 1 | tidak lulus |
34 | Mona Vera Wati H | 65.0 | C | 2 | 74.0 | B | 3 | 68.0 | C | 2 | 43.5 | E | 0 | 250.5 | 1.58 | 0 | 1 | tidak lulus |
35 | Rahmad Syah Mulia | 65.0 | C | 2 | 68.0 | C | 2 | 73.0 | B | 3 | 43 | E | 0 | 249.0 | 1.58 | 0 | 1 | tidak lulus |
44 | Antonius | 75.0 | B | 3 | 58.0 | D | 1 | 69.0 | C | 2 | 56.5 | D | 1 | 258.5 | 1.58 | 2 | 0 | tidak lulus |
49 | Armanto | 81.0 | A | 4 | 57.0 | D | 1 | 68.0 | C | 2 | 45 | E | 0 | 251.0 | 1.42 | 1 | 1 | tidak lulus |
30 | Gema Neni Elfina | 60.0 | C | 2 | 67.0 | C | 2 | 69.0 | C | 2 | 47.5 | E | 0 | 243.5 | 1.33 | 0 | 1 | tidak lulus |
Tidak ada komentar:
Posting Komentar