Ya udah coba ini : =IF(B3<50,"D",IF(B3<55,"C-",IF(B3<60,"C",IF(B3<65,"C+",IF(B3<70,"B-",IF(B3<7 5,"B",IF(B3<80,"B+",IF(B3<85,"A-","A"))))))))
Warm Regards, Rochmad Sigit [ Rasa kecilnya diri ini saat berhadapan dengan masalah, bukan disebabkan oleh besarnya masalah, tetapi oleh kecilnya tujuan hidup. ] From: [email protected] [mailto:[email protected]] On Behalf Of Adie Oz Sent: Friday, August 06, 2010 10:58 AM To: [email protected] Subject: Re: ~ aga ~ Pliz Quest berbagi ilmu Dunk yang laenya dunk oummm ----- Original Message ----- From: Rochmad Sigit <mailto:[email protected]> To: [email protected] Sent: Friday, August 06, 2010 10:55 AM Subject: RE: ~ aga ~ Pliz Quest berbagi ilmu Dunk Ex : =IF(B5=0,"BETUL","SALAH") Warm Regards, Rochmad Sigit [ Rasa kecilnya diri ini saat berhadapan dengan masalah, bukan disebabkan oleh besarnya masalah, tetapi oleh kecilnya tujuan hidup. ] From: [email protected] [mailto:[email protected]] On Behalf Of Adie Oz Sent: Friday, August 06, 2010 10:52 AM To: [email protected] Subject: ~ aga ~ Pliz Quest berbagi ilmu Dunk Hai all Ada yang punya contoh rumus-rumus Logika if dalam Ms-Exel nga mentok nih Pliz Help me Thank's Adie Oz -- you have this email because you join to "aga-madjid" GoogleGroups. to post emails, just send to : [email protected] to join this group, send blank email to : [email protected] to quit from this group, just send email to : [email protected] if you wanna know me, please visit my facebook at [email protected] or add me in Yahoo Messenger at [email protected] or add my twitter @aga_madjid thanks for joinning this group. -- you have this email because you join to "aga-madjid" GoogleGroups. to post emails, just send to : [email protected] to join this group, send blank email to : [email protected] to quit from this group, just send email to : [email protected] if you wanna know me, please visit my facebook at [email protected] or add me in Yahoo Messenger at [email protected] or add my twitter @aga_madjid thanks for joinning this group. -- you have this email because you join to "aga-madjid" GoogleGroups. to post emails, just send to : [email protected] to join this group, send blank email to : [email protected] to quit from this group, just send email to : [email protected] if you wanna know me, please visit my facebook at [email protected] or add me in Yahoo Messenger at [email protected] or add my twitter @aga_madjid thanks for joinning this group. -- you have this email because you join to "aga-madjid" GoogleGroups. to post emails, just send to : [email protected] to join this group, send blank email to : [email protected] to quit from this group, just send email to : [email protected] if you wanna know me, please visit my facebook at [email protected] or add me in Yahoo Messenger at [email protected] or add my twitter @aga_madjid thanks for joinning this group.
<<image001.gif>>
