Re: ]] XL-mania [[ cari average otomatis

[Jamz]

makasih mas....   tapi mas kok banyak angka di belakang koma.... misalnya baru satu kolom yang diisi dengan angka 100, averagenya keluar dengan angka 100,0071 sekian-sekian....harusnya kan 100 bulat aja...   maksud saya bisa gak komanya gak ada kalo emang gak ada.   contoh : kalo 2 kolom yang diisi 167 dan 134 memang avg nya harus ada koma             (167+134)/2=150,50             kalo 2 kolom yang diisi 100 dan 100 seharusnya avg nya gak ada koma.             (100+100)/2=100,00 (bulat)   please ya mas... maaf nih mas.....udah banyak banget nyusahin..hehehe....   -------Original Message-------   From: Ahmad Zamroni Date: 04/21/06 18:16:33 To: XL-mania@yahoogroups.com Cc: Jamz Subject: Re: ]] XL-mania [[ cari average otomatis   di N7 pasang rumus ini, terus copy ke bawah =M7/COUNTIF(C7:L7,">0") -zam-   +-:: XL-mania ::::::::::::::::::::----------------------------------+ |                                                                   | | DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, | | pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. | +-------------------------------------------------------------------+ | Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" | | Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. | +-------------------------------------------------------------------+ | Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  | | [EMAIL PROTECTED] atau kirimkan mereka file dari | | http://groups.yahoo.com/group/XL-mania/files/Promotion/           | +-------------------------------------------------------------------+ | Berikan testimoni Anda tentang XL-mania di :                      | | http://www.friendster.com/profiles/xlmania                        | +-------------------------------------------------------------------+ SPONSORED LINKS Business application software Microsoft excel training Microsoft excel tutorial Business application development Microsoft excel help Microsoft excel training course YAHOO! GROUPS LINKS  Visit your group "XL-mania" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. Disclaimer: Although this message has been checked for all known viruses using Trend Micro InterScan Messaging Security Suite, Bukopin accept no liability for any loss or damage arising from the use of this E-Mail or attachments.