Pengantar Teknologi Informasi

KLINIK PERSALINAN "SELEBRITI" Tiket Pesawat "Save Air" Tujuan =VLOOKUP(LEFT(B2;3);$A$20:$B$23;2) Harga   =VLOOKUP(LEFT(B2;3);$A$20:$C$23;3) Kelas    =VLOOKUP(MID(B2;4;1);$F$20:$H$22;2) Menu =HLOOKUP(MID(B2;6;2);$B$14:$D$16;2) Diskon=IF($G$16-D2>60;F2*VLOOKUP(MID(B2;4;1);$F$20:$H$22;3);0) Harga Jual =F2-I2+(HLOOKUP(MID(B2;6;2);$B$14:$D$16;3)) Total Pembelian =SUM(J2:J11) Total VIP =COUNTIF(G2:G11;”VIP”)

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