FUNGSI : |
|
|
|
|
|
|
MENGHASILKAN
NILAI TRUE JIKA SEMUA ARGUMEN
HANTUNYA YANG DIUJI BERNILAI BENAR DAN |
|
|
FALSE JIKA ADA SATU ATAU LEBIH ARGUMEN YANG BERNILAI SALAH. |
|
|
|
|
|
|
|
|
|
|
BENTUK
PENULISAN FUNGSI : |
|
|
|
|
|
=AND(X1,X2,X3,…) |
|
|
|
|
|
|
|
|
|
|
|
|
|
Contoh
Kasus. |
|
|
|
|
|
|
Peserta
ujian dinyatakan lulus jika nilai ujian teori dan praktik masing-masing harus
di atas 7, |
|
|
jika
tidak maka dinyatakan gagal. |
|
|
|
|
|
|
|
|
|
|
|
|
|
NO. |
NAMA |
NILAI TEORI |
NILAI PRAKTIK |
KETERANGAN |
PENULISAN FUNGSI |
1 |
Chichi |
9 |
9 |
LULUS |
=IF(AND(E27>7,F27>7),"LULUS","GAGAL") |
|
|
2 |
Ayu |
8 |
8 |
LULUS |
=IF(AND(E28>7,F28>7),"LULUS","GAGAL") |
|
|
3 |
Adhit |
8 |
8 |
LULUS |
=IF(AND(E29>7,F29>7),"LULUS","GAGAL") |
|
|
4 |
Sarah |
8 |
8 |
LULUS |
=IF(AND(E30>7,F30>7),"LULUS","GAGAL") |
|
|
5 |
Nimrod |
7 |
9 |
GAGAL |
=IF(AND(E31>7,F31>7),"LULUS","GAGAL") |
|
|
6 |
Tony |
8 |
8 |
LULUS |
=IF(AND(E32>7,F32>7),"LULUS","GAGAL") |
|
|
7 |
Yoseph |
9 |
7 |
GAGAL |
=IF(AND(E33>7,F33>7),"LULUS","GAGAL") |
|
|
8 |
Kemal |
6 |
5 |
GAGAL |
=IF(AND(E34>7,F34>7),"LULUS","GAGAL") |
|
|
9 |
Adi |
7 |
6 |
GAGAL |
=IF(AND(E35>7,F35>7),"LULUS","GAGAL") |
|
|
10 |
Rantih |
8 |
9 |
LULUS |
=IF(AND(E36>7,F36>7),"LULUS","GAGAL") |
|
|