tag:blogger.com,1999:blog-31077465040077837882024-03-09T04:03:43.853+08:00thesevenstringini blog peribadi... syering is kering!(kalau rajin la..)padukakerolhttp://www.blogger.com/profile/07611201957291303294noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-3107746504007783788.post-91632346336337911892016-05-24T02:10:00.003+08:002016-05-27T10:32:52.517+08:00WOWAPP - BERSOSIAL SAMBIL MENABUNG SEDIKIT-SEDIKIT, LAMA-LAMA JADI BUKIT SERINDITKepada yang nak cuba dapatkan sedikit income daripada bersosial media boleh la dengan kadar segera register <b><span style="font-size: large;"><a href="https://www.wowapp.com/w/padukakerol" target="_blank">WOWAPP</a></span></b>. At least ada jugaklah something yang kita boleh dapat sambil-sambil mengadap phone masing-masing. WowApp ni macam hybrid Whatsapp+Telegram+Skype.<br />
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
Dalam WowApp ni ada la iklan-iklan yang menjadi salah satu sumber income mereka. Iklan-iklan yang ada pada applikasi mahupun pada platform laman sesawang lelabah TIDAK PERLU diklik. Just nengok je sekali lalu.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
Aku pun baru join daaaa... register je la, bukan kena bayar pun.<br />
Maka dengan ini sudilah kiranya kalian klik link invitation aku untuk faedah bersama. Thanks in advance guys!<br />
<br />
<div style="text-align: center;">
<a href="https://www.wowapp.com/w/padukakerol" target="_blank"><span style="font-size: large;"><b>>>>>>>> KAMI NAK JOIN WOWAPP <<<<<<<</b></span></a> </div>
</div>
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><img border="0" height="640" src="https://4.bp.blogspot.com/-XL6C9ZQ1lq0/V0RppQqOHxI/AAAAAAAACcU/xDL8_LCn-7wQsUODgjsZcf3Ui7x_3deBQCLcB/s640/WowApp_2016-05-24_22-45-08.png" style="margin-left: auto; margin-right: auto;" width="568" /></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><a href="https://www.wowapp.com/w/padukakerol" target="_blank"><span style="font-size: small;"><b>WowApp aku yang masih newbie.. Meh la join aku punya network.</b></span></a></td></tr>
</tbody></table>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://1.bp.blogspot.com/-RLhFKIctHXU/V0RtUe9fzMI/AAAAAAAACco/ZsT4Acy6anE_7dwLfBnK22YXx-J-YgY5ACLcB/s1600/WowApp_2016-05-24_23-01-11.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="640" src="https://1.bp.blogspot.com/-RLhFKIctHXU/V0RtUe9fzMI/AAAAAAAACco/ZsT4Acy6anE_7dwLfBnK22YXx-J-YgY5ACLcB/s640/WowApp_2016-05-24_23-01-11.png" width="366" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><a href="https://www.wowapp.com/w/padukakerol" target="_blank"><span style="font-size: small;"><b>Ni buka kat PC/Laptop. WowApp ada versi window.</b></span></a></td></tr>
</tbody></table>
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://3.bp.blogspot.com/-m3f34FMzebM/V0erp__rUFI/AAAAAAAACc4/5wKpDIr0dD0gvmd12m5qUf_4hG14-uM2QCLcB/s1600/Selection_114.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="240" src="https://3.bp.blogspot.com/-m3f34FMzebM/V0erp__rUFI/AAAAAAAACc4/5wKpDIr0dD0gvmd12m5qUf_4hG14-uM2QCLcB/s400/Selection_114.png" width="400" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><b><span style="font-size: small;"><span style="font-family: "georgia" , "times new roman" , serif;"><a href="https://www.wowapp.com/w/padukakerol" target="_blank">Butiran wowcoin(WC) yang boleh nengok kat website WowApp. Kalau ikut current semasa ada dalam singgit lebih.. ini menyeronokkan beta.. ok le tu. Nak coin lebih gi main game kat website WowApp.</a></span></span></b></td></tr>
</tbody></table>
<br />
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://2.bp.blogspot.com/-f_HZ0vRpoi4/V0evZ6o5hSI/AAAAAAAACdE/O37aCCGEF3sgLMUIdw6U3fyexsiEPmIwQCKgB/s1600/Syuk%2BPenyata%2BPendapatan%2BWowApp.jpeg" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="310" src="https://2.bp.blogspot.com/-f_HZ0vRpoi4/V0evZ6o5hSI/AAAAAAAACdE/O37aCCGEF3sgLMUIdw6U3fyexsiEPmIwQCKgB/s400/Syuk%2BPenyata%2BPendapatan%2BWowApp.jpeg" width="400" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><a href="https://www.wowapp.com/w/padukakerol" target="_blank"><b><span style="font-size: small;"><span style="font-family: "georgia" , "times new roman" , serif;">RM40.54 is not bad gak... We earned something guys. Jom jadi one of my network. See you there.</span></span></b></a></td><td class="tr-caption" style="text-align: center;"><a href="https://www.wowapp.com/w/padukakerol" target="_blank"><b><span style="font-size: small;"><span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></span></b></a></td></tr>
</tbody></table>
<br />padukakerolhttp://www.blogger.com/profile/07611201957291303294noreply@blogger.com0tag:blogger.com,1999:blog-3107746504007783788.post-28934822361425065552012-05-21T21:35:00.004+08:002013-07-14T05:24:10.591+08:00AUTO-NOMBOR MS EXCEL<div dir="ltr" style="text-align: left;" trbidi="on">
Assalamualaikum...<br />
Ni salah satu cara kita nak menjimatkan masa semsa menaip data yg setinggi gunung-ganang di banjaran Himalaya!! <br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-gbIXtr56xDY/T7pD3i6BeWI/AAAAAAAAAfc/u9ybgYSG1bg/s1600/3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="140" src="http://4.bp.blogspot.com/-gbIXtr56xDY/T7pD3i6BeWI/AAAAAAAAAfc/u9ybgYSG1bg/s320/3.png" width="320" /></a></div>
<div style="text-align: center;">
<span style="font-size: x-small;"><i>klik foto untuk paparan lebih jelas. </i></span></div>
<br />
Formula yg ada dalam screenshot di atas:-<br />
<br />
<br />
AUTO-NUMBERING (CARA 1)<br />
=IF(C7=0,"",1)<br />
=IF(C8=0,"",B7+1)<br />
=IF(C9=0,"",B8+1)<br />
=IF(C10=0,"",B9+1)<br />
=IF(C11=0,"",B10+1)<br />
=IF(C12=0,"",B11+1)<br />
=IF(C13=0,"",B12+1)<br />
=IF(C14=0,"",B13+1)<br />
=IF(C15=0,"",B14+1)<br />
=IF(C16=0,"",B15+1)<br />
=IF(C17=0,"",B16+1)<br />
=IF(C18=0,"",B17+1)<br />
=IF(C19=0,"",B18+1)<br />
=IF(C20=0,"",B19+1)<br />
=IF(C21=0,"",B20+1)<br />
=IF(C22=0,"",B21+1)<br />
=IF(C23=0,"",B22+1)<br />
=IF(C24=0,"",B23+1)<br />
=IF(C25=0,"",B24+1)<br />
<br />
<br />
AUTO-NUMBERING(CARA 2)<br />
=IF(K6=0,"",1)<br />
=IF(K7=0,"",IF(K6=0,1,J6+1))<br />
=IF(K8=0,"",IF(K7=0,1,J7+1))<br />
=IF(K9=0,"",IF(K8=0,1,J8+1))<br />
=IF(K10=0,"",IF(K9=0,1,J9+1))<br />
=IF(K11=0,"",IF(K10=0,1,J10+1))<br />
=IF(K12=0,"",IF(K11=0,1,J11+1))<br />
=IF(K13=0,"",IF(K12=0,1,J12+1))<br />
=IF(K14=0,"",IF(K13=0,1,J13+1))<br />
=IF(K15=0,"",IF(K14=0,1,J14+1))<br />
=IF(K16=0,"",IF(K15=0,1,J15+1))<br />
=IF(K17=0,"",IF(K16=0,1,J16+1))<br />
=IF(K18=0,"",IF(K17=0,1,J17+1))<br />
=IF(K19=0,"",IF(K18=0,1,J18+1))<br />
=IF(K20=0,"",IF(K19=0,1,J19+1))<br />
=IF(K21=0,"",IF(K20=0,1,J20+1))<br />
=IF(K22=0,"",IF(K21=0,1,J21+1))<br />
=IF(K23=0,"",IF(K22=0,1,J22+1))<br />
=IF(K24=0,"",IF(K23=0,1,J23+1))<br />
<br />
<br /><a href="http://uploadur.com/files/om2nuyL1337606635.html" target="_blank"></a></div>
padukakerolhttp://www.blogger.com/profile/07611201957291303294noreply@blogger.com0tag:blogger.com,1999:blog-3107746504007783788.post-22456099564382487982011-09-05T14:06:00.000+08:002013-06-22T17:51:10.540+08:00TUTORIAL EXCEL FORMULA: =WORDNUM()<div style="text-align: center;">
<span style="font-size: large;"><span style="background-color: red; color: white;">This macro was written by Chris Mead - </span></span></div>
<div style="text-align: center;">
<span style="font-size: large;"><span style="background-color: red; color: white;">www.MeadInKent.co.uk </span></span></div>
<div style="text-align: center;">
<span style="font-size: large;"><span style="background-color: red; color: white;">→ tysm bro! ← </span></span></div>
<br />
Sekadar berkongsi macam mana kita nak tukarkan sesuatu nombor kepada perkataan dalam MS Excel. Di bawah ni aku tunjukkan dalam bentuk foto supaya mudah difahami.. insya-Allah. Memang formula nak tukarkan nombor kepada perkataan tidak akan kita jumpa punya. Alhamdulillah, setelah bertahun ber"google" terjumpalah pulak code ni. Tapi code cuma tukar nombor kepada perkataan English je la ye.. kalau Bahasa Melayu dan bahasa² lain tu.. korang otek la sendiri.. hehe..<br />
<br />
Kalau ada yg expert tu meh la tunjukkan kat aku macam mana nak buat. Pakat la share ngan aku dan sekelian orang lain. Ok.. beginilah flashback saya...<br />
<br />
<br />
<u><b>MS EXCEL 2007</b></u><br />
<br />
1. Gi la open satu blank excel file.<br />
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="http://3.bp.blogspot.com/-8HoMh5vzGks/TmRgSg4xBZI/AAAAAAAAAZU/-JEIG1_uyZU/s1600/1.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="193" src="http://3.bp.blogspot.com/-8HoMh5vzGks/TmRgSg4xBZI/AAAAAAAAAZU/-JEIG1_uyZU/s320/1.png" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Screenshot 1</td></tr>
</tbody></table>
<br />
<br />
2. Gi cari plak kat menu Developer > Visual Basic. Nak pantas tahap dewa gi tekan kat keyboard butang <span style="color: red;">Alt + F11</span>.<br />
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="http://3.bp.blogspot.com/-WoopCiNmE8A/TmRg8DAVPgI/AAAAAAAAAZY/IVn4wI5bJws/s1600/2.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="96" src="http://3.bp.blogspot.com/-WoopCiNmE8A/TmRg8DAVPgI/AAAAAAAAAZY/IVn4wI5bJws/s320/2.png" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Screenshot 2</td></tr>
</tbody></table>
<br />
<br />
3. Pastu kuar la cm gini.. pastu follow je mcm dlm foto bawah ni..<br />
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="http://2.bp.blogspot.com/-CteQNIeH3go/TmRg89Ixf0I/AAAAAAAAAZc/w5UC_u2nfTQ/s1600/3.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="311" src="http://2.bp.blogspot.com/-CteQNIeH3go/TmRg89Ixf0I/AAAAAAAAAZc/w5UC_u2nfTQ/s320/3.png" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Screenshot 3</td></tr>
</tbody></table>
<br />
3.1 Ni la rupa bentuk Visual Basic yg dah masukkan module baru. <br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="http://4.bp.blogspot.com/-eeqSNxim3BE/TmRg-bfes1I/AAAAAAAAAZg/q1N1vO1fKzg/s1600/4.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="199" src="http://4.bp.blogspot.com/-eeqSNxim3BE/TmRg-bfes1I/AAAAAAAAAZg/q1N1vO1fKzg/s320/4.png" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Screenshot 3.1</td></tr>
</tbody></table>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
4. Masukkan code ni kat page Module ni.<br />
<br />
<blockquote>
<span style="color: red;">Option Explicit</span><br />
<span style="color: red;">Public Numbers As Variant, Tens As Variant</span><br />
<br />
<span style="color: red;">Sub SetNums()</span><br />
<span style="color: red;">Numbers = Array("", "One", "Two", "Three", "Four", "Five", "Six", "Seven", "Eight", "Nine", "Ten", "Eleven", "Twelve", "Thirteen", "Fourteen", "Fifteen", "Sixteen", "Seventeen", "Eighteen", "Nineteen")</span><br />
<span style="color: red;">Tens = Array("", "", "Twenty", "Thirty", "Forty", "Fifty", "Sixty", "Seventy", "Eighty", "Ninety")</span><br />
<span style="color: red;">End Sub</span><br />
<br />
<span style="color: red;">Function WordNum(MyNumber As Double) As String</span><br />
<span style="color: red;">Dim DecimalPosition As Integer, ValNo As Variant, StrNo As String</span><br />
<span style="color: red;">Dim NumStr As String, n As Integer, Temp1 As String, Temp2 As String</span><br />
<span style="color: red;">' This macro was written by Chris Mead - www.MeadInKent.co.uk</span><br />
<br />
<span style="color: red;">If Abs(MyNumber) > 999999999 Then</span><br />
<span style="color: red;">WordNum = "Value too large"</span><br />
<span style="color: red;">Exit Function</span><br />
<span style="color: red;">End If</span><br />
<br />
<span style="color: red;">SetNums</span><br />
<br />
<span style="color: red;">' String representation of amount (excl decimals)</span><br />
<span style="color: red;">NumStr = Right("000000000" & Trim(Str(Int(Abs(MyNumber)))), 9)</span><br />
<span style="color: red;">ValNo = Array(0, Val(Mid(NumStr, 1, 3)), Val(Mid(NumStr, 4, 3)), Val(Mid(NumStr, 7, 3)))</span><br />
<br />
<span style="color: red;">For n = 3 To 1 Step -1 'analyse the absolute number as 3 sets of 3 digits</span><br />
<span style="color: red;">StrNo = Format(ValNo(n), "000")</span><br />
<br />
<span style="color: red;">If ValNo(n) > 0 Then</span><br />
<span style="color: red;">Temp1 = GetTens(Val(Right(StrNo, 2)))</span><br />
<span style="color: red;">If Left(StrNo, 1) <> "0" Then</span><br />
<span style="color: red;">Temp2 = Numbers(Val(Left(StrNo, 1))) & " hundred"</span><br />
<span style="color: red;">If Temp1 <> "" Then Temp2 = Temp2 & " and "</span><br />
<span style="color: red;">Else</span><br />
<span style="color: red;">Temp2 = ""</span><br />
<span style="color: red;">End If</span><br />
<br />
<span style="color: red;">If n = 3 Then</span><br />
<span style="color: red;">If Temp2 = "" And ValNo(1) + ValNo(2) > 0 Then Temp2 = "and "</span><br />
<span style="color: red;">WordNum = Trim(Temp2 & Temp1)</span><br />
<span style="color: red;">End If</span><br />
<span style="color: red;">If n = 2 Then WordNum = Trim(Temp2 & Temp1 & " thousand " & WordNum)</span><br />
<span style="color: red;">If n = 1 Then WordNum = Trim(Temp2 & Temp1 & " million " & WordNum)</span><br />
<br />
<span style="color: red;">End If</span><br />
<span style="color: red;">Next n</span><br />
<br />
<span style="color: red;">NumStr = Trim(Str(Abs(MyNumber)))</span><br />
<br />
<span style="color: red;">' Values after the decimal place</span><br />
<span style="color: red;">DecimalPosition = InStr(NumStr, ".")</span><br />
<span style="color: red;">Numbers(0) = "Zero"</span><br />
<span style="color: red;">If DecimalPosition > 0 And DecimalPosition < Len(NumStr) Then</span><br />
<span style="color: red;">Temp1 = " point"</span><br />
<span style="color: red;">For n = DecimalPosition + 1 To Len(NumStr)</span><br />
<span style="color: red;">Temp1 = Temp1 & " " & Numbers(Val(Mid(NumStr, n, 1)))</span><br />
<span style="color: red;">Next n</span><br />
<span style="color: red;">WordNum = WordNum & Temp1</span><br />
<span style="color: red;">End If</span><br />
<br />
<span style="color: red;">If Len(WordNum) = 0 Or Left(WordNum, 2) = " p" Then</span><br />
<span style="color: red;">WordNum = "Zero" & WordNum</span><br />
<span style="color: red;">End If</span><br />
<span style="color: red;">End Function</span><br />
<br />
<span style="color: red;">Function GetTens(TensNum As Integer) As String</span><br />
<span style="color: red;">' Converts a number from 0 to 99 into text.</span><br />
<span style="color: red;">If TensNum <= 19 Then</span><br />
<span style="color: red;">GetTens = Numbers(TensNum)</span><br />
<span style="color: red;">Else</span><br />
<span style="color: red;">Dim MyNo As String</span><br />
<span style="color: red;">MyNo = Format(TensNum, "00")</span><br />
<span style="color: red;">GetTens = Tens(Val(Left(MyNo, 1))) & " " & Numbers(Val(Right(MyNo, 1)))</span><br />
<span style="color: red;">End If</span><br />
<span style="color: red;">End Function</span></blockquote>
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="http://4.bp.blogspot.com/-z_Er_6Jl86E/TmRhAgjyVwI/AAAAAAAAAZo/msDDSigIB5k/s1600/5.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="192" src="http://4.bp.blogspot.com/-z_Er_6Jl86E/TmRhAgjyVwI/AAAAAAAAAZo/msDDSigIB5k/s320/5.png" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Screenshot 4</td></tr>
</tbody></table>
<br />
<br />
5. Pastu save code. (Nama fail ikut suka hati). Perhatikan kat "Save as type", pilih "Excel Macro-Enabled Workbook", pastu baru save.<br />
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="http://1.bp.blogspot.com/-hRQ-4QJVaKg/TmRg_Qh0nbI/AAAAAAAAAZk/oAKlNwuzZdQ/s1600/5.1.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="253" src="http://1.bp.blogspot.com/-hRQ-4QJVaKg/TmRg_Qh0nbI/AAAAAAAAAZk/oAKlNwuzZdQ/s320/5.1.png" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Screenshot 5</td></tr>
</tbody></table>
<br />
<br />
<div style="text-align: left;">
6. Lepas save tutup Visual Basic dan mari kita test apa yg kita dah buat. Kat kolum A korang letaklah apa² nilai yg korang suka. Kat kolum B, dalam cell yg pertama (B1), taipkan formula ni dan enter sekali. Selebihnya refer je kat foto bawah ni. Harap jadi la ye.. kalau kat MS Excel 2003 </div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: center;">
<span style="background-color: black;"><span style="font-size: large;"><b>=wordnum(A1)</b></span></span></div>
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="http://2.bp.blogspot.com/-c34mKhpFPUE/TmRhF8aqgUI/AAAAAAAAAZ4/mv6pJEsyvBU/s1600/6.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="238" src="http://2.bp.blogspot.com/-c34mKhpFPUE/TmRhF8aqgUI/AAAAAAAAAZ4/mv6pJEsyvBU/s320/6.png" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Screenshot 6</td></tr>
</tbody></table>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="http://2.bp.blogspot.com/-Uft4LNAl-tM/TmRhCe5WIrI/AAAAAAAAAZs/cCjwtUdjX1g/s1600/6.1.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="320" src="http://2.bp.blogspot.com/-Uft4LNAl-tM/TmRhCe5WIrI/AAAAAAAAAZs/cCjwtUdjX1g/s320/6.1.png" width="309" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Screenshot 6.1</td></tr>
</tbody></table>
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="http://3.bp.blogspot.com/-xkpWdf3DzQc/TmRhEBP4oUI/AAAAAAAAAZw/bN4vx-AdE6A/s1600/6.2.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="320" src="http://3.bp.blogspot.com/-xkpWdf3DzQc/TmRhEBP4oUI/AAAAAAAAAZw/bN4vx-AdE6A/s320/6.2.png" width="302" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Screenshot 6.2</td></tr>
</tbody></table>
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="http://4.bp.blogspot.com/-xe_rUxvjArM/TmRhFG8skYI/AAAAAAAAAZ0/V8nx4yzmklg/s1600/6.3.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="212" src="http://4.bp.blogspot.com/-xe_rUxvjArM/TmRhFG8skYI/AAAAAAAAAZ0/V8nx4yzmklg/s320/6.3.png" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Screenshot 6.3</td></tr>
</tbody></table>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div style="text-align: center;">
<b><i>Nota:</i></b></div>
<div style="text-align: center;">
<b><i> utk MS Excel 2003 step sama je, cuma bila masa nak save tu tak perlu usik "Save as type".</i></b></div>
<br />
<br />padukakerolhttp://www.blogger.com/profile/07611201957291303294noreply@blogger.com10tag:blogger.com,1999:blog-3107746504007783788.post-80172018906069686292011-07-05T18:11:00.000+08:002012-05-21T23:03:44.697+08:00KOD BENDERA PALESTINE?<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-5xbqPnKwglg/ThLhsaFKeTI/AAAAAAAAAZI/J6grn9uWDDg/s1600/pasumnohibutpalestineislam.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="300" src="http://4.bp.blogspot.com/-5xbqPnKwglg/ThLhsaFKeTI/AAAAAAAAAZI/J6grn9uWDDg/s400/pasumnohibutpalestineislam.jpg" width="400" /></a></div>
<div style="text-align: center;">
<br /></div>
<div style="text-align: justify;">
Pertama sekali aku minta maaf kalau foto yang aku edit ni mengganggu sensitiviti mana² pihak. Sebenarnya tidak ada kod yang terkandung dalam bendera ni melainkan hanya satu gambaran atau keinginan aku melihat semua umat Islam baik di Malaysia dan seluruh dunia, bersatu di bawah panji² Islam.</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: justify;">
Marilah kita semua duduk dalam satu jemaah dan rapatkanlah saf kita. Perselisihan itu perkara biasa, akan tetapi janganlah sampai kita lupa dari mana kita datang dan ke mana kita akan pergi. Janganlah kita kecewakan Rasul Allah Muhammad s.a.w. Baginda amat sayangkan kita semua di saat baginda nazak. Bersatulah kerana Allah!</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<br /></div>padukakerolhttp://www.blogger.com/profile/07611201957291303294noreply@blogger.com2tag:blogger.com,1999:blog-3107746504007783788.post-15571098682442081632010-09-01T08:26:00.000+08:002013-06-22T17:26:16.458+08:00QASIDAH BURDAH<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: center;">
<object height="385" width="480"><param name="movie" value="http://www.youtube.com/v/OsVFhHvbVlI?fs=1&hl=en_US&color1=0x234900&color2=0x4e9e00"></param>
<param name="allowFullScreen" value="true"></param>
<param name="allowscriptaccess" value="always"></param>
<embed src="http://www.youtube.com/v/OsVFhHvbVlI?fs=1&hl=en_US&color1=0x234900&color2=0x4e9e00" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="480" height="385"></embed></object></div>
<div style="text-align: center;">
credit to: <a href="http://www.youtube.com/user/12345like">12345like's</a></div>
<div style="text-align: center;">
<br /></div>
<div style="text-align: left;">
Biography about Prophet Muhammad (Sallallahu ^Alayhi Wa Salam)</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
:: The Life of Prophet Muhammad (Sallallahu ^Alayhi Wa Salam)</div>
<div style="text-align: left;">
Prophet Muhammad (Sallallahu ^Alayhi Wa Salam) was a Prophet at age of 40 in Mecca.</div>
<div style="text-align: left;">
He came with the holy book al-Qur'an.</div>
<div style="text-align: left;">
He taught us about the good things to do, and to stay away from the bad things.</div>
<div style="text-align: left;">
He taught us about the day of Judgment, Paradise and Hellfire.</div>
<div style="text-align: left;">
He taught us about Allah, the messengers.</div>
<div style="text-align: left;">
He taught us that Allah does not need anything and Allah does not look like anything.</div>
<div style="text-align: left;">
He immigrated to al-Madina with abu Bakr, and died in al-Madina at age 63.</div>
<div style="text-align: left;">
He spent 23 years delivering the message of Islam.</div>
<div style="text-align: left;">
He was very patient on those who harmed him, so he teach them Islam.</div>
<div style="text-align: left;">
He used to treat both, those who treat him good and treat him bad, with good manners.</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
:: The Family of Prophet Muhammad (Sallallahu ^Alayhi Wa Salam)</div>
<div style="text-align: left;">
The Mother of Prophet Muhammad (Sallallahu ^Alayhi Wa Salam) is Aminah.</div>
<div style="text-align: left;">
His Father is Abdullah.</div>
<div style="text-align: left;">
His Grandfather Abdul-Muttalib.</div>
<div style="text-align: left;">
His Great Grandfather is Hashim.</div>
<div style="text-align: left;">
His Great-Great Grandfather is Abdu-Manaf.</div>
<div style="text-align: left;">
He was from the tribe of Quraysh.</div>
<div style="text-align: left;">
He is the best of all creations.</div>
<div style="text-align: left;">
He was raised by his Grandfather Abdul-Muttalib.</div>
<div style="text-align: left;">
He was an Orphan, his mother died when he was 6 years old.</div>
<div style="text-align: left;">
He is the most beautiful prophet of All.</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
:: Teachins of Prophet Muhammad (Sallallahu ^Alayhi Wa Salam)</div>
<div style="text-align: left;">
Prophet Muhammad (Sallallahu ^Alayhi Wa Salam) is the last of all messengers.</div>
<div style="text-align: left;">
He is the slave of Allah and the best of all messengers.</div>
<div style="text-align: left;">
He was born in Mecca in the year of alfeel, known as the year of Elephant.</div>
<div style="text-align: left;">
He is the slave of Allah sent to both, Humans an Jinn.</div>
<div style="text-align: left;">
He was born on Monday 12th of Rabi^ al-Awwal according to Islamic calendar.</div>
<div style="text-align: left;">
He taught us that all prophets and messengers were Muslims worshipping Allah.</div>
<div style="text-align: left;">
He was truthful in everything that he conveyed about Allah and the hereafter.</div>
<div style="text-align: left;">
He taught us that Allah does not need anything and that Allah does not look like anything.</div>
<div style="text-align: left;">
He died in al-Madinah and was buried there in the chamber lady ^aishah.</div>
<div style="text-align: left;">
We Love Sallallahu ^Alayhi Wa Salam, May Peace and Blessing be Upon him.</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<a dir="ltr" href="http://alsunna.org/alhabib.htm" rel="nofollow" target="_blank" title="http://alsunna.org/alhabib.htm">http://alsunna.org/alhabib.htm</a></div>
</div>
padukakerolhttp://www.blogger.com/profile/07611201957291303294noreply@blogger.com0tag:blogger.com,1999:blog-3107746504007783788.post-55418436903745739012010-07-30T00:33:00.000+08:002010-07-30T00:36:43.618+08:00TUTORIAL EXCEL FORMULA: JISEN<div style="text-align: justify;">Setiap bulan aku kena masukkan data yang diperlukan dalam bil elektrik untuk mengetahui berapa jumlah keseluruhan bil yang harus dibayar. Cuma baru-baru ni ada masalah sikit dengan pembayaran bil yang tertunggak 1 bulan. Tapi aku still kena masukkan jumlah bil semasa mengikut bulan sebab aku ada jadual bil elektrik yang aku buat sendiri supaya aku senang nak buat rujukan dan semakan. Dalam excel aku dah create satu jadual yang ada data penggunaan elektrik seperti nama pengguna, tariff, jumlah unit kwh yang diguna, jumlah cas penggunaan bulanan dan sebagainya. Aku tak ada masalah bila nak masukkan data tu walaupun banyak, cuma aku selalu buat silap masa nak tentukan berapa jumlah cas penggunaan setelah dibundarkan mengikut kaedah JISEN nih.<br />
<a name='more'></a></div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">Contohnya kalau aku Jumlah(RM) Bil Semasa Bulanan adalah RM12.23 maka setelah diJISENkan, kita kenalah bayar RM12.25 yang mana inilah jumlah yang kena aku masukkan secara manual. Kalau setakat satu bil takpe lagi..ini beratus...huhu..</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">Lama jugak aku memikirkan sehinggalah pada satu malam, aku cuba dan terus mencuba dan akhirnya...aku berjaya selesaikan misteri bosantara nih. Macam mana? Dengan tahap pengetahuan aku tentang formula dalam microsoft excel ni, aku cuma guna fungsi IF()..haha..Selesai...selebihnya korang tengok je la foto yang aku upload ni..gunakan kalau perlu dan sebarkan kepada yang lain sekiranya ada yang berminat.<br />
<br />
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="http://3.bp.blogspot.com/__S7NGoTSwpk/TFGjnvUAWxI/AAAAAAAAAQo/VMUEG5W2s7Y/s1600/screenshot.17.jpg" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="288" src="http://3.bp.blogspot.com/__S7NGoTSwpk/TFGjnvUAWxI/AAAAAAAAAQo/VMUEG5W2s7Y/s400/screenshot.17.jpg" width="400" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Screenshot1</td></tr>
</tbody></table>Keterangan:<i> </i><br />
<blockquote><i>Screenshot1</i></blockquote><br />
<blockquote>Kalau korang tengok kat atas tu, macam tu la aku prepare satu jadual untuk tujuan rekod penggunaan elektrik. ada 2 bahagian. bahagian pertama yang berwarna kelabu tu dari kolum A - F, kat situ aku masukkan data yang berkaitan secara manual.</blockquote><blockquote>Dan data-data tu akan secara otomatik akan keluar di bahagian putih dari kolum M - P.</blockquote><blockquote>Kat screenshot1 korang nampak ada redbox di bahagian kelabu dan jugak di bahagian putih. okay, dalam kotak merah tu kolum D,M,N,O & P ada formula.(abaikan formula dalam kolum E.</blockquote><blockquote>Formula yang aku buat dalam cell D9:</blockquote><blockquote>=IF(C9=0,0,IF(VALUE(RIGHT(C9,1))=8,C9+0.02,IF(VALUE(RIGHT(C9,1))=9,C9+0.01,IF(VALUE(RIGHT(C9,1))=1,C9-0.01,IF(VALUE(RIGHT(C9,1))=2,C9-0.02,IF(VALUE(RIGHT(C9,1))=3,C9+0.02,IF(VALUE(RIGHT(C9,1))=4,C9+0.01,IF(VALUE(RIGHT(C9,1))=5,C9+0,IF(VALUE(RIGHT(C9,1))=6,C9-0.01,IF(VALUE(RIGHT(C9,1))=7,C9-0.02,IF(VALUE(RIGHT(C9,1))=0,C9+0,C9))))))))))) </blockquote><blockquote>Jadi cell C9 ni la yang aku kena ubah nilainya dan di cell D9 dengan formula yang aku dah setkan, so eureka! </blockquote><blockquote><b style="color: red;">Tapi sebelum tu, format number di cell C9 dan ke bawah mestilah dalam format text. </b></blockquote><blockquote><span style="color: black;">Maknanya dalam cell C9 kita kena taip penuh. contoh kalau nak masukkan nilai 0.90, so kita kena taip setiap angka</span> termasuk angka 0 di belakang sekali. <b>MESTI</b>. sebab? kalau kita taip .9 dengan menyangka excel akan anggap nilai yang kita cuba masukkan tersebut adalah nombor dan bukan text, silap tu beb..nanti result kat cell D9 jadi 1.00. tak caya korang boleh berexperimen ar..</blockquote><br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="http://1.bp.blogspot.com/__S7NGoTSwpk/TFGpaHnNLuI/AAAAAAAAAQw/8YpDOpI0jDA/s1600/screenshot.18.jpg" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="282" src="http://1.bp.blogspot.com/__S7NGoTSwpk/TFGpaHnNLuI/AAAAAAAAAQw/8YpDOpI0jDA/s400/screenshot.18.jpg" width="400" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Screenshot2</td></tr>
</tbody></table><div class="separator" style="clear: both; text-align: center;"></div><blockquote><i>Screenshot2</i></blockquote><blockquote>Screenshot yang kedua ni dalah contoh macam mana nombor sebelum JISEN dan sesudah JISEN. Abaikan kolum C.</blockquote><blockquote>Kolum B = sebelum JISEN.</blockquote><blockquote>Kolum D = selepas JISEN </blockquote><br />
<div style="color: blue; text-align: center;">Format JISEN(sekadar info):</div><div style="color: blue;"><br />
</div><div style="color: blue; text-align: center;"> Sebelum Selepas</div><div style="color: blue; text-align: center;">0.01 & 0.02 = 0.00</div><div style="color: blue; text-align: center;">0.03 & 0.04 = 0.05</div><div style="color: blue; text-align: center;">0.06 & 0.07 = 0.05</div><div style="text-align: center;"><span style="color: blue;">0.08 & 0.09 = 1.00</span></div></div>padukakerolhttp://www.blogger.com/profile/07611201957291303294noreply@blogger.com2tag:blogger.com,1999:blog-3107746504007783788.post-73979080889084479242010-06-27T05:14:00.000+08:002010-06-27T05:21:52.513+08:00TUTORIAL XP ALA² WINDOW7<div style="text-align: center;"><object height="192" width="320"><param name="movie" value="http://www.youtube.com/v/fejcbcZjx7o&hl=en_US&fs=1&rel=0"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/fejcbcZjx7o&hl=en_US&fs=1&rel=0" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="320" height="192"></embed></object></div><br />
<br />
<div style="text-align: justify;">Video ni aku rasa ada gunanya kepada mereka yang berminat nak tukar <a href="http://www.tinkernut.com/win7files.zip">XP kepada Window7</a>. Yang asal tetap XP la, cuma rupa jek yang macam Window7..leh la kot. <a href="http://www.blogger.com/">Download</a> file² yang perlu ada dan korang just follow step by step macam mana mamat ni buat kat tutorial dia. Tapi apa² jadi kat Pc korang ditanggung sendiri beb. Apa²hal set restore point sebelum install file² tu nanti. Selamat mencuba.</div>padukakerolhttp://www.blogger.com/profile/07611201957291303294noreply@blogger.com9tag:blogger.com,1999:blog-3107746504007783788.post-72428775182144266232010-05-21T18:52:00.000+08:002010-06-11T01:39:31.544+08:00TUTORIAL EXCEL FORMULA =COUNTIF() & SUMIF()<div style="text-align: justify;">Formula =COUNTIF() ni biasanya digunakan bila nak kira sesuatu kriteria. Contohnya korang nak kira ada berapa Ali dalam jadual atau database.</div><div style="text-align: justify;"> </div><div style="text-align: justify;">Formula =SUMIF() pula untuk penjumlahan. Contohnya jumlah markah/skor Ali dalam sesuatu kuiz.</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">Klik untuk besarkan imej nanti korang faham la kot?<br />
<br />
<a name='more'></a><br />
</div><div style="text-align: justify;"><br />
<div class="separator" style="clear: both; text-align: center;"><a href="http://2.bp.blogspot.com/__S7NGoTSwpk/S_atJDuVtRI/AAAAAAAAAI4/sgzjiwVOObU/s1600/screenshot.19.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="http://2.bp.blogspot.com/__S7NGoTSwpk/S_atJDuVtRI/AAAAAAAAAI4/sgzjiwVOObU/s320/screenshot.19.jpg" width="320" /></a></div><br />
</div><div class="separator" style="clear: both; text-align: justify;"></div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">Formula yang terlibat ( dalam cell G9 - G13 ):-</div><ul style="text-align: justify;"><li>=COUNTIF($C$9:$D$14,C9)</li>
<li>=COUNTIF($C$9:$D$14,C10)</li>
<li>=COUNTIF($C$9:$D$14,C11)</li>
<li>=COUNTIF($C$9:$D$14,C12)</li>
</ul><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">Formula yang terlibat ( dalam cell G16 - G20 ):-</div><ul style="text-align: justify;"><li style="text-align: justify;">=SUMIF($C$9:$D$14,F16,$D$9:$D$14)</li>
<li style="text-align: justify;">=SUMIF($C$9:$D$14,F17,$D$9:$D$14)</li>
<li style="text-align: justify;">=SUMIF($C$9:$D$14,F18,$D$9:$D$14)</li>
<li style="text-align: justify;">=SUMIF($C$9:$D$14,F19,$D$9:$D$14)</li>
</ul><div style="text-align: justify;"></div>padukakerolhttp://www.blogger.com/profile/07611201957291303294noreply@blogger.com2tag:blogger.com,1999:blog-3107746504007783788.post-76400294432087860282010-05-21T18:04:00.000+08:002010-06-11T01:40:31.838+08:00TUTORIAL EXCEL FORMULA =IF() [AUTO FILL NUMBER]<div style="text-align: justify;">Kali ini aku tunjukkan cara simple bagi senarai nombor di bahagian BILANGAN. Dengan merujuk di foto aku biasanya hanya perlu isikan kolum nama sahaja. Kolum bilangan tu aku setkan formula dulu.<br />
<br />
</div><div style="text-align: justify;">Aku rasa foto di bawah mungkin sudah jelas untuk korang. Selamat mencuba.<br />
Klik foto di bawah kalau tak jelas.<br />
<br />
<a name='more'></a><br />
</div><div style="text-align: justify;"><br />
</div><div class="separator" style="clear: both; text-align: center;"><a href="http://3.bp.blogspot.com/__S7NGoTSwpk/S_ZaP1GbA7I/AAAAAAAAAIo/aPTm_s60Mz0/s1600/screenshot.17.jpg" imageanchor="1"><img border="0" height="320" src="http://3.bp.blogspot.com/__S7NGoTSwpk/S_ZaP1GbA7I/AAAAAAAAAIo/aPTm_s60Mz0/s320/screenshot.17.jpg" width="320" /></a></div><div style="text-align: justify;"><br />
<br />
Formula yang terlibat ( dalam cell B17 - B20 ):- <br />
<ul><li>=IF(C17=0,"",1)</li>
<li>=IF(C18=0,"",B18+1)</li>
<li>=IF(C19=0,"",B19+1)</li>
<li>=IF(C20=0,"",B20+1)</li>
</ul></div>padukakerolhttp://www.blogger.com/profile/07611201957291303294noreply@blogger.com2tag:blogger.com,1999:blog-3107746504007783788.post-40663033623026124232010-05-12T15:36:00.000+08:002010-06-11T01:43:48.974+08:00TUTORIAL EXCEL FORMULA - MENGASINGKAN NOMBOR KE DALAM CELL<div style="text-align: justify;">Dalam artikel ni membabitkan beberapa formula seperti =IF(), =COUNT(), =MID(), =VALUE(), =OR() & =FIXED(), semata² aku nak pastikan angka 0 ditunjukkan mengikut yang sepatutnya. Sebelum ni aku ada cuba asingkan sebagai contoh nombor 101 menggunakan formula =MID(). Walaupun berjaya tetapi itu cuma berkesan sekiranya setiap angka tersebut disusun dari kiri ke kanan.<br />
<br />
<a name='more'></a><br />
</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">Tapi bila kita nak asingkan nombor tersebut dari ke kanan ke kiri, itu yang memeningkan kepala aku. Dengan formula =MID() sahaja, memang tak menjadi. Angka 0 di cell lain ada yang blank dan ada yang tunjukkan angka 0 tu tapi tak sesuai. Contohnya 101 bila diasingkan dari kanan ke kiri akan jadi 0 1 <blank> 1. Huhu..</blank></div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">Sehingga akhirnya aku berjaya selesaikan masalah ni dengan menggunakan beberapa formula(yang aku harapkan dapat lebih dipermudahkan lagi nanti). Dan angka 101 tu akan tunjukkan dalam setiap cell mengikut tepat apa yang sepatutnya. Harap korang dapat memahami apa yang aku tunjukkan kat bawah. Maaf sekiranya bahasa dan penerangan aku tunggang langgang.</div><div style="text-align: justify;"><br />
</div><div class="separator" style="clear: both; text-align: justify;">1] Cell² di kolum A11 - A14 adalah nombor² yang hendak dimasukkan.(input).</div><div style="text-align: justify;"><br />
</div><div class="separator" style="clear: both; text-align: justify;"><br />
</div><div class="separator" style="clear: both; text-align: justify;">2] Di kolum N(N5 - N8) pula, nombor² yg kita masukkan di kolum A(A11 - A14) telah diubah kepada format teks sebab formula =MID() hanya berkesan untuk format teks sahaja. Format lain pun boleh tapi untuk kes ni, kita kena ubah format nombor kepada teks. Kalau tak silap tak berapa sesuai sebab kalau korang guna format general atau nombor biasanya angka 0 takkan muncul atau cell blank.</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">So dalam cell N5 - N8 korang masukkan formula beriku:- </div><div class="photocaption_text" style="text-align: justify;"><ul><li>Cell N5: =IF(A11=0,"",FIXED(TEXT(A11/100000,"GENERAL"),5,0))</li>
<li>Cell N6: =IF(A12=0,"",FIXED(TEXT(A12/100000,"GENE<wbr></wbr>RAL"),5,0))</li>
<li>Cell N7: =IF(A13=0,"",FIXED(TEXT(A13/100000,"GENE<wbr></wbr>RAL"),5,0))</li>
<li>Cell N8: =IF(A14=0,"",FIXED(TEXT(A14/100000,"GENE<wbr></wbr>RAL"),5,0))</li>
</ul></div><div class="photocaption_text" style="text-align: justify;">3] Nombor tu plak kena asingkan dulu untuk mengenalpasti berapa angka yang ada dalam nombor tu yang akan ditunjukkan di kolum T(di langkah 4).</div><div class="photocaption_text" style="text-align: justify;"><br />
Dan masukkan formula² berikut </div><div class="photocaption_text" style="text-align: justify;"></div><div class="photocaption_text" style="text-align: justify;"> Baris ke 5</div><div class="photocaption_text" style="text-align: justify;"><ul><li>O5 =VALUE(MID(A11,$O$4,1))</li>
<li>P5 =VALUE(MID($A$11,P$4,1))</li>
<li>Q5 =VALUE(MID($A$11,Q$4,1))</li>
<li>R5 =VALUE(MID($A$11,R$4,1))</li>
<li>S5 =VALUE(MID($A$11,S$4,1))</li>
</ul><br />
Baris ke 6<br />
<ul><li>O6 =VALUE(MID(A12,$O$4,1))</li>
<li>P6 =VALUE(MID($A$12,P$4,1))</li>
<li>Q6 =VALUE(MID($A$12,Q$4,1))</li>
<li>R6 =VALUE(MID($A$12,R$4,1))</li>
<li>S6 =VALUE(MID($A$12,S$4,1))</li>
</ul></div><div class="photocaption_text" style="text-align: justify;"> Baris ke 7<br />
<ul><li>O7 =VALUE(MID(A13,$O$4,1))</li>
<li>P7 =VALUE(MID($A$13,P$4,1))</li>
<li>Q7 =VALUE(MID($A$13,Q$4,1))</li>
<li>R7 =VALUE(MID($A$13,R$4,1))</li>
<li>S7 =VALUE(MID($A$13,S$4,1))</li>
</ul></div><div class="photocaption_text" style="text-align: justify;"> </div><div class="photocaption_text" style="text-align: justify;"> Baris ke 8<br />
<ul><li>O8 =VALUE(MID(A14,$O$4,1))</li>
<li>P8 =VALUE(MID($A$14,P$4,1))</li>
<li>Q8 =VALUE(MID($A$14,Q$4,1))</li>
<li>R8 =VALUE(MID($A$14,R$4,1))</li>
<li>S8 =VALUE(MID($A$14,S$4,1))</li>
</ul><br />
<br />
4] Hasilnya di kolum T(T5 - T8), setiap nombor akan dinyatakan berapa jumlah angka(yg ada nilai). #VALUE! tu abaikan jer..memang dia akan tunjukkan benda tu bila takder nilai. Formula yang akan korang masukkan nanti kat kolum T ni takkan kira perkataan #VALUE! tu..don't worry..</div><div class="photocaption_text" style="text-align: justify;"></div><div class="photocaption_text" style="text-align: justify;"></div><div class="photocaption_text" style="text-align: justify;">Untuk itu korang kena la masukkan formula² berikut:-<br />
<ul><li>T5 =IF(A11=0,"",COUNT(O5:S5))</li>
<li>T6 =IF(A12=0,"",COUNT(O6:S6))</li>
<li>T7 =IF(A13=0,"",COUNT(O7:S7))</li>
<li>T8 =IF(A14=0,"",COUNT(O8:S8))</li>
</ul><br />
<br />
5] Akhir sekali korang masukkan plak dalam setiap cell formula² kat bawah nih:-</div><div class="photocaption_text" style="text-align: justify;"></div><div class="photocaption_text" style="text-align: justify;"></div><div class="photocaption_text" style="text-align: justify;"></div><div class="photocaption_text" style="text-align: justify;"></div><div class="photocaption_text"><div style="text-align: justify;">Dari cell O11 - S11 </div><ul style="text-align: justify;"><li>=IF(OR(T5=5,T5=6),MID(N5,3,1),"")</li>
<li>=IF(OR(T5=4,T5=5),MID(N5,4,1),"")</li>
<li>=IF(OR(T5=3,T5=4,T5=5),MID(N5,5,1),"")</li>
<li>=IF(OR(T5=2,T5=3,T5=4,T5=5),MID(N5,6,1),"")</li>
<li>=MID(N5,7,1)</li>
</ul><div style="text-align: justify;">Dari cell O12 - S12</div><ul style="text-align: justify;"><li> =IF(OR(T6=5,T6=6),MID(N6,3,1),"")</li>
<li>=IF(OR(T6=4,T6=5),MID(N6,4,1),"")</li>
<li>=IF(OR(T6=3,T6=4,T6=5),MID(N6,5,1),"")</li>
<li>=IF(OR(T6=2,T6=3,T6=4,T6=5),MID(N6,6,1),"")</li>
<li>=MID(N6,7,1)</li>
</ul><div style="text-align: justify;">Dari cell O13 - S13</div><ul style="text-align: justify;"><li>=IF(OR(T7=5,T7=6),MID(N7,3,1),"")</li>
<li>=IF(OR(T7=4,T7=5),MID(N7,4,1),"")</li>
<li>=IF(OR(T7=3,T7=4,T7=5),MID(N7,5,1),"")</li>
<li>=IF(OR(T7=2,T7=3,T7=4,T7=5),MID(N7,6,1),"")</li>
<li>=MID(N7,7,1)</li>
</ul><div style="text-align: justify;">Dari cell O14 - S14</div><ul style="text-align: justify;"><li>=IF(OR(T8=5,T8=6),MID(N8,3,1),"")</li>
<li>=IF(OR(T8=4,T8=5),MID(N8,4,1),"")</li>
<li>=IF(OR(T8=3,T8=4,T8=5),MID(N8,5,1),"")</li>
<li>=IF(OR(T8=2,T8=3,T8=4,T8=5),MID(N8,6,1),"")</li>
<li>=MID(N8,7,1)</li>
</ul><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">Ok, sekarang dah siap. Korang boleh cuba sendiri. Nak download fail yg asal ada kat link berikut:-</div><div style="text-align: justify;"><a href="http://www.scribd.com/doc/31242099/Mengasingkan-Nombor-Ke-Dalam-Cell">download</a>..</div><br />
<br />
</div><div class="separator" style="clear: both; text-align: center;"><a href="http://2.bp.blogspot.com/__S7NGoTSwpk/S-pQVX3c5XI/AAAAAAAAAIA/0aN9QE-ksV8/s1600/screenshot.11.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="http://2.bp.blogspot.com/__S7NGoTSwpk/S-pQVX3c5XI/AAAAAAAAAIA/0aN9QE-ksV8/s400/screenshot.11.jpg" width="400" /></a></div>padukakerolhttp://www.blogger.com/profile/07611201957291303294noreply@blogger.com3