{"id":1610,"date":"2023-11-15T11:48:49","date_gmt":"2023-11-15T11:48:49","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/jika-negatif-maka-nol\/"},"modified":"2023-12-06T06:17:31","modified_gmt":"2023-12-06T06:17:31","slug":"jika-negatif-maka-nol","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/jika-negatif-maka-nol\/","title":{"rendered":"Bagaimana cara menghilangkan nilai negatif di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-4051167095\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Izinkan saya berbagi contoh dengan Anda. Pada tabel berikut, Anda memiliki tabel dengan dua daftar nomor di kolom A dan B. Dan di kolom C, Anda memiliki perbedaan di antara keduanya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64144\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-avec-des-valeurs-negatives.png\" sizes=\"auto, \" srcset=\"\" alt=\"tabel-dengan-nilai-negatif\" width=\"381\" height=\"298\"><\/figure><\/div><p> Sekarang disini kita perlu menggunakan rumus untuk mengubah nilai negatif menjadi nol. Jadi dalam tutorial ini kita melihat berbagai cara menulis rumus untuk mengubah bilangan negatif menjadi nol.<\/p><h2 id=\"convert-negative-numbers-using-if\" class=\"wp-block-heading\"> Konversi bilangan negatif menggunakan IF<\/h2><p> Cara pertama adalah dengan menggunakan fungsi IF yang memungkinkan Anda membuat kondisi untuk memeriksa apakah suatu bilangan negatif dan kemudian mengonversi bilangan tersebut menjadi nol. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64145\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/convertir-un-nombre-negatif.png\" sizes=\"auto, \" srcset=\"\" alt=\"konversi-angka-negatif\" width=\"372\" height=\"293\"><\/figure><\/div><p> Gunakan langkah-langkah berikut.<\/p><ol type=\"1\"><li> Masukkan fungsi IF di sel C2.<\/li><li> Tentukan rumus pengurangan sel A1 dari B1.<\/li><li> Gunakan tanda lebih besar dengan nol untuk menciptakan suatu kondisi.<\/li><li> Untuk value_if_true, tentukan nol.<\/li><li> Dan untuk value_if_false, masukkan rumus pengurangan yang Anda gunakan dalam kondisi tersebut.<\/li><li> Masukkan tanda kurung penutup dan tekan Enter untuk mendapatkan hasilnya.<\/li><\/ol><p> Dengan mengikuti langkah-langkah di atas, Anda telah menulis rumus yang mengurangkan dua nilai dan menguji hasilnya. Jika hasilnya bilangan negatif, maka ubahlah bilangan negatif tersebut menjadi nol, atau hasil normal. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=IF(A2-B2&lt;0,0,A2-B2)<\/code><\/pre><h2 id=\"change-negative-numbers-into-a-zero-with-max-function\" class=\"wp-block-heading\"> Ubah angka negatif menjadi nol dengan fungsi MAX<\/h2><p> Anda juga dapat menggunakan fungsi MAX untuk mengubah angka negatif menjadi nol. Mari kita ambil contoh yang sama. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64147\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-changer-les-nombres-negatifs-en-zero.png\" sizes=\"auto, \" srcset=\"\" alt=\"ubah-angka-negatif-menjadi-nol\" width=\"401\" height=\"321\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=MAX(A2-B2,0)<\/code><\/pre><p> Dalam rumus di atas, Anda telah menggunakan fungsi max dimana satu argumen adalah rumus untuk mengurangkan A2 dari B2 dan argumen kedua adalah nol.<\/p><p> Mari kita pahami seperti ini, fungsi max mengembalikan nilai maksimum dari beberapa nilai. Jika hasil pengurangannya berupa bilangan positif maka akan menghasilkan bilangan tersebut, namun jika hasilnya negatif maka akan menghasilkan nol.<\/p><h2 id=\"show-a-zero-for-negative-number\" class=\"wp-block-heading\"> Tunjukkan angka nol untuk angka negatif<\/h2><p> Anda juga dapat menggunakan pemformatan khusus untuk menampilkan angka nol untuk angka negatif. Gunakan langkah-langkah di bawah ini untuk menerapkannya.<\/p><ol type=\"1\"><li> Pilih sel atau rentang sel.<\/li><li> Tekan tombol pintasan Control + 1 (Command +1 jika menggunakan Mac) untuk membuka kotak dialog Format Sel.<\/li><li> Klik pada opsi khusus dan masukkan 0; \u201c0\u201d; 0 di kotak masukan.<\/li><li> Klik OK untuk menerapkan pengaturan. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64148\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-zero-pour-les-nombres-negatifs.png\" sizes=\"auto, \" srcset=\"\" alt=\"nol untuk bilangan negatif\" width=\"535\" height=\"324\"><\/figure><\/div><p> Cara ini tidak akan mengubah nilai melainkan formatnya. Nilai aslinya akan tetap utuh. <\/p><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Dapatkan file Excelnya<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/si-negatif-alors-zero-2.xlsx\" rel=\"nofollow\">Unduh<\/a><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/rumus\/\">Daftar rumus Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Rumus terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/jika-nol-maka-kosong\/\">Centang IF 0 (nol) lalu kosongkan di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/periksa-apakah-ada-nilai-dalam-suatu-rentang\/\">Periksa apakah ada nilai dalam rentang di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jika-dan-1\/\">Gabungkan fungsi IF dan AND di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jika-atau-1\/\">Gabungkan fungsi IF dan OR di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jika-selnya-kosong\/\">IF Cell kosong (kosong) menggunakan IF + ISBLANK di Excel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1610","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Bagaimana cara menghilangkan nilai negatif di Excel?<\/title>\n<meta name=\"description\" content=\"Dalam tutorial rumus ini, kita akan mempelajari cara menggunakan fungsi IF untuk membuat rumus yang akan mengembalikan nol jika suatu nilai bernilai\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/jika-negatif-maka-nol\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menghilangkan nilai negatif di Excel?\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial rumus ini, kita akan mempelajari cara menggunakan fungsi IF untuk membuat rumus yang akan mengembalikan nol jika suatu nilai bernilai\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/jika-negatif-maka-nol\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:17:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-avec-des-valeurs-negatives.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-negatif-maka-nol\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/jika-negatif-maka-nol\/\",\"name\":\"Bagaimana cara menghilangkan nilai negatif di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-negatif-maka-nol\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-negatif-maka-nol\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-avec-des-valeurs-negatives.png\",\"datePublished\":\"2023-11-15T11:48:49+00:00\",\"dateModified\":\"2023-12-06T06:17:31+00:00\",\"description\":\"Dalam tutorial rumus ini, kita akan mempelajari cara menggunakan fungsi IF untuk membuat rumus yang akan mengembalikan nol jika suatu nilai bernilai\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-negatif-maka-nol\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/jika-negatif-maka-nol\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-negatif-maka-nol\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-avec-des-valeurs-negatives.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-avec-des-valeurs-negatives.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-negatif-maka-nol\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menghilangkan nilai negatif di excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bagaimana cara menghilangkan nilai negatif di Excel?","description":"Dalam tutorial rumus ini, kita akan mempelajari cara menggunakan fungsi IF untuk membuat rumus yang akan mengembalikan nol jika suatu nilai bernilai","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:\/\/exceladvisor.org\/id\/jika-negatif-maka-nol\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menghilangkan nilai negatif di Excel?","og_description":"Dalam tutorial rumus ini, kita akan mempelajari cara menggunakan fungsi IF untuk membuat rumus yang akan mengembalikan nol jika suatu nilai bernilai","og_url":"https:\/\/exceladvisor.org\/id\/jika-negatif-maka-nol\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:17:31+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-avec-des-valeurs-negatives.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/jika-negatif-maka-nol\/","url":"https:\/\/exceladvisor.org\/id\/jika-negatif-maka-nol\/","name":"Bagaimana cara menghilangkan nilai negatif di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/jika-negatif-maka-nol\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/jika-negatif-maka-nol\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-avec-des-valeurs-negatives.png","datePublished":"2023-11-15T11:48:49+00:00","dateModified":"2023-12-06T06:17:31+00:00","description":"Dalam tutorial rumus ini, kita akan mempelajari cara menggunakan fungsi IF untuk membuat rumus yang akan mengembalikan nol jika suatu nilai bernilai","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/jika-negatif-maka-nol\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/jika-negatif-maka-nol\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/jika-negatif-maka-nol\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-avec-des-valeurs-negatives.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-avec-des-valeurs-negatives.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/jika-negatif-maka-nol\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menghilangkan nilai negatif di excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1610","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1610"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1610\/revisions"}],"predecessor-version":[{"id":2607,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1610\/revisions\/2607"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1610"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}