LKS 18

Merek Televisi
=CONCATENATE(VLOOKUP(VALUE(LEFT(C8,1)),TBLMERKGARANSI,2,0)," ",VLOOKUP(MID(C8,2,2),TBLUKRNHARGA,2,0))

Cara beli
=IF(RIGHT(C8,1)="K","KREDIT","CASH")

Harga Satuan
=VLOOKUP(MID(C8,2,2),TBLUKRNHARGA,IF(LEFT(C8,1)="1",3,IF(LEFT(C8,1)="2",4,5)),0)

Biaya garansi
=VLOOKUP(VALUE(LEFT(C8,1)),TBLMERKGARANSI,3,0)*G8

Discount
=G8*D8*IF(AND(RIGHT(C8,1)="C",D8>=10,MID(C8,2,1)="C"),8%,IF(AND(RIGHT(C8,1)="C",D8>=10,MID(C8,2,1)="W"),15%,0))


Jumlah bayar
=((G8*D8)+H8)-I8