Fungsi Logika MULTI IF

Fungsi Logika MULTI IF
UNTUK MENGUJI KEBENARAN SUATU KONDISI

NAMANILAI-1 NILAI-2 RATA2   NILAI HASIL PENULISAN FUNGSI

ANI  90 80     85 B LULUS             =IF(F7<60,"D",IF(F7<80,"C",IF(F7<90,"B","A")))
ALI  70 88         79 C LULUS             =IF(F8<60,"D",IF(F8<80,"C",IF(F8<90,"B","A")))
INA  80 67     73,5 C LULUS             =IF(F9<60,"D",IF(F9<80,"C",IF(F9<90,"B","A")))
IRA  50 60     55 D TIDAK LULUS =IF(F10<60,"D",IF(F10<80,"C",IF(F10<90,"B","A")))



=IF(X,Y,Z)