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&#39;ve always wanted on the new @ymail and @rocketmail. 
Hurry before someone else does!
http://mail.promotions.yahoo.com/newdomains/aa/

Kirim email ke