{"id":4936,"date":"2023-07-06T05:14:09","date_gmt":"2023-07-06T05:14:09","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-jika-sel-berisi-angka-maka-kembalikan-nilai\/"},"modified":"2023-07-06T05:14:09","modified_gmt":"2023-07-06T05:14:09","slug":"excel-jika-sel-berisi-angka-maka-kembalikan-nilai","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-jika-sel-berisi-angka-maka-kembalikan-nilai\/","title":{"rendered":"Excel: jika sel berisi angka, mengembalikan nilainya"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus berikut di Excel untuk mengembalikan nilai tertentu jika sel berisi angka:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Rumus 1: Mengembalikan nilai jika sel berupa angka<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IF(ISNUMBER( <span style=\"color: #3366ff;\">A2<\/span> ), <span style=\"color: #3366ff;\">A2<\/span> , \"\")\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini memeriksa apakah sel <strong>A2<\/strong> adalah angka. Jika berupa angka, rumus akan mengembalikan angka di sel <strong>A2<\/strong> . Jika tidak, rumus akan mengembalikan kosong.<\/span><\/p>\n<p> <strong><span style=\"color: #000000;\"><span style=\"color: #000000;\">Rumus 2: Mengembalikan nilai jika sel berisi angka<\/span><\/span><\/strong><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IF(COUNT(FIND({0,1,2,3,4,5,6,7,8,9}, <span style=\"color: #3366ff;\">A2<\/span> ))&gt;0, <span style=\"color: #3366ff;\">A2<\/span> , \"\")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini memeriksa apakah sel <strong>A2<\/strong> berisi angka. Jika demikian, rumus akan mengembalikan seluruh isi sel <strong>A2<\/strong> . Jika tidak, rumus akan mengembalikan kosong.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan setiap rumus dalam praktik dengan daftar nilai berikut di Excel:<br \/><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38537 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cnum1.png\" alt=\"\" width=\"408\" height=\"366\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Mengembalikan nilai jika sel berupa angka<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>B2<\/strong> untuk mengembalikan nilai di sel <strong>A2<\/strong> hanya jika berupa angka:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IF(ISNUMBER( <span style=\"color: #3366ff;\">A2<\/span> ), <span style=\"color: #3366ff;\">A2<\/span> , \"\")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38538 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cnum2.png\" alt=\"\" width=\"459\" height=\"383\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jika nilai di kolom A adalah angka, maka kolom B mengembalikan angka tersebut.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika tidak, kolom B akan mengembalikan kosong.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa Anda juga dapat mengembalikan nilai lain jika Anda mau. Misalnya, Anda bisa menggunakan rumus berikut untuk mengembalikan &#8220;Ya&#8221; atau &#8220;Tidak&#8221; untuk menunjukkan apakah sel di kolom A adalah angka:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IF(ISNUMBER( <span style=\"color: #3366ff;\">A2<\/span> ), <span style=\"color: #000000;\">\"Yes\", \"No\")<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38539 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cnum4.png\" alt=\"\" width=\"497\" height=\"400\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom B sekarang menampilkan &#8220;Ya&#8221; atau &#8220;Tidak&#8221; untuk menunjukkan apakah sel terkait di kolom A adalah angka.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Mengembalikan nilai jika sel berisi angka<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>B2<\/strong> untuk mengembalikan nilai di sel <strong>A2<\/strong> hanya jika berisi angka:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IF(COUNT(FIND({0,1,2,3,4,5,6,7,8,9}, <span style=\"color: #3366ff;\">A2<\/span> ))&gt;0, <span style=\"color: #3366ff;\">A2<\/span> , \"\")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38540 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cnum3.png\" alt=\"\" width=\"593\" height=\"372\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jika nilai di kolom A berisi angka, kolom B mengembalikan seluruh isi sel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika tidak, kolom B akan mengembalikan kosong.<\/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 Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/excel-memeriksa-apakah-sel-berisi-salah-satu-dari-beberapa-nilai\/\" target=\"_blank\" rel=\"noopener\">Excel: periksa apakah sel berisi salah satu dari beberapa nilai<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tanggal-verifikasi-excel\/\" target=\"_blank\" rel=\"noopener\">Excel: Periksa apakah sel berisi tanggal<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rata-rata-excel-jika-sel-berisi-teks\/\" target=\"_blank\" rel=\"noopener\">Excel: hitung rata-rata jika sel berisi teks<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus berikut di Excel untuk mengembalikan nilai tertentu jika sel berisi angka: Rumus 1: Mengembalikan nilai jika sel berupa angka =IF(ISNUMBER( A2 ), A2 , &#8220;&#8221;) Rumus khusus ini memeriksa apakah sel A2 adalah angka. Jika berupa angka, rumus akan mengembalikan angka di sel A2 . Jika tidak, rumus akan mengembalikan kosong. [&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: jika sel berisi angka, maka mengembalikan nilainya \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengembalikan nilai di Excel jika sel berisi angka, beserta contohnya.\" \/>\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-jika-sel-berisi-angka-maka-kembalikan-nilai\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: jika sel berisi angka, maka mengembalikan nilainya \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengembalikan nilai di Excel jika sel berisi angka, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-jika-sel-berisi-angka-maka-kembalikan-nilai\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-06T05:14:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cnum1.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-jika-sel-berisi-angka-maka-kembalikan-nilai\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-jika-sel-berisi-angka-maka-kembalikan-nilai\/\",\"name\":\"Excel: jika sel berisi angka, maka mengembalikan nilainya \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-06T05:14:09+00:00\",\"dateModified\":\"2023-07-06T05:14:09+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengembalikan nilai di Excel jika sel berisi angka, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-jika-sel-berisi-angka-maka-kembalikan-nilai\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-jika-sel-berisi-angka-maka-kembalikan-nilai\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-jika-sel-berisi-angka-maka-kembalikan-nilai\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: jika sel berisi angka, mengembalikan nilainya\"}]},{\"@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: jika sel berisi angka, maka mengembalikan nilainya \u2013 Statorials","description":"Tutorial ini menjelaskan cara mengembalikan nilai di Excel jika sel berisi angka, beserta contohnya.","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-jika-sel-berisi-angka-maka-kembalikan-nilai\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: jika sel berisi angka, maka mengembalikan nilainya \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara mengembalikan nilai di Excel jika sel berisi angka, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/excel-jika-sel-berisi-angka-maka-kembalikan-nilai\/","og_site_name":"Statorials","article_published_time":"2023-07-06T05:14:09+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cnum1.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-jika-sel-berisi-angka-maka-kembalikan-nilai\/","url":"https:\/\/statorials.org\/id\/excel-jika-sel-berisi-angka-maka-kembalikan-nilai\/","name":"Excel: jika sel berisi angka, maka mengembalikan nilainya \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-06T05:14:09+00:00","dateModified":"2023-07-06T05:14:09+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengembalikan nilai di Excel jika sel berisi angka, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-jika-sel-berisi-angka-maka-kembalikan-nilai\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-jika-sel-berisi-angka-maka-kembalikan-nilai\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-jika-sel-berisi-angka-maka-kembalikan-nilai\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: jika sel berisi angka, mengembalikan nilainya"}]},{"@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\/4936"}],"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=4936"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4936\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4936"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4936"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4936"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}