Mbak Siti, Saya Tambahkan, Misal cell A1 = 196455960 cell B1 = 2619403200 Ketika saya cari % Cell B1 terhadap cell A1 maka hasilnya = 7,50002748717723% Dalam hal ini kalo saya pake rounddown maka hasilnya jadi 7,00 % bukan 7,50% bagaimana mbak,
--- On Sun, 1/10/10, siti Vi <[email protected]> wrote: From: siti Vi <[email protected]> Subject: Re: [belajar-excel] Mengambil 2 digit angka di belakang koma To: [email protected] Date: Sunday, January 10, 2010, 1:42 AM misal tanda pemisah desimal = TITIK, tanda pemisah riuan = KOMA. & data yg akan di PROSES (bilangan 7.124) ada di cell A1 rumus sederhananya =ROUNDDOWN(A1, 2) Nilai hasilnya: 7.12 Penampakannya di sheet bisa 7.12 7.120 7.1200 7.12000 dst tergantung cell-format-nya worksheet function ROUNDDOWN Rounds a number down, toward zero. Syntax ROUNDDOWN(number, num_digits) Number is any real number that you want rounded down. Num_digits is the number of digits to which you want to round number. Remarks ROUNDDOWN behaves like ROUND, except that it always rounds a number down.. If num_digits is greater than 0 (zero), then number is rounded down to the specified number of decimal places. If num_digits is 0, then number is rounded down to the nearest integer. If num_digits is less than 0, then number is rounded down to the left of the decimal point. ----- Original Message ----- From: si Nung To: belajar-excel@ yahoogroups. com Sent: Sunday, January 10, 2010 2:25 PM Subject: Re: [belajar-excel] Mengambil 2 digit angka di belakang koma 1.. tentukan berapa digit dibelakang koma (x) yg dibutuhkan, misal (x) = 2 2. kalikan bilangan tsb dengan 10 pangkat (x), 10 pangkat 2 = 100 ==> 7,124 x 10^2 = 712,7 3. integer hasil perkalian hasil dari nomor 2 ==> int (712,7) = 712 4. hasil nomor 3 dibagi 10 pangkat (x) = 712/100 = 7,12 menjadi rumus di excell == > int(7,124*10^ 2)/10^2 = 7,12 cmiiw sinung On 9 Jan 2010 at 21:55, Irwan didi wrote: > Dear Para Suhu, > Mohon petunjuk nich bagaimana formula untuk mengambil angka > dibelakang koma tanpa ada unsur di naikkan atau di turunkan, karena > berpengaruh terhadap perhitungan apabila dat dikalikan dengan data lain. > > Misal : > 7,124 hasilnya harus 7,12 > 7,288 hasilnya harus 7,28 > Terima Kasih > Irwan
Data Rounddown.xls
Description: MS-Excel spreadsheet
