KETENTUAN DISKON :
jika kualitas barang A = 10%
jika kualitas barang B = 15%
jika kualitas barang C = 20%
jika kualitas barang D = 25%
jika kualitas barang E = 30%

KETENTUAN TRANSAKSI :
. potongan = diskon*harga
. harga beli = harga-potongan
. total = harga beli*jumlah terjual

SINTAKS :
.Kode barang (=VLOOKUP(A19,$A$19:$A$23,1)
.nama barang (=VLOOKUP(A19,$A$19:$B$23,2)
.kualitas barang (=VLOOKUP(A19,$A$19:$C$23,3)
.harga barang (=VLOOKUP(A19,$A$19:$D$23,4)
.diskon =IF(D6="A",10%,IF(D6="B",15%,IF(D6="C",20%,IF(D6="D",25%,IF(D6="E",30%)))))
.potongan (=F6*E6)
.harga beli (=E6-G6)
.total (=H6*I6)