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. :)
>>
>>
>>
