Tabel 1
Tabel 2
Rumus
Suci → =IF(B8>=60;"LULUS";"TIDAK LULUS")
Rana → =IF(B8>=60;"LULUS";"TIDAK LULUS")
Indra → =IF(B8>=60;"LULUS";"TIDAK LULUS")
Yusi → =IF(B8>=60;"LULUS";"TIDAK LULUS")
Nina → =IF(B8>=60;"LULUS";"TIDAK LULUS")
Heru → =IF(B8>=60;"LULUS";"TIDAK LULUS")
Dian → =IF(B8>=60;"LULUS";"TIDAK LULUS")
Tabel 3
RUMUS: Harga
Total → =B9*C9
Discount →
=IF(D9>100000;20%*D9;15%*D9)
Harus Dibayar → =D9-E9
Jumlah → =SUM(F9:F18)
Tabel 4
Rumus:
·
Jenis
Barang =IF(LEFT(A4;1)="A";"Minuman";IF(LEFT(A4;1)="B";"Makanan";IF(LEFT(A4;1)="C";"Buah
Kalengan")))
·
Tahun
Kadaluarsa
=IF(RIGHT(A4;2)="01";"Tahun
2001";"Tahun 2002")
Tabel 5
Rumus:
- Gapok =IF(B8="I";170000;IF(B8="II";200000;IF(B8="III";350000;600000)))
-
THR
→
=100/100*C8
-
Bonus
→ =IF(B8="IV";C8*150%;C8*100%)
-
Gaji
Total→
=SUM(C8:E8)
-
Penerimaan
Total → =SUM(F8:F15)
-
Penerimaan
Max → =MAX(F8:F15)
-
Penerimaan
Min → =MIN(F8:F15)
-
Penerimaan
Rata-rata → =AVERAGE(F8:F15)
Tabel 6
Rumus:
Ukuran → =IF(MID(A5;3;2)="01";"21 Inch";"29 Inch")
Nama Barang → =IF(RIGHT(A5;2)="SH";"Sharp";IF(RIGHT(A5;2)="PH";"Philip";"Politron"))
COMMENTS