FUNGSI : |
|
|
|
|
|
UNTUK
MENGUJI KEBENARAN HANTUNYA SUATU KONDISI |
|
|
|
|
|
|
|
|
NAMA |
NILAI-1 |
NILAI-2 |
RATA2 |
HASIL |
PENULISAN |
NUMBER |
NUMBER |
NUMBER |
FUNGSI |
ANI |
90 |
80 |
85 |
LULUS |
=IF(F7<60 lulus="lulus" td="td">
60> |
ALI |
70 |
88 |
79 |
LULUS |
=IF(F8<60 lulus="lulus" td="td">
60> |
INA |
80 |
67 |
73,5 |
LULUS |
=IF(F9<60 lulus="lulus" td="td">
60> |
IRA |
50 |
60 |
55 |
TIDAK LULUS |
=IF(F10<60 lulus="lulus" td="td">
60> |
|
|
|
|
|
|
|
|
|
|
|
|
BENTUK
PENULISAN FUNGSI : |
|
|
|
=IF(X,Y,Z) |
|
|
|
|