VlOOKUP,IF,MID,DAN LEFT

Menentukan Harga Paket Tambahan
=IF(LEFT(B2,1)="A",VLOOKUP(MID(B2,6,2),$B$23:$E$26,2,0),IF(LEFT(B2,1)="B",VLOOKUP(MID(B2,6,2),$B$23:$E$26,2,0),IF(LEFT(B2,1)="C",VLOOKUP(MID(B2,6,2),$B$23:$E$26,2,0))))

Menentukan Diskon
=IF(F2<=5,VLOOKUP(F2,$G$15:$K$16,1,1)*D2,IF(F2<=10,VLOOKUP(F2,$G$15:$K$16,2,2)*D2,IF(F2<=15,VLOOKUP(F2,$G$15:$K$16,3,3)*D2,IF(F2>=16,VLOOKUP(F2,$G$15:$K$16,4,4)*D2,0))))

Menentukan Harga Total
=Harga Dasar + Paket Tambahan - Diskon