Hot Fox

segunda-feira, 2 de janeiro de 2012

Re: ]] XL-mania [[ Pembulatan mengabaikan belakang koma

Pakai formula: =ROUNDDOWN(B5*C5,0), kemudian dicopy ke bawah.

Salam,

Hendrik Karnadi

From: Kekal Abadi <kekabadi@yahoo.com>
To: "XL-mania@yahoogroups.com" <XL-mania@yahoogroups.com>
Sent: Thursday, 29 December 2011, 11:09
Subject: ]] XL-mania [[ Pembulatan mengabaikan belakang koma

Dear para master XL

Saya ingin menanyakan fungsi apa agar bisa menampilkan angka pembulatan hasil hitungan secara otomatis dengan mengabaikan berapapun angka di belakang koma, tidak seperti otomatis defaultnya xl dimana kalau angka di belakang koma >5 akan dibulatkan ke atas.

Contoh:

222.333 x 2% = 4.446, 66 dibulatkan menjadi 4.446, bukan 4.447

222.111 x 2% = 4.442, 22 dibulatkan menjadi 4.442, bukan 4.443

contohnya terlampir

Atas bantuannya diucapkan terima kasih.

Kekal

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (5)

Recent Activity:

New Members 65

Visit Your Group

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| ayooo... coba cari XL-mania di linkedin.com                       |
| momods kebanyakan e-mail :(... unread di kantor 6 ribu lebih :(   |
+-------------------------------------------------------------------+
| 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

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

__,_._,___

Re: ]] XL-mania [[ Menghilangkan karakter (...) di list

=MID(G10,2,LEN(G10)-2)

G10 cell referensi...

From: Marthin Winner <marthin_was@yahoo.com>
To: "XL-mania@yahoogroups.com" <XL-mania@yahoogroups.com>
Sent: Wednesday, 28 December 2011, 17:53
Subject: ]] XL-mania [[ Menghilangkan karakter (...) di list

Para Suhu mohon sarannya,

Saya memiliki data dengan format seperti berikut:

Badu (Badu)

Anita (Anit)

Charli (che)

dan seterusnya, hasil yg diinginkan adalah karakter (..) dihilangkan, sehingga menjadi

Badu

Anita

Charli

Berhubung jumlah datanya sangat banyak, mohon sarannya untuk kasus ini.

Terima Kasih,

Marthin

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (7)

Recent Activity:

New Members 65

Visit Your Group

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

__,_._,___

domingo, 1 de janeiro de 2012

]] XL-mania [[ Mensortir Data

Dear rekan-2 XL-Mania,

Saya butuh bantuan lagi nih, saya membuat report sederhana untuk rekap data staff akan tretapi datanya banyak maka saya mau mengelompokkannya. Saya menggunakan pick list untuk memilih data staff percabang, akan tetapi pada fungsi yang saya gunakan yaitu fungsi VLOOKUP data yang muncul pada cabang lain namanya muncul doubel.

Mohon solusinya mungkin ada fungsi lain yang bisa mengakomodir laporan tersebut.

Regards,

AM. MUNAWAR

QA - CPC IndTim | PT. Bank CIMB Niaga, Tbk | Jl. A. Yani No. 33 Makassar | Phone : (+62)411-3635702 Ext. 130 Fax : (+62)411-334333 | Email : am.munawar@cimbniaga.co.id

Join us on Facebook www.facebook.com/cimbindonesia

Privileged/confidential information may be contained in this message. If you are not the named recipient or addressee, you are hereby notified that any use review, disclosure or copying of the contents herein is strictly prohibited. In such a case, kindly discard all its contents and notify sender accordingly regarding such unauthorized disclosure or transmission by email. Opinions, conclusions, statements and other information in this message that do not relate to the official business of CIMB Group shall be understood as neither given or endorsed by it. The contents herein are meant strictly for the use of the named recipient or addressee of CIMB Group. No assumption of responsibility or liability whatsoever is undertaken by CIMB Group in respect of prohibited and unauthorised use by any other person.

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity: