LKS 15

Jenis dan nama film diperoleh dengan menggunakan fungsi
=CONCATENATE(IF(MID(A6,1,1)="A","ACTION",IF(MID(A6,1,1)="C","CARTOON",IF(MID(A6,1,1)="K","KOMEDI",IF(MID(A6,1,1)="M","MUSIC",IF(MID(A6,1,1)="R","ROMANCE"))))),"/",VLOOKUP(VALUE(MID(A6,5,1)),$H$7:$I$15,2,0))

Discount gunakan fungsi
=IF(MID(A6,4,1)="B",IF(MID(A6,2,2)>90,SUM(VLOOKUP(VALUE(MID(A6,5,1)),$H$7:$K$15,4,0))*15%,0)*IF(MID(A6,4,1)="B",IF(MID(A6,2,2)<=90,SUM(VLOOKUP(VALUE(MID(A6,5,1)),$H$7:$K$15,4,0))*25%)))+REPLACE(FALSE,1,5,0)

Jumlah gunakan fungsi
=VLOOKUP(VALUE(MID(A6,5,1)),H$7:K$15,4,0)-D6

Untuk mengetahui tentang keterangan gunakan Fungsi
=CONCATENATE(IF(MID(A6,4,1)="S","SEWA","BELI"),"(",IF(MID(A6,6,1)="A","2 HARI",IF(MID(A6,6,1)="B","3 HARI",IF(MID(A6,6,1)="C","5 HARI"))),")")