coba ini mas... =IF(AND(B2>=2,B2<2.5),"Fair",IF(AND(B2>=2.5,B2<3),"Satisfactory",IF(AND(B2>=3,B2<3.5),"Very Good",IF(AND(B2>=3.5,B2<3.75),"Cum Laude",IF(AND(B2>=3.75,B2<3.9),"Magna Cum Laude",IF(AND(B2>=3.9,B2<=4),"Summa Cum Laude"))))))
semoga membantu hachi ________________________________ Dari: Yokie Radnan <[email protected]> Kepada: "[email protected]" <[email protected]> Dikirim: Jumat, 15 Maret 2013 7:59 Judul: ]] XL-mania [[ Peringkat IPK Selamat pagi para suhu excel, saya member baru nih, mohon pencerahannya untuk rumus peringkat IPK, file terlampir, sudah saya coba tetapi selalu false. Maklum, masih cetek ilmunya...hehehehe... Terima kasih
