Download - Ujian semester tip fany sheet 3
Transcript
![Page 1: Ujian semester tip fany sheet 3](https://reader035.vdokumen.com/reader035/viewer/2022081205/55c8c879bb61eb37718b45db/html5/thumbnails/1.jpg)
4. TARIF SEWA
KITA GUNAKAN RUMUS =I8*H8 LALU DI TARIK KEBAWAH :
5. DISC
KITA GUNAKAN RUMUS =IF(AND(E8="Nasional",H8<=1),10%*J8,0) LALU DI TARIK KEBAWAH :
6. DENDA
KITA GUNAKAN RUMUS =IF(H8>1,I8,0) LALU DI TARIK KEBAWAH :
![Page 2: Ujian semester tip fany sheet 3](https://reader035.vdokumen.com/reader035/viewer/2022081205/55c8c879bb61eb37718b45db/html5/thumbnails/2.jpg)
7. TOTAL BAYAR
KITA GUNAKAN RUMUS =J8-K8+L8 LALU DI TARIK KEBAWAH :