ka plis bantuin ya penting makasih
TI
lgl
Pertanyaan
ka plis bantuin ya penting makasih
1 Jawaban
-
1. Jawaban tude99
a.
-G5 =IF(F5>85,"A",IF(F5>75,"B",IF(F5>60,"C","D")))
-G6 =IF(F6>85,"A",IF(F6>75,"B",IF(F6>60,"C","D")))
-G7 =IF(F7>85,"A",IF(F7>75,"B",IF(F7>60,"C","D")))
-G8 =IF(F8>85,"A",IF(F8>75,"B",IF(F8>60,"C","D")))
-G9 =IF(F9>85,"A",IF(F9>75,"B",IF(F9>60,"C","D")))
-G10 =IF(F10>85,"A",IF(F10>75,"B",IF(F10>60,"C","D")))
b.
-H5 =IF(F5>80,"LULUS",IF(F5>75,"REMIDIAL","TIDAK LULUS'))
-H6 =IF(F6>80,"LULUS",IF(F6>75,"REMIDIAL","TIDAK LULUS'))
-H7 =IF(F7>80,"LULUS",IF(F7>75,"REMIDIAL","TIDAK LULUS'))
-H8 =IF(F8>80,"LULUS",IF(F8>75,"REMIDIAL","TIDAK LULUS'))
-H9 =IF(F9>80,"LULUS",IF(F9>75,"REMIDIAL","TIDAK LULUS'))
-H10 =IF(F10>80,"LULUS",IF(F10>75,"REMIDIAL","TIDAK LULUS'))