Pada sel C2 ketik:
=ROUNDDOWN(B2,-1)
Salam,
Hendrik Karnadi
From: Musa Sitepu <musa.sitepu@mmg.com>
To: "XL-mania@yahoogroups.com" <XL-mania@yahoogroups.com>
Sent: Saturday, 15 June 2013, 15:40
Subject: ]] XL-mania [[ Manipulasi Data - Kelipatan 10 ke bawah
Dear all,
Saya mau memanipulasi data dengan mengubah angka menjadi kelipatan 10 ke bawah
Terlampir contohnya
Mohon bantuan para suhu sekalian
Salam,
Musa
Email Disclaimer: This email and any attachments may contain confidential information of MMG. It may also be legally privileged and/or the subject of copyright. If you are not an intended recipient, you may not copy, forward, disclose, save or use any part of it. If you have received this email in error, please notify the sender and delete the email and your reply from your system. Although this email has been checked for viruses and other defects, no responsibility can be accepted for any loss or damage arising from its receipt or use. MMG respects your privacy.
Nenhum comentário:
Postar um comentário