wuihh salah copy.. =IF(F3<=40%,"U",IF(AND(F3>40%,F3<=60%),"D",IF(AND(F3>60%,F3<=80%),"C",IF(AND(F3>80%,F3<=100%),"B",IF(F3>100%,"A")))))
ini maksud nya :) On 5/3/12, Kid Mr. <[email protected]> wrote: > Coba gunakan fungsi LookUp > =LookUp( *F3* , *{0,40,60,80,100} / 100* , *{"U","D","C","B","A"}* ) > > *F3 :: nilai data* > *{0,40,60,80,100} / 100 :: batas bawah* > *{"U","D","C","B","A"} :: nilai yang diambil* > > Wassalam, > Kid. > > 2012/5/3 Kid Mr. <[email protected]> > >> Apa gak salah Pak ? >> >> Coba dicek untuk semua persentase dari 0% sampai 100% dengan 100 baris >> data deh. >> >> >> Kid. >> >> 2012/5/3 Modby Matsnawabi <[email protected]> >> >>> ** >>> >>> >>> Oke thank's saran nya buat semua.. sudah solve.. >>> pake >>> >>> >>> =IF(F3>40%,"U",IF(40%>F3<60%,"D",IF(60%>F3<80%,"C",IF(80%>F3<100%,"B",IF(F3>100%,"A"))))) >>> >>> panjang sih,, nanti saya coba pake vlookup.. >>> >>> entah nii, kudu di kasih sedikit pencerahan(cloo) dulu baru bisaa. :) >>> >>> >>> >
