{"id":1689,"date":"2023-11-11T12:21:14","date_gmt":"2023-11-11T12:21:14","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/mulai-dengan-2\/"},"modified":"2023-12-06T06:14:20","modified_gmt":"2023-12-06T06:14:20","slug":"mulai-dengan-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/mulai-dengan-2\/","title":{"rendered":"Bagaimana cara memeriksa apakah sel dimulai dengan teks?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3696894873\"><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>Di Excel, saat bekerja dengan data, mungkin ada saatnya Anda perlu memeriksa apakah nilai sel dimulai dengan teks tertentu atau apakah bagian awal dari nilai tersebut adalah angka atau bukan. Dalam tutorial ini, kita akan mempelajari cara menulis rumus untuk mengirim kedua kondisi tersebut.<\/p><h2 class=\"wp-block-heading\"> JIKA nilai sel dimulai dengan teks tertentu<\/h2><p> Dalam contoh berikut, Anda perlu memeriksa apakah tiga karakter pertama sel sama dengan LXI. Untuk ini, Anda perlu menggunakan IF dan LEFT. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80202\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-si-la-valeur-de-la-cellule-commence-par-un-texte-particulier.png\" sizes=\"auto, \" srcset=\"\" alt=\"jika-nilai-sel-dimulai-dengan-teks-tertentu\" width=\"437\" height=\"346\"><\/figure><\/div><p> Anda dapat menggunakan langkah-langkah di bawah ini untuk menulis rumus ini:<\/p><ol><li> Pertama, masukkan fungsi IF dalam sel.<\/li><li> Setelah itu masukkan fungsi LEFT pada argumen pertama IF dan rujuk ke sel A2 di mana Anda memiliki nilainya, pada argumen kedua gunakan 3 untuk angka_digitnya.<\/li><li> Selanjutnya, gunakan tanda sama dengan dan masukkan nilai (menggunakan tanda kutip ganda) yang ingin Anda uji.<\/li><li> Sekarang, di argumen kedua, masukkan \u201cYa\u201d.<\/li><li> Dan di argumen ketiga, masukkan \u201cTidak\u201d.<\/li><li> Terakhir, masukkan tanda kurung tutup 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=\"wp-image-80204\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-entrer-si-et-fonction-gauche.png\" sizes=\"auto, \" srcset=\"\" alt=\"fungsi masukkan-jika-dan-kiri\" width=\"641\" height=\"260\"><\/figure><\/div><p> Seperti yang Anda lihat di bawah, untuk semua nilai di mana kita memiliki nilai &#8220;LXI&#8221; di awal nilai, ia mengembalikan Ya, jika tidak, Tidak. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80206\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-le-resultat-sera-oui-ou-non.png\" sizes=\"auto, \" srcset=\"\" alt=\"hasilnya-akan-ya-atau-tidak\" width=\"601\" height=\"436\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=IF(LEFT(A2,3)=\"LXI\",\"Yes\",\"No\")<\/code><\/pre><h2 class=\"wp-block-heading\"> Hitung JIKA sel dimulai dengan<\/h2><p> Gunakan rumus di bawah ini jika Anda ingin menghitung jumlah sel yang dimulai dengan nilai tertentu. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80207\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-utiliser-sumproduct-pour-compter-le-resultat.png\" sizes=\"auto, \" srcset=\"\" alt=\"gunakan-jumlah-yang dihasilkan-untuk-menghitung-hasilnya\" width=\"558\" height=\"477\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMPRODUCT(--(LEFT(A2:A10,3)=\"LXI\"))<\/code><\/pre><p> Untuk mengetahui lebih lanjut mengenai hal ini, Anda dapat membaca tentang penggunaan SUMPRODUK dengan syarat.<\/p><h2 class=\"wp-block-heading\"> Jika nilai sel dimulai dengan angka<\/h2><p> Demikian pula, Anda bisa menulis rumus untuk memeriksa apakah sel dimulai dengan angka. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80208\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-formule-pour-savoir-si-la-valeur-de-la-cellule-commence-par-un-nombre.png\" sizes=\"auto, \" srcset=\"\" alt=\"rumus-untuk-menemukan-jika-nilai-sel-dimulai-dengan-angka\" width=\"556\" height=\"432\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=IF(ISNUMBER(VALUE(LEFT(A2,2))), \"Yes\",\"No\")<\/code><\/pre><p> Dalam rumus ini, kita telah menggunakan fungsi VALUE di sekitar LEFT. Saat Anda mendapatkan nilai menggunakan LEFT, ia mengembalikan nilai tersebut sebagai teks, meskipun nilai tersebut berupa angka.<\/p><p> Itu sebabnya untuk mengubah suatu angka menjadi angka kita perlu menggunakan VALUE. Setelah itu, kami menggunakan ISNUMBER untuk menguji nilai yang dikembalikan oleh LEFT. Jika nilai ini berupa angka, maka kondisinya TRUE dan IF mengembalikan YES, jika tidak, Tidak. <\/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\/08\/commence-avec.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\/jika-nomor-nilai-sel\/\">Periksa apakah nilai sel adalah 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-1689","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 memeriksa apakah sel dimulai dengan teks\/angka?<\/title>\n<meta name=\"description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk memeriksa apakah sel dimulai dengan teks atau angka tertentu.\" \/>\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\/mulai-dengan-2\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara memeriksa apakah sel dimulai dengan teks\/angka?\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk memeriksa apakah sel dimulai dengan teks atau angka tertentu.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/mulai-dengan-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:14:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-si-la-valeur-de-la-cellule-commence-par-un-texte-particulier.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\/mulai-dengan-2\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/mulai-dengan-2\/\",\"name\":\"Bagaimana cara memeriksa apakah sel dimulai dengan teks\/angka?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/mulai-dengan-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/mulai-dengan-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-si-la-valeur-de-la-cellule-commence-par-un-texte-particulier.png\",\"datePublished\":\"2023-11-11T12:21:14+00:00\",\"dateModified\":\"2023-12-06T06:14:20+00:00\",\"description\":\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk memeriksa apakah sel dimulai dengan teks atau angka tertentu.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/mulai-dengan-2\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/mulai-dengan-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/mulai-dengan-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-si-la-valeur-de-la-cellule-commence-par-un-texte-particulier.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-si-la-valeur-de-la-cellule-commence-par-un-texte-particulier.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/mulai-dengan-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara memeriksa apakah sel dimulai dengan teks?\"}]},{\"@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 memeriksa apakah sel dimulai dengan teks\/angka?","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk memeriksa apakah sel dimulai dengan teks atau angka tertentu.","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\/mulai-dengan-2\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara memeriksa apakah sel dimulai dengan teks\/angka?","og_description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk memeriksa apakah sel dimulai dengan teks atau angka tertentu.","og_url":"https:\/\/exceladvisor.org\/id\/mulai-dengan-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:14:20+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-si-la-valeur-de-la-cellule-commence-par-un-texte-particulier.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\/mulai-dengan-2\/","url":"https:\/\/exceladvisor.org\/id\/mulai-dengan-2\/","name":"Bagaimana cara memeriksa apakah sel dimulai dengan teks\/angka?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/mulai-dengan-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/mulai-dengan-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-si-la-valeur-de-la-cellule-commence-par-un-texte-particulier.png","datePublished":"2023-11-11T12:21:14+00:00","dateModified":"2023-12-06T06:14:20+00:00","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk memeriksa apakah sel dimulai dengan teks atau angka tertentu.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/mulai-dengan-2\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/mulai-dengan-2\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/mulai-dengan-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-si-la-valeur-de-la-cellule-commence-par-un-texte-particulier.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-si-la-valeur-de-la-cellule-commence-par-un-texte-particulier.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/mulai-dengan-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara memeriksa apakah sel dimulai dengan teks?"}]},{"@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\/1689","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=1689"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1689\/revisions"}],"predecessor-version":[{"id":2345,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1689\/revisions\/2345"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1689"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}