Mau nambahin sedikit, mungkin bisa dicoba juga formula ini : =EVEN(E3)-2 kemudian di copy ke bawah.
Salam, Hendrik Karnadi ________________________________ From: zainul ulum <[email protected]> To: [email protected] Sent: Tuesday, February 23, 2010 16:21:42 Subject: RE: [belajar-excel] Tanya: semua hasil jadi angka genap Maaf kalo double posting, tade internet connectionnya error ________________________________ From:zainul ulum [mailto:zainul_ u...@yahoo. com] Sent: Tuesday, February 23, 2010 4:21 PM 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 /----------- --------- --------- --------- --------- --------- -------\ | bergabung ke milis (subscribe) | | kirim mail kosong ke: belajar-excel- subscribe@ yahoogroups. com | | | | posting ke milis | | kirim kan ke: belajar-excel@ yahoogroups. com | | | | melihat file archive / mendownload lampiran | | http://www.mail- archive.com/ belajar-excel@ yahoogroups. com/ | | | | menhubungi moderators & owners: | | belajar-excel- ow...@yahoogroup s.com | | | | ExcelWeb <http://opi.110mb. com/> | \----------- --------- --------- --------- --------- --------- -------/ Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use . __________ Information from ESET NOD32 Antivirus, version of virus signature database 4888 (20100222) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset. com Reply to sender | Reply to group Messages in this topic (2) Recent Activity: * New Members 12 * New Files 1 Visit Your Group Start a New Topic /---------------------------------------------------------------\ | bergabung ke milis (subscribe) | | kirim mail kosong ke: [email protected] | | | | posting ke milis | | kirim kan ke: [email protected] | | | | melihat file archive / mendownload lampiran | | http://www.mail-archive.com/[email protected]/ | | | | menhubungi moderators & owners: | | [email protected] | | | | ExcelWeb <http://opi.110mb.com/> | \---------------------------------------------------------------/ Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use . New Email addresses available on Yahoo! Get the Email name you've always wanted on the new @ymail and @rocketmail. Hurry before someone else does! http://mail.promotions.yahoo.com/newdomains/aa/
