{"id":5037,"date":"2023-07-04T18:35:34","date_gmt":"2023-07-04T18:35:34","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-angka-negatif-dalam-tanda-kurung\/"},"modified":"2023-07-04T18:35:34","modified_gmt":"2023-07-04T18:35:34","slug":"excel-angka-negatif-dalam-tanda-kurung","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-angka-negatif-dalam-tanda-kurung\/","title":{"rendered":"Excel: cara menampilkan angka negatif dalam tanda kurung"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan fitur <strong>Format Sel<\/strong> di Excel dengan rumus khusus untuk menampilkan angka negatif dalam tanda kurung.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Berikut adalah beberapa rumus umum yang dapat Anda gunakan untuk menampilkan angka negatif dalam format tertentu:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Rumus 1: Tunjukkan angka negatif dalam tanda kurung<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>#,##0.00;(#,##0.00)\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Rumus 2: Tampilkan Angka Negatif dengan Font Merah<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>#,##0.00;[Red]#,##0.00<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Rumus 3: Tampilkan angka negatif dengan huruf merah <em>dan<\/em> tanda kurung<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>#,##0.00;[Red](#,##0.00)<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan setiap rumus dalam praktik dengan kolom nilai berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39275 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nnum1.png\" alt=\"\" width=\"429\" height=\"396\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Tunjukkan angka negatif dalam tanda kurung<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Untuk menampilkan angka negatif dalam tanda kurung, sorot rentang sel <strong>A2:A11<\/strong> , lalu ketik <strong>Ctrl+1<\/strong> untuk menampilkan kotak <strong>Format Sel<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Lalu klik <strong>Kustom<\/strong> di kotak <strong>Kategori<\/strong> , lalu ketikkan rumus berikut di kotak <strong>Tipe<\/strong> :<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>#,##0.00;(#,##0.00)<\/strong> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39278 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nnum2.png\" alt=\"\" width=\"675\" height=\"615\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , setiap nilai negatif di kolom A akan ditampilkan dalam tanda kurung:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-39279\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nnum3.png\" alt=\"Excel menampilkan angka negatif dalam tanda kurung\" width=\"444\" height=\"404\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Tampilkan Angka Negatif dengan Font Merah<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Untuk menampilkan angka negatif berwarna merah, sorot rentang sel <strong>A2:A11<\/strong> , lalu ketik <strong>Ctrl+1<\/strong> untuk menampilkan kotak <strong>Format Sel<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Lalu klik <strong>Kustom<\/strong> di kotak <strong>Kategori<\/strong> , lalu ketikkan rumus berikut di kotak <strong>Tipe<\/strong> :<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>#,##0.00;[Red]#,##0.00<\/strong> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39280 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nnum4.png\" alt=\"\" width=\"678\" height=\"610\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , setiap nilai negatif di kolom A akan ditampilkan dengan warna merah:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-39281\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nnum5.png\" alt=\"Excel menampilkan angka negatif dengan warna merah\" width=\"471\" height=\"416\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Jika ingin menggunakan font dengan warna berbeda, cukup ganti <strong>Merah<\/strong> pada rumus dengan nama warna berbeda.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 3: Tampilkan angka negatif dengan huruf merah dan tanda kurung<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Untuk menampilkan angka negatif dalam warna merah <em>dan<\/em> tanda kurung, sorot rentang sel <strong>A2:A11<\/strong> , lalu ketik <strong>Ctrl+1<\/strong> untuk menampilkan kotak <strong>Format Sel<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Lalu klik <strong>Kustom<\/strong> di kotak <strong>Kategori<\/strong> , lalu ketikkan rumus berikut di kotak <strong>Tipe<\/strong> :<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>#,##0.00;[Red](#,##0.00)<\/strong> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39283 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nnum6.png\" alt=\"\" width=\"660\" height=\"589\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , setiap nilai negatif di kolom A akan ditampilkan dalam warna merah <em>dan<\/em> dalam tanda kurung:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-39282\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nnum7.png\" alt=\"Excel menampilkan angka negatif dalam warna merah dan tanda kurung\" width=\"452\" height=\"403\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/excel-menemukan-nilai-negatif-pertama-dalam-rentang\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara menemukan nilai negatif pertama dalam rentang tersebut<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/unggul-jika-bilangan-negatif-berfungsi\/\" target=\"_blank\" rel=\"noopener\">Excel: cara menggunakan fungsi IF dengan bilangan negatif<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-temukan-3-bilangan-positif-pertama\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara mencari 3 bilangan positif pertama dalam satu kolom<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan fitur Format Sel di Excel dengan rumus khusus untuk menampilkan angka negatif dalam tanda kurung. Berikut adalah beberapa rumus umum yang dapat Anda gunakan untuk menampilkan angka negatif dalam format tertentu: Rumus 1: Tunjukkan angka negatif dalam tanda kurung #,##0.00;(#,##0.00) Rumus 2: Tampilkan Angka Negatif dengan Font Merah #,##0.00;[Red]#,##0.00 Rumus 3: Tampilkan [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel: Cara menampilkan angka negatif dalam tanda kurung - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menampilkan angka negatif dalam tanda kurung di Excel, dengan beberapa contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/excel-angka-negatif-dalam-tanda-kurung\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara menampilkan angka negatif dalam tanda kurung - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menampilkan angka negatif dalam tanda kurung di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-angka-negatif-dalam-tanda-kurung\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-04T18:35:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nnum1.png\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/excel-angka-negatif-dalam-tanda-kurung\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-angka-negatif-dalam-tanda-kurung\/\",\"name\":\"Excel: Cara menampilkan angka negatif dalam tanda kurung - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-04T18:35:34+00:00\",\"dateModified\":\"2023-07-04T18:35:34+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menampilkan angka negatif dalam tanda kurung di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-angka-negatif-dalam-tanda-kurung\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-angka-negatif-dalam-tanda-kurung\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-angka-negatif-dalam-tanda-kurung\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara menampilkan angka negatif dalam tanda kurung\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel: Cara menampilkan angka negatif dalam tanda kurung - Statologi","description":"Tutorial ini menjelaskan cara menampilkan angka negatif dalam tanda kurung di Excel, dengan beberapa contoh.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/statorials.org\/id\/excel-angka-negatif-dalam-tanda-kurung\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara menampilkan angka negatif dalam tanda kurung - Statologi","og_description":"Tutorial ini menjelaskan cara menampilkan angka negatif dalam tanda kurung di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/excel-angka-negatif-dalam-tanda-kurung\/","og_site_name":"Statorials","article_published_time":"2023-07-04T18:35:34+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nnum1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/excel-angka-negatif-dalam-tanda-kurung\/","url":"https:\/\/statorials.org\/id\/excel-angka-negatif-dalam-tanda-kurung\/","name":"Excel: Cara menampilkan angka negatif dalam tanda kurung - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-04T18:35:34+00:00","dateModified":"2023-07-04T18:35:34+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menampilkan angka negatif dalam tanda kurung di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-angka-negatif-dalam-tanda-kurung\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-angka-negatif-dalam-tanda-kurung\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-angka-negatif-dalam-tanda-kurung\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara menampilkan angka negatif dalam tanda kurung"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/5037"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=5037"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/5037\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=5037"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=5037"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=5037"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}