| 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">
|
| ALI |
70 |
88 |
79 |
LULUS |
=IF(F8<60 lulus="lulus" td="td">
|
| INA |
80 |
67 |
73,5 |
LULUS |
=IF(F9<60 lulus="lulus" td="td">
|
| IRA |
50 |
60 |
55 |
TIDAK LULUS |
=IF(F10<60 lulus="lulus" td="td">
|
|
|
|
|
|
|
|
|
|
|
|
|
| BENTUK
PENULISAN FUNGSI : |
|
|
|
| =IF(X,Y,Z) |
|
|
|
|
