tag:blogger.com,1999:blog-70960943697579001982011-11-10T06:16:15.065-08:00Si Pembatal NiatMr. Jalihttp://www.blogger.com/profile/09844572811893412625noreply@blogger.comBlogger21100tag:blogger.com,1999:blog-7096094369757900198.post-30507121955409512562011-06-20T10:50:00.001-07:002011-11-10T06:16:04.559-08:00<div align="center" class="MsoNormal" style="text-align: center;"><b><span lang="IN">CARA MENJUMLAH ANGKA DALAM TABEL (Microsoft Word)</span></b></div><div class="MsoNormal"><span lang="IN"> </span></div><table border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid1" style="border-collapse: collapse; border: none; margin-left: 5.4pt; mso-border-alt: solid black .75pt; mso-border-insideh: .75pt solid black; mso-border-insidev: .75pt solid black; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-yfti-tbllook: 480;"> <tbody><tr style="mso-yfti-firstrow: yes; mso-yfti-irow: 0;"> <td style="border: solid black 1.0pt; mso-border-alt: solid black .75pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 32.4pt;" valign="top" width="43"><div align="center" class="MsoNormal" style="text-align: center;"><span lang="IN">No</span></div></td> <td style="border-left: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 88.55pt;" valign="top" width="118"><div align="center" class="MsoNormal" style="text-align: center;"><span lang="IN">Nama</span></div></td> <td style="border-left: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 88.55pt;" valign="top" width="118"><div align="center" class="MsoNormal" style="text-align: center;"><span lang="IN">Satuan</span></div></td> <td style="border-left: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 88.55pt;" valign="top" width="118"><div align="center" class="MsoNormal" style="text-align: center;"><span lang="IN">Nominal</span></div></td> <td style="border-left: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 88.6pt;" valign="top" width="118"><div align="center" class="MsoNormal" style="mso-yfti-cnfc: 8; text-align: center;"><span lang="IN">Total</span></div></td> </tr><tr style="mso-yfti-irow: 1;"> <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 32.4pt;" valign="top" width="43"><div class="MsoNormal"><span lang="IN">1</span></div></td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 88.55pt;" valign="top" width="118"><div class="MsoNormal"><span lang="IN">Kunci (konceh)</span></div></td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 88.55pt;" valign="top" width="118"><div class="MsoNormal"><span lang="IN">2 Ons</span></div></td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 88.55pt;" valign="top" width="118"><div align="center" class="MsoNormal" style="text-align: center;"><span lang="IN">3000</span></div></td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 88.6pt;" valign="top" width="118"><div align="center" class="MsoNormal" style="mso-yfti-cnfc: 8; text-align: center;"><span lang="IN">6000</span></div></td> </tr><tr style="mso-yfti-irow: 2;"> <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 32.4pt;" valign="top" width="43"><div class="MsoNormal"><span lang="IN">2</span></div></td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 88.55pt;" valign="top" width="118"><div class="MsoNormal"><span lang="IN">Konyi’ (kunir)</span></div></td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 88.55pt;" valign="top" width="118"><div class="MsoNormal"><span lang="IN">5 Gr</span></div></td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 88.55pt;" valign="top" width="118"><div align="center" class="MsoNormal" style="text-align: center;"><span lang="IN">500</span></div></td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 88.6pt;" valign="top" width="118"><div align="center" class="MsoNormal" style="mso-yfti-cnfc: 8; text-align: center;"><span lang="IN">2500</span></div></td> </tr><tr style="mso-yfti-irow: 3; mso-yfti-lastrow: yes;"> <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 32.4pt;" valign="top" width="43"><div class="MsoNormal" style="mso-yfti-cnfc: 2;"><span lang="IN"> </span></div></td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 88.55pt;" valign="top" width="118"><div class="MsoNormal" style="mso-yfti-cnfc: 2;"><span lang="IN"> </span></div></td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 88.55pt;" valign="top" width="118"><div class="MsoNormal" style="mso-yfti-cnfc: 2;"><span lang="IN"> </span></div></td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 88.55pt;" valign="top" width="118"><div align="center" class="MsoNormal" style="mso-yfti-cnfc: 2; text-align: center;"><span lang="IN">3500</span><span lang="IN"></span></div></td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 88.6pt;" valign="top" width="118"><div align="center" class="MsoNormal" style="mso-yfti-cnfc: 10; text-align: center;"><span lang="IN">8500</span><span lang="IN"></span></div></td> </tr></tbody></table><div class="MsoNormal" style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt; text-indent: -36.0pt;"><span lang="IN">I.<span style="font: 7pt &quot;Times New Roman&quot;;"> </span></span><span dir="LTR"><span lang="IN">Tekan menu View </span></span><span lang="IN" style="font-family: Wingdings;">à</span><span lang="IN"> Toolbars </span><span lang="IN" style="font-family: Wingdings;">à</span><span lang="IN"> Tables and Borders</span></div><div class="MsoNormal" style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt; text-indent: -36.0pt;"><span lang="IN">II.<span style="font: 7pt &quot;Times New Roman&quot;;"> </span></span><span dir="LTR"><span lang="IN">Letakkan cursor pd akhir kolom Nominal (untuk mngetahui jmlh nominal) kmudian tekan AutoSum yg berlambang (Σ) pada sub menu Toolbars and Borders.</span></span></div><div class="MsoNormal" style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt; text-indent: -36.0pt;"><span lang="IN">III.<span style="font: 7pt &quot;Times New Roman&quot;;"> </span></span><span dir="LTR"><span lang="IN">Letakkan cursor pd akhir kolom Total (untuk mngetahui jmlh total) kmudian tekan AutoSum yg berlambang (Σ) pada sub menu Toolbars and Borders.</span></span></div><div class="MsoNormal" style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt; text-indent: -36.0pt;"><span lang="IN">IV.<span style="font: 7pt &quot;Times New Roman&quot;;"> </span></span><span dir="LTR"><span lang="IN">Begitu pula jika ingin menjumlah ke samping kanan</span></span></div><div class="MsoNormal" style="margin-left: 54.0pt;"><span lang="IN"> </span></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7096094369757900198-3050712195540951256?l=abangjali.blogspot.com' alt='' /></div>Mr. Jalihttp://www.blogger.com/profile/09844572811893412625noreply@blogger.com0tag:blogger.com,1999:blog-7096094369757900198.post-77028792668623579152010-09-14T00:23:00.000-07:002010-09-14T02:15:49.511-07:00<!--[if gte mso 9]><xml> <w:worddocument> <w:view>Normal</w:View> <w:zoom>0</w:Zoom> <w:punctuationkerning/> <w:validateagainstschemas/> <w:saveifxmlinvalid>false</w:SaveIfXMLInvalid> <w:ignoremixedcontent>false</w:IgnoreMixedContent> <w:alwaysshowplaceholdertext>false</w:AlwaysShowPlaceholderText> <w:compatibility> <w:breakwrappedtables/> <w:snaptogridincell/> <w:wraptextwithpunct/> <w:useasianbreakrules/> <w:dontgrowautofit/> </w:Compatibility> <w:browserlevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:latentstyles deflockedstate="false" latentstylecount="156"> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} table.MsoTableGrid {mso-style-name:"Table Grid"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; border:solid windowtext 1.0pt; mso-border-alt:solid windowtext .5pt; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-border-insideh:.5pt solid windowtext; mso-border-insidev:.5pt solid windowtext; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> <p class="MsoNormal" style="color: rgb(0, 0, 153); font-weight: bold;"><span style="" lang="IN">AVERAGE <span style=""> </span>= Menentukan Nilai Rata-rata</span></p> <p class="MsoNormal" style="color: rgb(0, 0, 153); font-weight: bold;"><span style="" lang="IN">MAX <span style=""> </span>= Menentukan Nilai Tinggi </span></p> <p class="MsoNormal" style="color: rgb(0, 0, 153); font-weight: bold;"><span style="" lang="IN">MIN <span style=""> </span>= Menentukan Nilai Rendah</span></p> <p class="MsoNormal" style="color: rgb(0, 0, 153); font-weight: bold;"><span style="" lang="IN">COUNT/COUNTA <span style=""> </span>= Menghitung Banyak Data</span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN"> </span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">Contoh :)= SUM(B7:B9)</span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN"><span style=""> </span><span style=""> </span><span style=""> </span>= AVERAGE(B1:B8)</span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN"><span style=""> </span><span style=""> </span><span style=""> </span>= MAX(B7:B17)</span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN"><span style=""> </span><span style=""> </span><span style=""> </span>= MIN(B7:B9)</span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN"><span style=""> </span><span style=""> </span><span style=""> </span>= COUNT(B5:B7)</span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN"> </span></p> <p class="MsoNormal" style="color: rgb(0, 0, 153); font-weight: bold;"><span style="" lang="IN">Cara menghilangkan baying-bayang. Tekan <i>Tools – Options – Gridlines.</i></span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN"> </span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">Contoh. 1<span style=""> </span><span style=""> </span>C<span style=""> </span>D</span></p> <table class="MsoTableGrid" style="margin-left: 72pt; border-collapse: collapse; border: medium none; color: rgb(0, 0, 153); font-weight: bold;" border="1" cellpadding="0" cellspacing="0"> <tbody><tr style=""> <td style="width: 45pt; border: 1pt solid windowtext; padding: 0cm 5.4pt;" valign="top" width="60"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">Nilai</span></p> </td> <td style="width: 75.6pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none;" valign="top" width="101"> <p class="MsoNormal"><span style="" lang="IN">Keterangan </span></p> </td> </tr> <tr style=""> <td style="width: 45pt; border-width: medium 1pt 1pt; border-style: none solid solid;" valign="top" width="60"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">84</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">75</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">65</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">45</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">55</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">60</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">11</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">70</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">80</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">82</span></p> </td> <td style="width: 75.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none;" valign="top" width="101"> <p class="MsoNormal"><span style="" lang="IN"> </span></p><br /></td> </tr> </tbody></table> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">Rumus : Keterangan </span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">Nilai > 60, lulus, lain itu tidak lulus.</span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><i><span style="" lang="IN">=IF(B60>60, “lulus”,”tidak lulus”)</span></i></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">___________________</span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">Contoh. 2<span style=""> </span>C<span style=""> </span>D</span></p> <table class="MsoTableGrid" style="margin-left: 72pt; border-collapse: collapse; border: medium none; color: rgb(0, 0, 153); font-weight: bold;" border="1" cellpadding="0" cellspacing="0"> <tbody><tr style=""> <td style="width: 72pt; border: 1pt solid windowtext; padding: 0cm 5.4pt;" valign="top" width="96"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">Total bayar</span></p> </td> <td style="width: 75.6pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none;" valign="top" width="101"> <p class="MsoNormal"><span style="" lang="IN"> Diskon </span></p> </td> </tr> <tr style=""> <td style="width: 72pt; border-width: medium 1pt 1pt; border-style: none solid solid;" valign="top" width="96"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">2000</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">30000</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">4000</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">5000</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">6000</span></p> </td> <td style="width: 75.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none;" valign="top" width="101"> <p class="MsoNormal"><span style="" lang="IN"> </span></p><br /></td> </tr> </tbody></table> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">Nilai>3000,diskon,15%sisa, lainnya tidak.</span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">=IF(B22>3000,*^~15%,”0”) enter.</span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">_____________________</span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">Contoh. 3<span style=""> </span>C<span style=""> </span>D <span style=""> </span>E</span></p> <table class="MsoTableGrid" style="margin-left: 72pt; border-collapse: collapse; border: medium none; color: rgb(0, 0, 153); font-weight: bold;" border="1" cellpadding="0" cellspacing="0"> <tbody><tr style=""> <td style="width: 81pt; border: 1pt solid windowtext; padding: 0cm 5.4pt;" valign="top" width="108"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">Harga barang</span></p> </td> <td style="width: 75.6pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none;" valign="top" width="101"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">Pembayaran</span></p> </td> <td style="width: 75.6pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none;" valign="top" width="101"> <p class="MsoNormal"><span style="" lang="IN">Keterangan </span></p> </td> </tr> <tr style=""> <td style="width: 81pt; border-width: medium 1pt 1pt; border-style: none solid solid;" valign="top" width="108"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">1500</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">300</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">30000</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">4000</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">5000</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">11000</span></p> </td> <td style="width: 75.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none;" valign="top" width="101"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">11000</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">2200</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">3400</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">5700</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">10000</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">20000</span></p> </td> <td style="width: 75.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none;" valign="top" width="101"> <p class="MsoNormal"><span style="" lang="IN"> </span></p><br /></td> </tr> </tbody></table> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">=IF(C5=D5,”lunas”,”kredit”)</span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">Keterangan : harga barang, lunas selain itu kredit.</span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">_______________</span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN"> </span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN"> </span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN"> </span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN"> </span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN"> </span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">=IF(G5>80,”A”,IF(G5>70,”B”,IF(G5>60,”C”,”D”)))</span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">Contoh. 4<span style=""> </span>B <span style=""> </span>C</span></p> <table class="MsoTableGrid" style="margin-left: 72pt; border-collapse: collapse; border: medium none; color: rgb(0, 0, 153); font-weight: bold;" border="1" cellpadding="0" cellspacing="0"> <tbody><tr style=""> <td style="width: 72pt; border: 1pt solid windowtext; padding: 0cm 5.4pt;" valign="top" width="96"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">Nilai </span></p> </td> <td style="width: 75.6pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none;" valign="top" width="101"> <p class="MsoNormal"><span style="" lang="IN">Nilai huruf</span></p> </td> </tr> <tr style=""> <td style="width: 72pt; border-width: medium 1pt 1pt; border-style: none solid solid;" valign="top" width="96"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN"> </span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN"> </span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN"> </span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN"> </span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN"> </span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN"> </span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN"> </span></p><br /></td> <td style="width: 75.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none;" valign="top" width="101"> <p class="MsoNormal"><span style="" lang="IN"> </span></p><br /></td> </tr> </tbody></table> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">Keterangan :</span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">Nilai>80-A</span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">Nilai>70-B</span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">Nilai>60-C</span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">Selain itu –D</span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">_______________________</span></p> <p class="MsoNormal" style="color: rgb(0, 0, 153); font-weight: bold;"><span style="" lang="IN">Contoh. 5</span></p> <table class="MsoTableGrid" style="margin-left: 72pt; border-collapse: collapse; border: medium none; color: rgb(0, 0, 153); font-weight: bold;" border="1" cellpadding="0" cellspacing="0"> <tbody><tr style=""> <td style="width: 81pt; border: 1pt solid windowtext; padding: 0cm 5.4pt;" valign="top" width="108"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">Nama </span></p> </td> <td style="width: 75.6pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none;" valign="top" width="101"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">Kode kelas</span></p> </td> <td style="width: 75.6pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none;" valign="top" width="101"> <p class="MsoNormal"><span style="" lang="IN">Nama kelas</span></p> </td> </tr> <tr style=""> <td style="width: 81pt; border-width: medium 1pt 1pt; border-style: none solid solid;" valign="top" width="108"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">Su orang</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">Da</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">Dg</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">Uc</span></p> </td> <td style="width: 75.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none;" valign="top" width="101"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">A</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">I</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">U</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">E</span></p> </td> <td style="width: 75.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none;" valign="top" width="101"> <p class="MsoNormal"><span style="" lang="IN"> </span></p><br /></td> </tr> </tbody></table> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">=IF(F2-“I”,”infor”,IF(F2=”S”,”Sosial”,”Bahasa Indo”)).</span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">Atau </span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">=IF(F2-“I”,”infor”,IF(F2=”S”,”Sosial”,IF(F2=”B”,”Bahasa Indo”))).</span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">Keterangan :</span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">I = Informatika</span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">S = Sosial</span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">B = Bahasa Indonesia</span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">_______________________</span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">Contoh. 6<span style=""> </span>B <span style=""> </span><span style=""> </span>C <span style=""> </span><span style=""> </span>D <span style=""> </span><span style=""> </span>E <span style=""> </span><span style=""> </span>F</span></p> <table class="MsoTableGrid" style="margin-left: 59.4pt; border-collapse: collapse; border: medium none; color: rgb(0, 0, 153); font-weight: bold;" border="1" cellpadding="0" cellspacing="0"> <tbody><tr style=""> <td style="width: 36pt; border: 1pt solid windowtext; padding: 0cm 5.4pt;" valign="top" width="48"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">No </span></p> </td> <td style="width: 75.6pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none;" valign="top" width="101"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">Nama </span></p> </td> <td style="width: 75.6pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none;" valign="top" width="101"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">Nilai</span></p> </td> <td style="width: 91pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none;" valign="top" width="121"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">Nilai huruf</span></p> </td> <td style="width: 77.15pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none;" valign="top" width="103"> <p class="MsoNormal"><span style="" lang="IN">Keterangan </span></p> </td> </tr> <tr style=""> <td style="width: 36pt; border-width: medium 1pt 1pt; border-style: none solid solid;" valign="top" width="48"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">1</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">2</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">3</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">4</span></p> </td> <td style="width: 75.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none;" valign="top" width="101"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">-</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">-</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">-</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">-</span></p> </td> <td style="width: 75.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none;" valign="top" width="101"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">80</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">75</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">65</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">60</span></p> </td> <td style="width: 91pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none;" valign="top" width="121"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">=IF(D5>83,”A”,</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">IF(D5>70,”B”,</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">”C”))</span></p> </td> <td style="width: 77.15pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none;" valign="top" width="103"> <p class="MsoNormal"><span style="" lang="IN">=IF(E5=”A”,</span></p> <p class="MsoNormal"><span style="" lang="IN">“lulus”,”tidak lulus”)</span></p> </td> </tr> </tbody></table> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">Keterangan :</span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">Nilail >83 dengan nilai A</span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">Nilai = 70 s/d 82 dengan nilai B</span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">Nilai di bawah 65 dengan nilai C</span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">____________________________</span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">Contoh. 7<span style=""> </span>B <span style=""> </span><span style=""> </span>C<span style=""> </span><span style=""> </span>D <span style=""> </span>E <span style=""> </span>F</span></p> <table class="MsoTableGrid" style="margin-left: 59.4pt; border-collapse: collapse; border: medium none; color: rgb(0, 0, 153); font-weight: bold;" border="1" cellpadding="0" cellspacing="0"> <tbody><tr style=""> <td style="width: 36pt; border: 1pt solid windowtext; padding: 0cm 5.4pt;" valign="top" width="48"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">No </span></p> </td> <td style="width: 75.6pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none;" valign="top" width="101"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">Nama </span></p> </td> <td style="width: 75.6pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none;" valign="top" width="101"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">Nilai teori</span></p> </td> <td style="width: 75.6pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none;" valign="top" width="101"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">Nilai praktek</span></p> </td> <td style="width: 75.6pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none;" valign="top" width="101"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">Keterangan </span></p> </td> </tr> <tr style=""> <td style="width: 36pt; border-width: medium 1pt 1pt; border-style: none solid solid;" valign="top" width="48"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">1</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">2</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">3</span></p> </td> <td style="width: 75.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none;" valign="top" width="101"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">-</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">-</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">-</span></p> </td> <td style="width: 75.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none;" valign="top" width="101"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">80</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">75</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">65</span></p> </td> <td style="width: 75.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none;" valign="top" width="101"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">83</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">73</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">60</span></p> </td> <td style="width: 75.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none;" valign="top" width="101"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN"> </span></p><br /></td> </tr> </tbody></table> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">Ket. =IF(and(C2>60,D2>60),”lulus”,”coba lagi”)</span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">________________________</span></p> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">Contoh. 8<span style=""> </span>B <span style=""> </span><span style=""> </span>C <span style=""> </span><span style=""> </span>D <span style=""> </span><span style=""> </span>E <span style=""> </span>F</span></p> <table class="MsoTableGrid" style="margin-left: 59.4pt; border-collapse: collapse; border: medium none; color: rgb(0, 0, 153); font-weight: bold;" border="1" cellpadding="0" cellspacing="0"> <tbody><tr style=""> <td style="width: 36pt; border: 1pt solid windowtext; padding: 0cm 5.4pt;" valign="top" width="48"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">No </span></p> </td> <td style="width: 90pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none;" valign="top" width="120"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">Mata pelajaran</span></p> </td> <td style="width: 75.6pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none;" valign="top" width="101"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">Nilai medel</span></p> </td> <td style="width: 86.4pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none;" valign="top" width="115"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">Nilai semester</span></p> </td> <td style="width: 75.6pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none;" valign="top" width="101"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">Keterangan </span></p> </td> </tr> <tr style=""> <td style="width: 36pt; border-width: medium 1pt 1pt; border-style: none solid solid;" valign="top" width="48"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">1</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">2</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">3</span></p> </td> <td style="width: 90pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none;" valign="top" width="120"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">Eokonomi</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">Kimia </span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">Fisika </span></p> </td> <td style="width: 75.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none;" valign="top" width="101"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">60</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">70</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">35</span></p> </td> <td style="width: 86.4pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none;" valign="top" width="115"> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">75</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">65</span></p> <p class="MsoNormal" style="text-align: center;" align="center"><span style="" lang="IN">67</span></p> </td> <td style="width: 75.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none;" valign="top" width="101"> <p class="MsoNormal" dir="RTL" style="text-align: center; direction: rtl; unicode-bidi: embed;" align="center"><span dir="LTR" style="" lang="IN">1200</span></p> </td> </tr> </tbody></table> <p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN">Ket. =IF(and(D23>50,E23>50),”lulus”,”tidak lulus”).</span></p><p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><br /></p><p style="color: rgb(0, 0, 153); font-weight: bold;" class="MsoNormal"><span style="" lang="IN"><br /></span></p><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7096094369757900198-7702879266862357915?l=abangjali.blogspot.com' alt='' /></div>Mr. Jalihttp://www.blogger.com/profile/09844572811893412625noreply@blogger.com0