1.
Menggunakan fungsi IF
- Kelas =IF(B6="AA";"Ekonomi";IF(B6="AB";"Utama";IF(B6="AC";"V.I.P")))
- Lama Tinggal =E6-D6
- Tarif Kamar =IF(C6="Ekonomi";"25000";IF(C6="Utama";"50000";IF(C6="V.I.P";"75000")))
- Discount =IF(OR(C6="V.I.P";F6>5);F6*G6*10%;0)
- Biaya Dibayar =F6*G6-H6
2.
- Nama Barang =VLOOKUP(B5;$L$4:$O$9;2;FALSE)
- Harga Satuan =VLOOKUP(B5;$L$4:$O$9;3;FALSE)
- Harga Total =C5*E5
- Discount (10%) =VLOOKUP(B5;$L$4:$O$9;4;)*F5
- PPN =IF(F5>5;HLOOKUP(B5;$L$12:$Q$13;2;FALSE);0)
- Nilai Bersih =F5-G5-H5
DOWNLOAD FILE JAWABAN (EXCEL)
mantap teruskan :)
BalasHapusIf you could have} a fabrication project at hand, have the ability to|you presumably can} even select the perfect steel fabricator using the pointers we Baby Bottle Warmers talked about. After that, the steel elements are joined collectively by screws or welds to create the final product. A few many years ago, designing in steel tasks was done on paper with diagrams. This continues to be adopted at present however only for the most basic requirements.
BalasHapus