(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...
Komentar
Posting Komentar