TUGAS APLIKOM KE-4

NAMA ANGGOTA:=VLOOKUP(B3,Sheet1!$B$4:$E$13,2)
ALAMAT: =VLOOKUP(B3,Sheet1!$B$4:$E$13,3)
NO.TELP: =VLOOKUP(B3,Sheet1!$B$4:$E$13,4)

JENIS FILM: =VLOOKUP(A8,Sheet2!$B$4:$C$12,2)
JUDUL FILM : =VLOOKUP(A8,Sheet2!$B$4:$D$12,3)
DENDA : =IF((E8-D8-5)>5,(E8-D8-5)*1000,"-")
TOTAL DENDA : =SUM(F8:F14)
TERBILANG : =BAHTTEXT(C15)