Wah OK Tuh pak rumusnya

Kalo ingin semua hasil menjadi ganjil pakai apa ya??

 

 

 

 

Syukur

 

________________________________

From: [email protected]
[mailto:[email protected]] On Behalf Of zainul ulum
Sent: 23 Februari 2010 16:21
To: [email protected]
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: [email protected]
[mailto:[email protected]] On Behalf Of muhamad.syukur
Sent: Tuesday, February 23, 2010 4:08 PM
To: [email protected]
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
<mailto:[email protected]?subject=re:%20%5bbelajar-excel%5d%20Tanya:
%20semua%20hasil%20jadi%20angka%20genap>  | Reply to group
<mailto:[email protected]?subject=re:%20%5bbelajar-excel%5d%
20Tanya:%20semua%20hasil%20jadi%20angka%20genap>  

Messages in this topic
<http://groups.yahoo.com/group/belajar-excel/message/3595;_ylc=X3oDMTM1M
3VlOTUwBF9TAzk3MzU5NzE0BGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRtc
2dJZAMzNTk3BHNlYwNmdHIEc2xrA3Z0cGMEc3RpbWUDMTI2NjkxNzEwMgR0cGNJZAMzNTk1>
(3) 

Recent Activity: 

*                                 New Members
<http://groups.yahoo.com/group/belajar-excel/members;_ylc=X3oDMTJnbjRicj
RrBF9TAzk3MzU5NzE0BGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRzZWMDdn
RsBHNsawN2bWJycwRzdGltZQMxMjY2OTE3MTAy?o=6>  12 

*                                 New Files
<http://groups.yahoo.com/group/belajar-excel/files;_ylc=X3oDMTJoNXE5ZXJz
BF9TAzk3MzU5NzE0BGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRzZWMDdnRs
BHNsawN2ZmlsZXMEc3RpbWUDMTI2NjkxNzEwMg-->  1 

Visit Your Group
<http://groups.yahoo.com/group/belajar-excel;_ylc=X3oDMTJmZnMyZzYzBF9TAz
k3MzU5NzE0BGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRzZWMDdnRsBHNsaw
N2Z2hwBHN0aW1lAzEyNjY5MTcxMDI->  Start a New Topic
<http://groups.yahoo.com/group/belajar-excel/post;_ylc=X3oDMTJmNm8zbDkxB
F9TAzk3MzU5NzE0BGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRzZWMDZnRyB
HNsawNudHBjBHN0aW1lAzEyNjY5MTcxMDI->  

/---------------------------------------------------------------\
| 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/>                              |
\---------------------------------------------------------------/ 

Yahoo! Groups
<http://groups.yahoo.com/;_ylc=X3oDMTJlOXE0c2k1BF9TAzk3NDc2NTkwBGdycElkA
zIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRzZWMDZnRyBHNsawNnZnAEc3RpbWUDMTI2N
jkxNzEwMg--> 

Switch to: Text-Only
<mailto:[email protected]?subject=change%20deliv
ery%20Format:%20Traditional> , Daily Digest
<mailto:[email protected]?subject=email%20delivery:%2
0Digest>  * Unsubscribe
<mailto:[email protected]?subject=unsubscribe>
* Terms of Use <http://docs.yahoo.com/info/terms/> 

.

 
<http://geo.yahoo.com/serv?s=97359714/grpId=20627678/grpspId=1708298821/
msgId=3597/stime=1266917102/nc1=4507179/nc2=5741395/nc3=5733759> 



Kirim email ke