Re: ]] XL-mania [[ perhitungan jatahpreman otomatis pakai 2 vlookup??

 

Om om...... karena saya gak ngeti formula dasar excel   jadi saya pake vba makro oom biar gampang semua kondisi yang om (Banyak make Jika jika jika [if if if] he he he.........) minta udah siap oom   (File Terlampir): 1. Jika sabtu minggu tidak ada setoran (preman elit) 2. Jika diatas tanggal 25, jatah setoran naik, sebesar persentase tertentu yang bisa diubah2 (c11) 3. jatah setoran juga bisa diubah2 tergantung maunya si preman (b11) 4. Jika hari libur tidak ada setoran juga (preman mo liburan) 5. Jika tanggal di baris1 lewat dari bulan dasar (a6) maka tidak perlu dihitung alias nol 6. Jika lewat no1 diatas akan cek sabtu minggu (pakai vlookup)sesuai tabel e15:e30 - tanggal hari sabtu pertama tidak masalah diinput manual (e15) 7. Jika lewat no2 diatas akan cek tanggal, bila diatas 25 akan htung kenaikan sesuai persentase Note : 1    Isi Tanggal, Jatah Preman Persen Kenaikan     Bulan Dasar dan Libur 2    Tekan Tombol 3    Jangan Lupa Srikti Makronya ... Puthut Wibowo --- On Thu, 9/10/09, Hidajat, Felix <felix.hidajat@aplcare.com> wrote: From: Hidajat, Felix <felix.hidajat@aplcare.com> Subject: ]] XL-mania [[ perhitungan jatahpreman otomatis pakai 2 vlookup?? To: XL-mania@yahoogroups.com Date: Thursday, September 10, 2009, 4:24 PM   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)   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 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 abs.com\stats. asp

__._,_.___

Messages in this topic (3) Reply (via web post) | Start a new topic

Messages

+-:: 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              |
+-------------------------------------------------------------------+

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

Recent Activity

•  64
  New Members

Visit Your Group

Give Back

Yahoo! for Good

Get inspired

by a good cause.

Y! Toolbar

Get it Free!

easy 1-click access

to your groups.

Yahoo! Groups

Start a group

in 3 easy steps.

Connect with others.

.

__,_._,___