Dear Rekan2,
mohon bantuannya, formula utk menentukan status barang dg kondisi/parameter terlampir.
mohon bantuannya, formula utk menentukan status barang dg kondisi/parameter terlampir.
Saya coba dg 2 formula, tp masih belum tepat 100%, mohon solusi nya.
Terima kasih.
nomor po | tanggal hari ini (td) | delivery date (dd) | received date (rd) | status (yg di Inginkan) | Formula I | Formula II | Parameter | ||
1 | 05/Jan/11 | 03/Sep/10 | 12/Aug/10 | on schedule | on schedule | FALSE | "on schedule" jika rd < atau = dd | ||
2 | 05/Jan/11 | 25/Jan/11 | NULL | aman | aman | aman | "aman" jika dd - td > 14 | ||
3 | 05/Jan/11 | 04/Feb/10 | 10/Mar/10 | telat | surat peringatan | FALSE | "telat" jika rd - dd > 0 | ||
4 | 05/Jan/11 | 21/Jan/10 | NULL | surat peringatan | surat peringatan | surat peringatan | "surat peringatan" jika td - dd > 14 | ||
5 | 05/Jan/11 | 08/Jan/11 | NULL | follow up | follow up | follow up | "follow up" jika dd - td < atau = 14 |
Wassalam,
rhoonal
__._,_.___
+-:: XL-mania ::::::::::::::::::::----------------------------------+
| "if you are the most valuable assets, you will show up on the |
| balance sheet..." - oNo Wiqe |
| 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 |
+-------------------------------------------------------------------+
| "if you are the most valuable assets, you will show up on the |
| balance sheet..." - oNo Wiqe |
| 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 |
+-------------------------------------------------------------------+
.
__,_._,___
Nenhum comentário:
Postar um comentário