Tambah belajar mas Hendrik. Sumpah aku baru tahu kalo ada function =ODD() dan EVEN()
________________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of hendrik karnadi Sent: Tuesday, February 23, 2010 5:02 PM To: [email protected] Subject: Re: [belajar-excel] Tanya: semua hasil jadi angka genap =ODD(E3)-2 Ini ngetes kreatifitas ? Salam, Hendrik Karnadi ________________________________________ From: muhamad.syukur <[email protected]> To: [email protected] Sent: Tuesday, February 23, 2010 16:49:29 Subject: RE: [belajar-excel] Tanya: semua hasil jadi angka genap Wah OK Tuh pak rumusnya Kalo ingin semua hasil menjadi ganjil pakai apa ya?? Syukur ________________________________________ From: belajar-excel@ yahoogroups. com [mailto: belajar-excel@ yahoogroups. com ] On Behalf Of zainul ulum Sent: 23 Februari 2010 16:21 To: belajar-excel@ yahoogroups. com Subject: RE: [belajar-excel] Tanya: semua hasil jadi angka genap Coba =FLOOR(ROUNDDOWN( E3,0),2) Apakah sesuai dengan yang dimaksud? ~selamat mencoba~ _zainul_ ________________________________________ From: belajar-excel@ yahoogroups. com [mailto: belajar-excel@ yahoogroups. com ] On Behalf Of muhamad.syukur Sent: Tuesday, February 23, 2010 4:08 PM To: belajar-excel@ yahoogroups. com Subject: [belajar-excel] Tanya: semua hasil jadi angka genap Dear shenshei Mohon bantuannya dong, Adakah rumus yang memungkinkan semua hasil menjadi genap Bila hasil : 1. 22.8 menjadi 22 2. 23.6 menjadi 22 Terima kasih sebelumnya Regard, Syukur Reply to sender | Reply to group Messages in this topic (3) Switch to: Text-Only, Daily Digest Unsubscribe Terms of Use . ________________________________________ Get your preferred Email name! Now you can @ymail.com and @rocketmail.com. __________ Information from ESET NOD32 Antivirus, version of virus signature database 4889 (20100223) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com
