]] XL-mania [[ Tanya Random

2007-03-08 Terurut Topik Christanto
Dear Excelers,

Kenapa ya kalo saya pake fungsi =rand(), suka muncul angka negatif (0) padahal 
kan random antara angka 0 sampai dengan 1.

-criz

Re: ]] XL-mania [[ kira hari...

2007-02-17 Terurut Topik Christanto
nih saya ada caranya encik ahmad, hasilnya cantik, tanpa makro.
lihat yang di highlight kuning.

  - Original Message - 
  From: Ahmad 
  To: XL-mania@yahoogroups.com 
  Sent: Wednesday, February 14, 2007 9:21 AM
  Subject: ]] XL-mania [[ kira hari...


  apa khabar semua...

  saya ada sedikit kebuntuan...
  boleh bantu saya dalam pengiraan hari, bulan dan tahun dari tarikh 
tertentu
  saya dah cuba buat tapi formulanya x menjadihasilnya x logik...saya x 
dapat cari kesilapannya...
  harap kawan2 dapat bantu saya


  Thanks... 
  SYED AHMAD



--


  /---\

  Confidential and/ or privileged information may be contained in this
  e-mail and any attachments transmitted with it ('Message'). If you are
  not the addressee indicated in this Message (or responsible for 
  delivery of this Message to such person),you are hereby notified that
  any dissemination, distribution, printing or copying of this Message or
  any part thereof is prohibited. Please delete this Message if received 
  in  error and advise the sender by return e-mail. Opinions, conclusions
  and other information in this Message that do not relate to the 
  official business of this company shall be understood as neither given
  nor endorsed by this company.

  This mail is certified Virus Free by *ProtectNow! (InternetNow Sdn Bhd) 
  *Scanner Engine powered by Norman Virus Control

  \--/


kira hari.xls
Description: MS-Excel spreadsheet