rumus microsoft excel yg sering digunakan

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)