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
This is default featured slide 1 title
Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.
This is default featured slide 2 title
Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.
This is default featured slide 3 title
Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.
This is default featured slide 4 title
Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.
This is default featured slide 5 title
Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.
