Kalau dalam hal ini, tidak usah rounddown, cukup format cell number pilih percentage dan set decimal places -nya 2
Kid. 2010/1/11 Irwan didi <[email protected]> > > > 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 <http://mc/[email protected]> > *To:* belajar-excel@ yahoogroups. > com<http://mc/[email protected]> > *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 > > > >
