{"id":4896,"date":"2023-07-06T17:18:53","date_gmt":"2023-07-06T17:18:53","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-jika-angka-negatif-berfungsi\/"},"modified":"2023-07-06T17:18:53","modified_gmt":"2023-07-06T17:18:53","slug":"google-sheet-jika-angka-negatif-berfungsi","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-jika-angka-negatif-berfungsi\/","title":{"rendered":"Google sheets: cara menggunakan fungsi if dengan angka negatif"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan rumus berikut untuk menggunakan fungsi IF dengan angka negatif di Google Spreadsheet:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Gunakan fungsi IF untuk memeriksa apakah sel berisi angka negatif<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IF( <span style=\"color: #ff6600;\">B2<\/span> &lt; <span style=\"color: #3366ff;\">0<\/span> , \u201c <span style=\"color: #008000;\">Yes<\/span> \u201d, \u201c <span style=\"color: #008000;\">No<\/span> \u201d)<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus ini akan mengembalikan \u201cYa\u201d jika nilai di sel <strong>B2<\/strong> negatif (yaitu kurang dari nol) \u2013 jika tidak maka akan menghasilkan \u201cTidak\u201d.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Gunakan fungsi IF untuk memeriksa apakah selnya negatif, nol, atau positif<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IF( <span style=\"color: #ff6600;\">B2<\/span> = <span style=\"color: #3366ff;\">0<\/span> ,\" <span style=\"color: #008000;\">Zero<\/span> \",IF( <span style=\"color: #ff6600;\">B2<\/span> &gt; <span style=\"color: #3366ff;\">0<\/span> ,\" <span style=\"color: #008000;\">Positive<\/span> \", \" <span style=\"color: #008000;\">Negative<\/span> \"))\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus ini akan mengembalikan nilai berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">\u201cNol\u201d jika sel <strong>B2<\/strong> adalah nol.<\/span><\/li>\n<li> <span style=\"color: #000000;\">\u201cPositif\u201d jika sel <strong>B2<\/strong> bernilai positif.<\/span><\/li>\n<li> <span style=\"color: #000000;\">\u201cNegatif\u201d jika sel <strong>B2<\/strong> bernilai negatif.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap rumus dalam praktik dengan kumpulan data berikut di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38237 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ifn1.png\" alt=\"\" width=\"472\" height=\"379\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Gunakan fungsi IF untuk memeriksa apakah sel berisi angka negatif<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>C2<\/strong> untuk mengembalikan &#8220;Ya&#8221; jika nilai di sel <strong>B2<\/strong> negatif atau mengembalikan &#8220;Tidak&#8221; jika tidak:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IF( <span style=\"color: #ff6600;\">B2<\/span> &lt; <span style=\"color: #3366ff;\">0<\/span> , \u201c <span style=\"color: #008000;\">Yes<\/span> \u201d, \u201c <span style=\"color: #008000;\">No<\/span> \u201d)<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom C:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-38238\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ifn2.png\" alt=\"Fungsi Google Sheets IF dengan angka negatif\" width=\"513\" height=\"399\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya mengembalikan &#8220;Ya&#8221; untuk setiap baris yang nilai dalam kolom Penjualan Bersihnya negatif dan &#8220;Tidak&#8221; untuk setiap baris yang nilainya positif.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Gunakan fungsi IF untuk memeriksa apakah selnya negatif, nol, atau positif<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>C2<\/strong> untuk mengembalikan &#8220;Nol&#8221;, &#8220;Negatif&#8221; atau &#8220;Positif&#8221; bergantung pada nilai di sel <strong>A2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IF( <span style=\"color: #ff6600;\">B2<\/span> = <span style=\"color: #3366ff;\">0<\/span> ,\" <span style=\"color: #008000;\">Zero<\/span> \",IF( <span style=\"color: #ff6600;\">B2<\/span> &gt; <span style=\"color: #3366ff;\">0<\/span> ,\" <span style=\"color: #008000;\">Positive<\/span> \", \" <span style=\"color: #008000;\">Negative<\/span> \"))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom C:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38239 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ifn3.png\" alt=\"\" width=\"536\" height=\"427\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya mengembalikan &#8220;Nol&#8221;, &#8220;Negatif&#8221; atau &#8220;Positif&#8221; bergantung pada nilai terkait di kolom A.<\/span><\/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 tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/google-sheet-jika-berfungsi-dengan-tanggal\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: Gunakan Fungsi IF dengan Tanggal<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-jika-rentang-fungsi-nilai\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: Gunakan Fungsi IF dengan Rentang Nilai<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-jika-berfungsi-dengan-3-kondisi\/\" target=\"_blank\" rel=\"noopener\">Google Sheets: menggunakan fungsi IF dengan 3 kondisi<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan rumus berikut untuk menggunakan fungsi IF dengan angka negatif di Google Spreadsheet: Metode 1: Gunakan fungsi IF untuk memeriksa apakah sel berisi angka negatif =IF( B2 &lt; 0 , \u201c Yes \u201d, \u201c No \u201d) Rumus ini akan mengembalikan \u201cYa\u201d jika nilai di sel B2 negatif (yaitu kurang dari nol) \u2013 jika [&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>Google Sheets: Cara menggunakan fungsi IF dengan angka negatif - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi IF dengan angka negatif di Google Sheets, beserta sebuah 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\/google-sheet-jika-angka-negatif-berfungsi\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Sheets: Cara menggunakan fungsi IF dengan angka negatif - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi IF dengan angka negatif di Google Sheets, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-jika-angka-negatif-berfungsi\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-06T17:18:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ifn1.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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-jika-angka-negatif-berfungsi\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-jika-angka-negatif-berfungsi\/\",\"name\":\"Google Sheets: Cara menggunakan fungsi IF dengan angka negatif - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-06T17:18:53+00:00\",\"dateModified\":\"2023-07-06T17:18:53+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi IF dengan angka negatif di Google Sheets, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-jika-angka-negatif-berfungsi\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-jika-angka-negatif-berfungsi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-jika-angka-negatif-berfungsi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google sheets: cara menggunakan fungsi if dengan angka negatif\"}]},{\"@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":"Google Sheets: Cara menggunakan fungsi IF dengan angka negatif - Statorials","description":"Tutorial ini menjelaskan cara menggunakan fungsi IF dengan angka negatif di Google Sheets, beserta sebuah 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\/google-sheet-jika-angka-negatif-berfungsi\/","og_locale":"id_ID","og_type":"article","og_title":"Google Sheets: Cara menggunakan fungsi IF dengan angka negatif - Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi IF dengan angka negatif di Google Sheets, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/google-sheet-jika-angka-negatif-berfungsi\/","og_site_name":"Statorials","article_published_time":"2023-07-06T17:18:53+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ifn1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/google-sheet-jika-angka-negatif-berfungsi\/","url":"https:\/\/statorials.org\/id\/google-sheet-jika-angka-negatif-berfungsi\/","name":"Google Sheets: Cara menggunakan fungsi IF dengan angka negatif - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-06T17:18:53+00:00","dateModified":"2023-07-06T17:18:53+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi IF dengan angka negatif di Google Sheets, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-jika-angka-negatif-berfungsi\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-jika-angka-negatif-berfungsi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-jika-angka-negatif-berfungsi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google sheets: cara menggunakan fungsi if dengan angka negatif"}]},{"@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\/4896"}],"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=4896"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4896\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4896"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4896"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4896"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}