Misal nilai di A1 = 91.779.600 maka rumus di A2 adalah =ROUNDUP(A1,-4)

Tks.
Sent from my BlackBerry® dapat pinjem

-----Original Message-----
From: "Aliif Akbar" <[email protected]>
Sender: [email protected]
Date: Wed, 14 Mar 2012 06:57:29 
To: <[email protected]>
Reply-To: [email protected]
Subject: Re: [belajar-excel] Bgmana Cara Pembulatan Keatas di Excel...?

Saya pernah pak,
Pake rumus

=round(91.800.000,-)
Misal nilai ada di A1, maka rumusnya =round(A1)

Cmiiw

Asr


Sent from my BlackBerry® smartphone from Sinyal Bagus XL, Nyambung Teruuusss...!

-----Original Message-----
From: dehen adam <[email protected]>
Sender: [email protected]
Date: Tue, 13 Mar 2012 22:11:10 
To: [email protected]<[email protected]>
Reply-To: [email protected]
Subject: [belajar-excel] Bgmana Cara Pembulatan Keatas di Excel...?

Teman-teman excel mania. Bgmana cara pembulatan ketas angka sbb:
Rp.91.779.600 menjadi 91.800.000,-
Mohon bantuan teman-teman sekalian. Terima kasih...

Kirim email ke