{"id":1417,"date":"2018-02-05T15:57:53","date_gmt":"2018-02-05T07:57:53","guid":{"rendered":"http:\/\/rais.my\/blog\/?p=1417"},"modified":"2018-02-05T16:05:07","modified_gmt":"2018-02-05T08:05:07","slug":"formula-array-excel-pernah-dengar","status":"publish","type":"post","link":"https:\/\/rais.my\/blog\/formula-array-excel-pernah-dengar\/","title":{"rendered":"Formula Array Excel, Pernah Dengar?"},"content":{"rendered":"<p>Sebenarnya saya pun baru tahu <strong>array formula<\/strong> ni. Cara pengiraan kita lagi ringkas dan mudah. sebagai contoh, kita ada satu jadual dan kita kena dapatkan jumlahkan besar setelah semua data-data dilakukan operasi-operasi tertentu.<\/p>\n<p><strong>Contoh<\/strong>:<br \/>\nKita perlu dapatkan Jumlah besar, (a+b)x(c-d).<\/p>\n<p><strong>Cara Pertama:<\/strong> Kira setiap baris (a+b)x(c-d) dan jumlahkan (sum) hasil setiap baris.<\/p>\n<p><strong>Cara Kedua:<\/strong> Gunakan array formula pada excel {=sum((a+b)x(c-d))}. Caranya, taip formula =sum((a+b)x(c-d)), selepas tu tekan serentak <strong>CTRL<\/strong>, <strong>SHIFT<\/strong> dan <strong>ENTER,<\/strong> curly bracket &#8221; { } &#8221; akan diletakkan automatik.<\/p>\n<p>Lihat gambar berikut, pasti lagi senang faham. Apa-apa komen yee&#8230;&#8230;<\/p>\n<p><a href=\"http:\/\/rais.my\/blog\/wp-content\/uploads\/2018\/02\/array-formula.png\"><img  title=\"\" loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1419\" src=\"http:\/\/rais.my\/blog\/wp-content\/uploads\/2018\/02\/array-formula-300x160.png\"  alt=\"array-formula-300x160 Formula Array Excel, Pernah Dengar?\"  width=\"300\" height=\"160\" srcset=\"https:\/\/rais.my\/blog\/wp-content\/uploads\/2018\/02\/array-formula-300x160.png 300w, https:\/\/rais.my\/blog\/wp-content\/uploads\/2018\/02\/array-formula-50x27.png 50w, https:\/\/rais.my\/blog\/wp-content\/uploads\/2018\/02\/array-formula.png 736w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>p\/s: Terima kasih pada Cikgu Excel (<strong>Cikgu Suhaila<\/strong>) atas tips dan tunjuk ajar.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sebenarnya saya pun baru tahu array formula ni. Cara pengiraan kita lagi ringkas dan mudah. sebagai contoh, kita ada satu jadual dan kita kena dapatkan jumlahkan besar setelah semua data-data dilakukan operasi-operasi tertentu. Contoh: Kita perlu dapatkan Jumlah besar, (a+b)x(c-d). Cara Pertama: Kira setiap baris (a+b)x(c-d) dan jumlahkan (sum) hasil setiap baris. Cara Kedua: Gunakan [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1418,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cybocfi_hide_featured_image":"","footnotes":""},"categories":[753,483,5,1],"tags":[754,180,183,520,610,519],"class_list":["post-1417","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-matematik","category-programming","category-umum","tag-array","tag-contoh","tag-example","tag-excel","tag-formula","tag-microsoft"],"_links":{"self":[{"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/posts\/1417","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/comments?post=1417"}],"version-history":[{"count":3,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/posts\/1417\/revisions"}],"predecessor-version":[{"id":1422,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/posts\/1417\/revisions\/1422"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/media\/1418"}],"wp:attachment":[{"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/media?parent=1417"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/categories?post=1417"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/tags?post=1417"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}