Coba pake fungsi IF dan AND contoh: =IF(AND(A1=1,B1<=3,C1=0,D1<=3,E1<=3),"GOOD",IF(AND(A1=2,B1<=6,AND(C1>=1,C1<=3),D1<=6,E1<=6),"STANDAR","POOR"))
----- Original Message ----- From: "Muhammad Yani" <[EMAIL PROTECTED]> To: <ITCENTER@yahoogroups.com> Sent: Thursday, February 02, 2006 9:33 AM Subject: [ITCENTER] Mohon bantuan Rumus Ms Exel > > Dear ITers > > Hallo rekan rekan, ada yang Jago Excel ..., bantuain Gue dong, > Ceritanya begini, ada Kolom " A,B,C,D,E " dengan kondisi " Jika A=1, > B=0-3, C=0, D=0-3, E=0-3 Maka "GOOD" : Jika A=2, B=4-6, C=1-3, D=4-6, > E=4-6 maka " STANDAR" selain itu="POOR" > tolong dong Pencerahannya, maklum gak pernah pake Fungsi di excel. > > Thank's B4 > > Yani > > > > > -- > www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia > Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] > :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: > ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## > $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ > > [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id > > > Yahoo! Groups Links > > > > > > -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/