Latihan Fungsi Logika

SOAL

1. MENCARI JENIS KENDARAAN

=IF(C3="Sd","Sedan",IF(C3="Tr","Truk",IF(C3="Mb","Minibus")))

2. MENCARI TARIP SEWA

=IF(C3="Sd",200000,IF(C3="Mb",400000,IF(C3="Tr",300000)))

3. MENCARI BIAYA SEWA

=D3*F3

4. MENCARI BONUS

=IF(D3>7,G3*7.5%,0)

5. MENCARI YANG HARUS DIBAYARKAN

=G3-H3

6. MENCARI TOTAL

=SUM(I3:I8)