TI

Pertanyaan

ka plis bantuin ya penting makasih
ka plis bantuin ya penting makasih

1 Jawaban

  • 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'))