Sunday, October 31, 2021

Tugas TAK 3

 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:

Popular Posts