EXAMPLE
Rumus Pada Microsoft Excel
Rumus Keterangan
Lulus dan Tidak Lulus
=IF(F3>=75,"LULUS","TIDAK
LULUS")
Rumus Nilai
=IF(F2>=90,"A",IF(F2>=76,"B",IF(F2>=60,"C",IF(F2>=40,"D","E"))))
Rumus Rata-Rata
=AVERAGE(C2:D2)
Rumus Jumlah
=SUM(C2:D2)
Rumus Nillai Teringgi
=MAX(C2:C10)
Rumus Nilai
Terendah
=MIN(C2:C10)
Rumus Ranking
=RANK(F4,$F$4:$F$13)
Rumus Jumlah
Karyawan
=COUNTA(B4:B10)
