RE: [belajar-excel] Mencari rata-rata persentase

2011-09-13 Terurut Topik Budhi Cahyanto
Mr Kid, Thanks untuk formulasinya. Salam. _ From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com] On Behalf Of Mr. Kid Sent: Tuesday, September 13, 2011 2:38 PM Hai Budhi, Sheet1. =IF(A2<"T",6,3)%*(B2+C2) Sheet2. Array Formula (jangan lupa CSE) =AVERAGE(IF($B$

Re: [belajar-excel] Mencari rata-rata persentase

2011-09-13 Terurut Topik Mr. Kid
half Of *STDEV(i) > *Sent:* Tuesday, September 13, 2011 1:26 PM > *To:* **belajar-excel@yahoogroups.com** > *Subject:* Re: [belajar-excel] Mencari rata-rata persentase > > ** ** > > > > *di sheet data1* > > =IF(A2="","",IF(A2="T

Re: [belajar-excel] Mencari rata-rata persentase

2011-09-13 Terurut Topik Mr. Kid
Hai Budhi, Sheet1. =IF(A2<"T",6,3)%*(B2+C2) Sheet2. Array Formula (jangan lupa CSE) =AVERAGE(IF($B$3:$M$3=B$14,$B4:$M4/$D4:$O4)) Salam. Kid. 2011/9/13 Budhi Cahyanto > ** > > > Para pakar, > > Mohon bantuan para pakar excel untuk menyederhanakan rumus pada kolom E & F > (Data.1) sehingga dipe

RE: [belajar-excel] Mencari rata-rata persentase

2011-09-13 Terurut Topik Budhi Cahyanto
1:26 PM To: belajar-excel@yahoogroups.com Subject: Re: [belajar-excel] Mencari rata-rata persentase di sheet data1 =IF(A2="","",IF(A2="TK",0.03,0.06)*(B2+C2)) di sheet data2 =SUMPRODUCT(($B$3:$O$3=B$9)*($B4:$O4)) 2011/9/13 Budhi Cahyanto >

Re: [belajar-excel] Mencari rata-rata persentase

2011-09-12 Terurut Topik STDEV(i)
*di sheet data1* =IF(A2="","",IF(A2="TK",0.03,0.06)*(B2+C2)) *di sheet data2* =SUMPRODUCT(($B$3:$O$3=B$9)*($B4:$O4)) 2011/9/13 Budhi Cahyanto > > Mohon bantuan para pakar excel untuk menyederhanakan rumus pada kolom E & F (Data.1) sehingga diperoleh hasil pada kolom G2, dst. > > Acuan yang dig