Tugas Excel

(1) RENTAL MOBIL "KURNIAWAN"

Jenis Kendaraan : =IF(C10="MB","MINI BUS",IF(C10="TR","TRUK","SEDAN"))

Tarif/Jam : =IF(C10="MB",12500,IF(C10="SD",10000,15000))

Biaya Sewa : =E10*F10

Denda : =IF(E10>24,G10*5%,0%)

Jumlah Bayar : =SUM(G10+H10)

Total Bayar : =SUM(I10:I14)

Rata-Rata : =AVERAGE(I10:I14)

Bayar Tertinggi : =MAX(I10:I14)

Bayar Terendah : =MIN(I10:I14)

(2) DAFTAR BIAYA KULIAH GANJIL TA 2015-2016. UNIVERSITAS KEREN BINGITS.

Shift : =IF(LEFT(B8,1)="P","PAGI","SORE")

Angkatan : =IF(MID(B8,2,2)="12",2012,IF(MID(B8,2,2)="13",2013,IF(MID(B8,2,2)="14",2014,2015)))

Prodi : =IF(MID(B8,4,2)="MN","MANAJEMEN",IF(MID(B8,4,2)="AK","AKUNTANSI",IF(MID(B8,4,2)="TI","TEKNIK INFORMATIKA",IF(MID(B8,4,2)="TM","TEKNIK MESIN",IF(MID(B8,4,2)="TK","TEKNIK KIMIA",IF(MID(B8,4,2)="HK","HUKUM","PSIKOLOGI"))))))

Biaya SPP : =IF(E8=2012,5000000,IF(E8=2013,6000000,IF(E8=2014,7000000,8000000)))

Jumlah SKS : =IF(MID(B8,6,2)="18",18,IF(MID(B8,6,2)="20",20,IF(MID(B8,6,2)="22",22,24)))

Biaya per SKS : =IF(F8="MANAJEMEN",35000,IF(F8="AKUNTANSI",45000,IF(F8="TEKNIK INFORMATIKA",65000,IF(F8="TEKNIK MESIN",100000,IF(F8="TEKNIK KIMIA",75000,IF(F8="HUKUM",50000,55000))))))

Total Bayar : =IF(D8="SORE",(H8*I8)+500000,(H8*I8))

Potongan : =IF(AND(E8=2012,F8="MANAJEMEN"),(G8*30%),IF(AND(E8=2012,F2="AKUNTANSI"),(G8*20%),IF(AND(E8=2012,F8="HUKUM"),(G8*10%),0%)))

Jumlah Dana : =SUM(J8:J17)
                        =SUM(K8:K17)

(3) DOWNTOWN INTERNET CAFE