Rekapitulasi Nilai Mahasiswa

TOTAL NILAI :
=SUM(E5:G5)
RATA RATA :
=AVERAGE(E5:G5)
KETERANGAN :
=IF(I5>60;"Lulus";"Gagal")
GRADE :
=IF(I5>80;"A";IF(I5>70;"B";IF(I5>60;"C";IF(I5>50;"D";"E"))))
BEASISWA :
=IF(K5="A";"LN";IF(K5="B";"DN";"Tidak Dapat Beasiswa"))
BONUS :
=IF(K5="A";"Sepeda";IF(K5="B";"Payung";IF(K5="C";"Topi";"Tidak Dapat Bonus"))
DISKON 1 :
=IF(AND(K5="A";M5="Sepeda");20%;IF(AND(K5="B";M5="Payung");10%;0))
DISKON 2:
=IF(OR(M5="Sepeda";M5="Payung");15%;IF(M5="Topi";10%;0))