Rabu, 26 Desember 2012


DATA    KETERANGAN                  CARA PENYELESAIAN

60     C              =IF(DATA>=85,"A",IF(DATA>=75,"B",IF(DATA>=60,"C",IF(DATA<=60,"EROR")))
90      A              =IF(DATA>=85,"A",IF(DATA>=75,"B",IF(DATA>=60,"C",IF(DATA<=60,"EROR")))
59      ERR        =IF(DATA>=85,"A",IF(DATA>=75,"B",IF(DATA>=60,"C",IF(DATA<=60,"EROR")))
75      B             =IF(DATA>=85,"A",IF(DATA>=75,"B",IF(DATA>=60,"C",IF(DATA<=60,"EROR")))