seperti menghitung banyaknya lembar/coin pecahan uang jika diketahui jumlah yg akan dibayar.
jika mau bayar 56,
berapa lembar pecahan 20 an,
berapa lembar pecahan 10-an, dan
berapa lembar pecahan 5-an
'gitukan yg dimaksud ??
| 5 | 10 | 20 | |||||||
| Total Karton | bonus (Ctn) | bonus (Ctn) | bonus (Ctn) | | Bonus (Rp) | Bonus (Rp) | Bonus (Rp) | | total (rp) |
| 6 | 5 | - | - | 75,000 | - | - | 75,000 | ||
| 17 | 5 | 10 | - | 75,000 | 200,000 | - | 275,000 | ||
| 37 | 5 | 10 | 20 | 75,000 | 200,000 | 450,000 | 725,000 | ||
| 48 | 5 | - | 40 | 75,000 | - | 900,000 | 975,000 | ||
| 4 | - | - | - | - | - | - | - | ||
| 56 | 5 | 10 | 40 | 75,000 | 200,000 | 900,000 | 1,175,000 | ||
| 61 | - | - | 60 | - | - | 1,350,000 | 1,350,000 | ||
| 89 | 5 | - | 80 | 75,000 | - | 1,800,000 | 1,875,000 | ||
| 5 | 5 | - | - | 75,000 | - | - | 75,000 | ||
| 10 | - | 10 | - | - | 200,000 | - | 200,000 |
dihitungnya dari "PECAHAN" terbesar
bonus kriteria 20 ctn =FLOOR(B6,$E$4)
bonus kriteria 10 ctn =FLOOR(B6-E6,$D$4)
bonus kriteria 20 ctn =FLOOR(B6-E6-D6,$C$4)
----- Original Message -----Sent: Wednesday, May 05, 2010 7:58 AMSubject: ]] XL-mania [[ Rumus BonusSelamat Pagi
Sy ada kendala untuk membuar rumus excel sesuai dengan contoh form di bawah ini :
contoh mekanisme nya :
1. jika ttl karton 6 ktn, maka dapat bonus 75.000
2. jika ttl karton 17 ktn, maka dpt bonus--> Rp. 200.000 (10 ktn) + Rp. 75.000 (5ktn) --> Total Bonus Rp. 275.000.-
3 jika ttl karton 37 ktn, maka dpt bonus--> Rp. 450.000 (20ktn) + Rp.200.000 (10ktn)+Rp. 75.000 (5ktn) --> Total Bonus 725.000.-
4. jika ttl karton 47 ktn, maka dpt bonus--> Rp. 900.000 (2x20 ktn ato 2 x Rp.450.000)+Rp.75.000 (5ktn) ---> Total Bonus 975.000.
dst.....
trims
Ganda P
__._,_.___
+-:: XL-mania ::::::::::::::::::::----------------------------------+
| uaaaaa... mau game maeeemoooooooo.... |
| http://www.facebook.com/group.php?gid=37671048001&ref=mf |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message, melecehkan, tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan winzip jika perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/ |
+-------------------------------------------------------------------+
| Berikan testimoni di : http://www.friendster.com/xlmania atau... |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html |
+-------------------------------------------------------------------+
| Message lama ada di : |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id] |
| http://www.mail-archive.com/xl-mania@yahoogroups.com |
+-------------------------------------------------------------------+
| uaaaaa... mau game maeeemoooooooo.... |
| http://www.facebook.com/group.php?gid=37671048001&ref=mf |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message, melecehkan, tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan winzip jika perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/ |
+-------------------------------------------------------------------+
| Berikan testimoni di : http://www.friendster.com/xlmania atau... |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html |
+-------------------------------------------------------------------+
| Message lama ada di : |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id] |
| http://www.mail-archive.com/xl-mania@yahoogroups.com |
+-------------------------------------------------------------------+
MARKETPLACE
.
__,_._,___
Nenhum comentário:
Postar um comentário