Bls: ]] XL-mania [[ Manipulasi Data - Kelipatan 10 ke bawah

Dear Musa,

 

Pakai saja di cell C2  =INT(B2/10)*10  , copy ke bawah dst

 

Regards

Herry Sutjipto

Dari: Musa Sitepu <musa.sitepu@mmg.com>
Kepada: "XL-mania@yahoogroups.com" <XL-mania@yahoogroups.com>
Dikirim: Sabtu, 15 Juni 2013 15:40
Judul: ]] 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.