Hello Muhammad,
tambah 4 kolom lagi, perlu karena kolom B-E ada range nya atau
ada yg bisa mempermudah?:
F =IF(B1<=3,0,1)
G =IF(C1=0,0,1)
H =IF(D1<=3,0,1)
I =IF(E1<=3,0,1)
Sedang tabel kondisi:
J =IF(AND(A1=1,F1=0,G1=0,H1=0,I1=0),"GOOD",
IF(AND(A1=2,F1=1,G1=1,H1=1,I1=1),"STANDAR","POOR"))
Belum di praktekin sih... jadi belum tau jalan apa nggak... :P
Thursday, February 2, 2006, 9:33:58 AM, you wrote:
MY> Hallo rekan rekan, ada yang jago Exel gak, bantuain Gue dong,
MY> Ceritanya begini, ada Kolom " A,B,C,D,E " dan Tabel kondisi " Jika A=1,
MY> 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,
MY> E=4-6 maka " STANDAR" selain itu="POOR"
MY> tolong dong Pencerahannya, maklum gak pernah pake Fungsi di excel.
MY> Thank's
MY> Yani
--
Best regards,
Budi mailto:[EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/mailplus/
<*> 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/
