Terapan Aplikasi Komputer, Tugas 3 : Fungsi Logika
Gambaran Soal
Jawaban
Rumus
1. And = =IF(AND(C24>12;D24>80);"LULUS";"GAGAL")
2.Or = =IF(OR(C24>12;D24>80);"LULUS";"GAGAL")
3.Sertifikat = =IF(AND(C24>12;D24>80;E24="Y");"DAPAT";"TIDAK")
4.Grade = =IF(D24>90;"A";IF(D24>79;"B";IF(D24>69;"C";"E")))
No comments:
Post a Comment