{"id":1691,"date":"2023-11-11T11:57:31","date_gmt":"2023-11-11T11:57:31","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/jika-nomor-nilai-sel\/"},"modified":"2023-12-06T06:14:18","modified_gmt":"2023-12-06T06:14:18","slug":"jika-nomor-nilai-sel","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/jika-nomor-nilai-sel\/","title":{"rendered":"Bagaimana cara memeriksa apakah nilai sel adalah angka?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2023229261\"><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>Untuk memeriksa apakah suatu nilai sel berupa angka atau bukan, Anda dapat menggunakan kombinasi IF + ISNUMBER. Dalam kombinasi ini ISNUMBER menguji apakah suatu nilai berupa angka atau bukan dan mengembalikan hasilnya sebagai TRUE dan FALSE. Setelah itu, IF menggunakan TRUE atau FALSE untuk mengembalikan nilai yang berarti pada hasilnya.<\/p><h2 class=\"wp-block-heading\"> Rumus untuk menguji JIKA nilai sel berupa angka<\/h2><p> Untuk menuliskan rumusnya, Anda dapat menggunakan langkah-langkah di bawah ini.<\/p><ol type=\"1\"><li> Pertama masukkan fungsi IF suatu sel.<\/li><li> Setelah itu, pada argumen pertama IF (logical_text), masukkan fungsi ISNUMBER.<\/li><li> Kemudian, dalam fungsi ESTNUM, rujuk ke sel tempat Anda ingin menguji nomor tersebut.<\/li><li> Sekarang, dalam argumen [value_if_true], masukkan Ya, dan dalam argumen [value_if_false], masukkan No. Anda juga dapat menggunakan nilai bermakna lainnya jika perlu.<\/li><li> Terakhir, masukkan tanda kurung penutup dan tekan Enter untuk mendapatkan hasilnya. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-13399\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/1-formule-pour-tester-la-valeur-de-la-cellule-est-un-nombre.png\" alt=\"1-rumus-untuk-menguji-nilai-sel-adalah-angka\" width=\"404\" height=\"267\" srcset=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/1-formule-pour-tester-la-valeur-de-la-cellule-est-un-nombre.png 724w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/1-formule-pour-tester-la-valeur-de-la-cellule-est-un-nombre-300x198.png 300w\" sizes=\"auto, (max-width: 404px) 100vw, 404px\"><\/figure><\/div><p> Saat Anda menekan Enter, ia mengembalikan YA atau TIDAK tergantung pada nilai yang Anda miliki di sel referensi.<\/p><h2 class=\"wp-block-heading\"> Bagaimana cara kerja rumus ini?<\/h2><p> Seperti yang saya katakan, dalam rumus ini kita memiliki dua fungsi, IF + ISNUM. Di sel A2 Anda memiliki nomor, itu sebabnya Anda memiliki hasil TRUE dengan ISNUMBER. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-13398\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/comment-cette-formule-fonctionnes.png\" alt=\"bagaimana cara kerja rumus ini\" width=\"592\" height=\"375\" srcset=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/comment-cette-formule-fonctionnes.png 919w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/comment-cette-formule-fonctionnes-300x190.png 300w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/comment-cette-formule-fonctionnes-768x487.png 768w\" sizes=\"auto, (max-width: 592px) 100vw, 592px\"><\/figure><\/div><p> Sekarang kita punya TRUE, itu sebabnya IF mengembalikan YES pada hasil nilai yang Anda miliki di sel A2.<\/p><pre class=\"wp-block-preformatted\"> =IF(ISNUMBER(A1),\"Yes\",\"No\")<\/pre><h2 class=\"wp-block-heading\"> Rumus yang sama di Mac<\/h2><p> Jika Anda menggunakan Excel untuk Mac, rumusnya akan sama dan bisa ditulis menggunakan fungsi yang sama. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-13397\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/meme-formule-dans-macs.png\" alt=\"formula yang sama di Mac\" width=\"588\" height=\"287\" srcset=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/meme-formule-dans-macs.png 1822w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/meme-formule-dans-macs-300x147.png 300w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/meme-formule-dans-macs-1024x500.png 1024w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/meme-formule-dans-macs-768x375.png 768w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/meme-formule-dans-macs-1536x750.png 1536w\" sizes=\"auto, (max-width: 588px) 100vw, 588px\"><\/figure><\/div><p class=\"grey-note\"> Excel menyimpan tanggal sebagai angka. Dan ketika Anda memiliki tanggal di dalam sel, ISNUMBER ini akan memperlakukan tanggal tersebut sebagai angka dan mengembalikan TRUE pada hasilnya. Saya mencoba mencari solusi untuk masalah ini, masih belum bisa membedakan angka dan tanggal menggunakan rumus ini. <\/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><p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/si-nombre.xlsx\" rel=\"nofollow\">Unduh<\/a><\/p><\/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-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/jika-sel-berisi-bagian\/\">Periksa apakah sel berisi sebagian teks<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/mulai-dengan-2\/\">Jika nilai sel dimulai dengan teks atau angka<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/median-jika-2\/\">Median dengan IF (Kriteria bersyarat)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menggabungkan-jika-2\/\">CONCATENATE IF (Gabungkan dengan Kondisi)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/subtotal-jika-2\/\">SUBTOTAL dengan IF (SUBTOTAL bersyarat)<\/a><\/li><\/ul><\/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-1691","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>Periksa apakah nilai sel adalah angka di Excel<\/title>\n<meta name=\"description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk memeriksa apakah nilai sel adalah angka. Mari kita periksa ini\u2026\" \/>\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-nomor-nilai-sel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Periksa apakah nilai sel adalah angka di Excel\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk memeriksa apakah nilai sel adalah angka. Mari kita periksa ini\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/jika-nomor-nilai-sel\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:14:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/1-formule-pour-tester-la-valeur-de-la-cellule-est-un-nombre.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-nomor-nilai-sel\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/jika-nomor-nilai-sel\/\",\"name\":\"Periksa apakah nilai sel adalah angka di Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-nomor-nilai-sel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-nomor-nilai-sel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/1-formule-pour-tester-la-valeur-de-la-cellule-est-un-nombre.png\",\"datePublished\":\"2023-11-11T11:57:31+00:00\",\"dateModified\":\"2023-12-06T06:14:18+00:00\",\"description\":\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk memeriksa apakah nilai sel adalah angka. Mari kita periksa ini\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-nomor-nilai-sel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/jika-nomor-nilai-sel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-nomor-nilai-sel\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/1-formule-pour-tester-la-valeur-de-la-cellule-est-un-nombre.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/1-formule-pour-tester-la-valeur-de-la-cellule-est-un-nombre.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-nomor-nilai-sel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara memeriksa apakah nilai sel adalah angka?\"}]},{\"@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":"Periksa apakah nilai sel adalah angka di Excel","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk memeriksa apakah nilai sel adalah angka. Mari kita periksa ini\u2026","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-nomor-nilai-sel\/","og_locale":"id_ID","og_type":"article","og_title":"Periksa apakah nilai sel adalah angka di Excel","og_description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk memeriksa apakah nilai sel adalah angka. Mari kita periksa ini\u2026","og_url":"https:\/\/exceladvisor.org\/id\/jika-nomor-nilai-sel\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:14:18+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/1-formule-pour-tester-la-valeur-de-la-cellule-est-un-nombre.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-nomor-nilai-sel\/","url":"https:\/\/exceladvisor.org\/id\/jika-nomor-nilai-sel\/","name":"Periksa apakah nilai sel adalah angka di Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/jika-nomor-nilai-sel\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/jika-nomor-nilai-sel\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/1-formule-pour-tester-la-valeur-de-la-cellule-est-un-nombre.png","datePublished":"2023-11-11T11:57:31+00:00","dateModified":"2023-12-06T06:14:18+00:00","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk memeriksa apakah nilai sel adalah angka. Mari kita periksa ini\u2026","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/jika-nomor-nilai-sel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/jika-nomor-nilai-sel\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/jika-nomor-nilai-sel\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/1-formule-pour-tester-la-valeur-de-la-cellule-est-un-nombre.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/1-formule-pour-tester-la-valeur-de-la-cellule-est-un-nombre.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/jika-nomor-nilai-sel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara memeriksa apakah nilai sel adalah angka?"}]},{"@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\/1691","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=1691"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1691\/revisions"}],"predecessor-version":[{"id":2343,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1691\/revisions\/2343"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1691"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}