Mr. andrie,
Ada yg kurang dengan rumus roundup-nya.
=roundup(G5/D5,n)
Dimana n bisa
0,1,2,.... tergantung pembulatan yg diinginkan sampe berapa desimal.
Cuma mau
melengkapi...
Thank You
Best Regards,
Daud Silaen
From:
[email protected] [mailto:[EMAIL PROTECTED] On Behalf Of M.Andrie Akbar
Sent: Monday, May 22, 2006 8:34 AM
To: '[email protected]'
Subject: RE: ]] XL-mania [[
perkalian/pembagian dgn pembulatan keatas/kebawah
pakai rumus
roundup aja bang di kolom L5
=ROUNDUP(G5/D5).
trus copykan ke bawah.
Gunanya agar
hasil yang didapat dibulatkan ke atas. Semoga berguna
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Saturday, May 20, 2006 9:54
AM
To: [email protected]
Subject: ]] XL-mania [[
perkalian/pembagian dgn pembulatan keatas/kebawah
excel-mania,
terima kasih atas informasi sebelumnya,
berikut ini saya lampirkan problem excel yg sedang saya hadapi
pembagian/perkalian dengan pembulatan ke atas atau kebawah
mohon bantuannya,
-kristian-
+-:: XL-mania ::::::::::::::::::::----------------------------------+
| |
| 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 |
| [EMAIL PROTECTED] atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/ |
+-------------------------------------------------------------------+
| Berikan testimoni Anda tentang XL-mania di : |
| http://www.friendster.com/profiles/xlmania |
+-------------------------------------------------------------------+
SPONSORED LINKS
YAHOO! GROUPS LINKS
"The above message is for the intended recipient only and may contain confidential information and/or may be subject to legal privilege. If you are not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this message, or any attachment, is strictly prohibited. If it has reached you in error please inform us immediately by reply e-mail or telephone, reversing the charge if necessary. Please delete the message and the reply (if it contains the original message) thereafter. Thank you."
|