| JUMLAH SUARA | % |
|
|
|
|
|
| 334,455 | 0.2136678 | 21.3668% |
|
|
|
|
|
| 455,566 | 0.215761 | 21.5761% |
|
|
|
|
|
| 234,455 | 0.24561 | 24.5610% |
|
|
|
|
|
| 12,323 | 0.215344 | 21.5344% |
|
|
|
|
|
| 3,223 | 0.3543761 | 35.4376% |  |
|
|
|
|
| 8,893 | 0.215761 | 21.5761% |
|
|
|
|
|
| 45,572 | 0.43462 | 43.4620% |
|
|
|
|
|
| 32,345 | 0.245436 | 24.5436% |
|
|
|
|
|
| 113,435 | 0.212457 | 21.2457% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| MOD | | 1 |
|
|
|
|
| | | Hasl Mod |
|
|
|
|
| 15 | 4 | 3 |
|
|
|
|
| | | 3 |
|
|
|
| LOGARITMA |
|
|
|
|
|
|
| 3 |
|
|
|
|
|
|
| 3.321928095 |
|
|
|
|
|
|
| LOG10 |
|
|
|
|
|
|
| 1.934498451 |
|
|
|
|
|
|
| 1 |
|
|
|
|
|
|
| 2 |
|
|
|
|
|
|
| BILANGANPHI(∏) | PI() |
| ROUND |
|
|
|
|
| | 3.141592654 |
| NILAI | HASIL | FORMULA YANG DIGUNAKAN |
|
|
| | 1.570796327 |
| 2456.789 | 2457 |
|
|
|
| | |
| | 2456.8 | CLICK DISINI DAN NAMPAK |
|
|
| ROMAN | IV |
| | 2460 | DI FORMULA BAR |
|
|
| | I |
| | 2456.79 |
| ABAUT SQRT |
|
| | II |
| | 2500 |
| 2.828427 |
|
| | III |
|
|
|
| SAMA DG |
|
| | V |
|
|
|
| 2.828427 |
|
|
|
| ROUNDUP | and ROUNDDOWN |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| SQRT sama kuadratkan bilangan | misalnya 9^2 = 81 sama SQRT (81)=9 | SUM ADALAH JUMLAH |
|
|
|
|
|
|
| 35456676 |
|
|
|
|
|
|
| 34567878 |
|
|
|
|
|
|
| 547789 |
|
|
|
|
|
|
| 356789900 |
|
|
|
|
|
|
| 427362243 |
|
|
| SUMIF |
|
|
|
|
|
|
|
|
|
|
|
|
| = | SUMIF(range,criteria,sum_range) |
|
|
|
|
|
|
|
|
|
|
|
|
| CARA MENGHITUNG PINJAMAN PEGAWAI BERDASARKAN GOLONGAN |
|
|
|
| nama peminjam | golongan | jlh pinjaman | |
|
|
|
|
| andi | I | 500.000 |
|
|
|
|
|
| yosi | II | 250.000 |
|
|
|
|
|
| reny | I | 750.000 |
|
|
|
|
|
| mary | III | 300.000 |
|
|
|
|
|
| gembrot | I | 200.000 |
|
|
|
|
|
| Yando | III | 350.000 |
|
|
|
|
|
| | | 2,350.000 |
|
|
|
|
|
| | | |
|
|
|
|
|
| Menghitung Jumlah Pinjaman setiap golongan |
|
|
|
|
|
| | Golongan I | 1,450.000 |
|
|
|
|
|
| | Golongan II | 250.000 |
|
|
|
|
|
| | Golongan III |  |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| nama peminjam | golongan | jlh pinjaman |
|
|
|
|
|
| andi | I | 500.000 |
|
|
|
|
|
| yosi | II | 250.000 |
|
|
|
|
|
| reny | I | 750.000 |
|
|
|
|
|
| mary | III | 300.000 |
|
|
|
|
|
| gembrot | I | 200.000 |
|
|
|
|
|
| Yando | III | 350.000 |
|
|
|
|
|
| | |  |
|
|
|
|
|
| | | |
|
|
|
|
|
| Jumlah Pegawai sesuai golongan |
|
|
|
|
|
| | Golongan | Jlh Pegawai |
|
|
|
|
|
| | I | 3 |
|
|
|
|
|
| | II | 1 |
|
|
|
|
|
| | III | 2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
