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$
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
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
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
>
*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
5 matches
Mail list logo