dear XLMania,
saya harus menghitung setoran untuk jatah preman, syaratnya:
1. sabtu minggu tidak ada setoran (preman elit)
2. diatas tanggal 25, jatah setoran naik, sebesar persentase tertentu yang bisa diubah2
3. jatah setoran juga bisa diubah2 tergantung maunya si preman
4. hari libur tidak ada setoran juga (preman mo liburan)
1. sabtu minggu tidak ada setoran (preman elit)
2. diatas tanggal 25, jatah setoran naik, sebesar persentase tertentu yang bisa diubah2
3. jatah setoran juga bisa diubah2 tergantung maunya si preman
4. hari libur tidak ada setoran juga (preman mo liburan)
saya pikir saya bisa gabungkan jadi 1 super duper mega formula, tp ternyata ilmunya masih kurang, jadi gagal nih... :(
detailnya ada di file excel, sepertinya ada yang salah untuk gabungin syarat no1 syarat no4
hayo gemana caranya biar semuanya bisa dihitung otomatis? apa bisa gabungin 2 vlookup (1 vlookup untuk cek sabtu minggu, 1 lagi untuk cek hari libur)??
tolong dibantu agar saya tidak digebukin sama preman di sini gara2 salah hitung
makasih ya
tolong dibantu agar saya tidak digebukin sama preman di sini gara2 salah hitung
makasih ya
felix
CONFIDENTIALITY NOTICE: This communication (which term shall include any attachments) contains information which is confidential and proprietary in nature and the copyright in which belongs to Zuellig Pharma Asia Pacific or a subsidiary of Zuellig Pharma Asia Pacific (hereafter referred to jointly and singularly as Zuellig Pharma) or a third party.
This communication is intended solely for the individual to whom it is addressed. If you are not the intended recipient of this communication, you may not disseminate, distribute, copy or otherwise disclose or use the contents of this communication without the written authority of Zuellig Pharma. If you have received this communication in error, please delete and destroy all copies and kindly notify the sender by return email or telephone immediately. Thank you.
Zuellig Pharma makes no representations or warranties in respect of the integrity of this communication, including but not limited to any warranty that this communication is free of errors, viruses or other malicious code, interception or interference.
____________
This message has been checked for all known viruses by the MessageLabs Virus Scanning Service. For further information, visit http:\\www.messagel
__._,_.___
+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Ada lowongan jadi direktur ga? Hubungi momods please... :D |
| 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 |
+-------------------------------------------------------------------+
| Ada lowongan jadi direktur ga? Hubungi momods please... :D |
| 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 |
+-------------------------------------------------------------------+
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
.
__,_._,___
Nenhum comentário:
Postar um comentário