Sabtu, 26 Mei 2012

LKS 11

Jenis Buku =IF(D9="AG","Agama",IF(D9="FS","Fiksi",IF(D9="IL","Ilmiah",IF(D9="ST","Sastra"))))
Harus Kembali =F9+E5
Terlambat =E4-G9
Denda =IF(D9="IL",250,IF(D9="FS",200,IF(D9="ST",175,IF(D9="AG",750))))*H9

Tidak ada komentar:

Posting Komentar