Terima kasih banyak rekan2 ...sangat2 membantu sekali
2011/10/4 zainul ulum <<yahoo>> <[email protected]>
>
> Coba membantu ya,,
> Pakai tiga cara semuanya pakai formula array, silahkan dipilih sesuai
> kebutuhan:
> 1. dengan kolom bantu
> =SUM(IF((G7-L2:L5)<L2:L5,(G7-L2:L5),L2:L5)*J2:J5)/G7
>
> 2.tanpa kolom bantu
>
> =SUM(IF((G7-{250000000;250000000;500000000;1000000000})<{250000000;250000000
>
> ;500000000;1000000000},(G7-{250000000;250000000;500000000;1000000000}),{2500
> 00000;250000000;500000000;1000000000})*J2:J5)/G7
>
> 3. dengan defined name
> =SUM(IF((G7-Layer)<Layer,(G7-Layer),Layer)*J2:J5)/G7
>
> Mohon koreksi, jika ada yang salah...
>
> From: [email protected]
> On Behalf Of Yusril Ramadani
> Sent: Tuesday, October 04, 2011 9:08 AM
> To: [email protected]
> Subject: [belajar-excel] Perhitungan ekivalen rate dari layer
>
> Dear Para pakar
> mohon bantuannya untuk case terlampir
>
> saya ingin membuat satu formula gabungan dengan melihat layer2 persentase
> sehingga nanti total rupiah dg dana awal didapatkan ekivalen ratenya
>
> Terlampir contoh casenya
> Terimakasih banyak sebelumnya
>
> salam
> YR
------------------------------------
---------------------------------------------------------------------
bergabung ke milis (subscribe), kirim mail kosong ke:
[email protected]
posting ke milis, kirimkan ke:
[email protected]
berkunjung ke web milis
http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran
http://www.mail-archive.com/[email protected]/
atau (sejak 25-Apr-2011) bisa juga di :
http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: [email protected]
keluar dari membership milis (UnSubscribe):
kirim mail kosong ke [email protected]
---------------------------------------------------------------------Yahoo!
Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/belajar-excel/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/belajar-excel/join
(Yahoo! ID required)
<*> To change settings via email:
[email protected]
[email protected]
<*> 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/
