contekan paap

soal hotel. TYPE KAMAR= =HLOOKUP(B5;$N$5:$P$6;2;TRUE) NAMA KAMAR= =VLOOKUP(C5;$L$12:$P$14;2;FALSE) TARIF KAMAR= =IF(B5=D;"VLOOKUP(C5;$L$12:$P$14;4;FALSE)";IF(B5=F;"VLOOKUP(C5;$L$12:$P$14;3;FALSE)";"VLOOKUP(C5;$L$12:$P$14;5;FALSE)")) Biaya Beban /Bulan soal pln Biaya Beban /Bulan= =IF(C6="R-1";"3620";IF(C6="R-2";"3660";"7560")) 0-50= =IF(E6<=50;E6*75;50*75) 51-75= =IF(AND(E6>=51;E6<=75);E6*100;IF(E6>=76;75*100;0)) >=75= =IF(E6>=76;E6*150;0) jumlah= =D6+F6+G6+H6