MENCARI BEASISWA, BONUS, DAN DISKON 1 DAN 2

Untuk mencari Beasiswa, Bonus, Diskon 1 dan 2

Beasiswa
=IF(J4="A","LN",IF(J4="B","DN","-"))
Lalu tekan enter

Bonus
=IF(J4="A","SEPEDA",IF(J4="B","PAYUNG",IF(J4="C","TOPI")))
Lalu tekan enter

Diskon 1
=IF(AND(K4="LN",L4="SEPEDA"),"20%",IF(K4="DN",L4="PAYUNG")"10%","0%"))
Lalu tekan enter

Diskon 2
=IF(OR(L4="SEPEDA",L4="PAYUNG"),"15%",IF(L4="TOPI","5%","0%"))
Lalu tekan enter

Sehingga keluar hasilnya
Gampang kan ?
Selamat mencoba :)