Re: [ITCENTER] Mohon bantuan Rumus Ms Exel
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/
Re: [ITCENTER] Mohon bantuan Rumus Ms Exel
Mungkin bisa di range dulu pa kalau penjumlahan antara A s/d E adalah 1 s/d 10 maka GOOD A s/d E adalah 15 s/d 23 maka STANDARD SELAIN itu POOR tapi setelah saya lihat range tsb, timbul pertanyaan baru kalau hasilnya 13 gimana ? apakah masuk GOOD,Standard or POOR ? kalau jawaban anda adalah masuk POOR, berarti logika diatas itu bisa dipakai, kalau tdk tinggal di modif saja Salam Ronald Irawan Pt. Sanghiang Perkasa Gd. Graha Kirana Lt.5 Jl Yos Sudarso Kav.88 Jakarta Muhammad Yani [EMAIL PROTECTED] Sent by: ITCENTER@yahoogroups.com 02/02/2006 09:33 AM Please respond to ITCENTER@yahoogroups.com To ITCENTER@yahoogroups.com cc 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 [Non-text portions of this message have been removed] -- 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/
