{"id":15512,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/izin\/"},"modified":"2021-02-25T16:30:42","modified_gmt":"2021-02-25T16:30:42","slug":"let","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/let\/","title":{"rendered":"\u0130zin"},"content":{"rendered":"

Excel ve Google E-Tablolar’da Form\u00fcllerle Verimlili\u011fi Art\u0131rmak<\/h2>\n

Microsoft Excel ve Google E-Tablolar, veri analizi ve i\u015fleme konusunda olduk\u00e7a g\u00fc\u00e7l\u00fc ara\u00e7lard\u0131r. Her iki platformda da kullan\u0131lan “LET” fonksiyonu, form\u00fcllerdeki tekrar eden hesaplamalar\u0131 sadele\u015ftirmek, form\u00fcllerin okunabilirli\u011fini art\u0131rmak ve hesaplama s\u00fcrecini h\u0131zland\u0131rmak i\u00e7in tasarlanm\u0131\u015ft\u0131r. Bu fonksiyon, kullan\u0131c\u0131lar\u0131n de\u011fi\u015fken tan\u0131mlamas\u0131na olanak tan\u0131yarak, daha temiz ve etkili form\u00fcller olu\u015fturmas\u0131n\u0131 sa\u011flar.<\/p>\n

LET Fonksiyonunun S\u00f6zdizimi ve \u00d6rnek Kullan\u0131mlar\u0131<\/h2>\n

LET fonksiyonunun temel s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n

LET(de\u011fi\u015fken1, de\u011fer1, [de\u011fi\u015fken2, de\u011fer2, ...], ifade)<\/code><\/pre>\n
    \n
  • de\u011fi\u015fken1, de\u011fi\u015fken2, ...<\/code> : Tan\u0131mlanacak de\u011fi\u015fkenlerin adlar\u0131d\u0131r.<\/li>\n
  • de\u011fer1, de\u011fer2, ...<\/code> : De\u011fi\u015fkenlere atanacak de\u011ferlerdir.<\/li>\n
  • ifade<\/code> : De\u011fi\u015fkenleri kullanarak hesaplanacak form\u00fcld\u00fcr.<\/li>\n<\/ul>\n
    \u00d6rnek:<\/p>\n
    =LET(x, 10, y, 20, x*y)<\/code><\/pre>\n
    Bu form\u00fcl, x i\u00e7in 10 ve y i\u00e7in 20 de\u011ferlerini tan\u0131mlar ve sonu\u00e7 olarak x ve y’nin \u00e7arp\u0131m\u0131n\u0131 (200) d\u00f6nd\u00fcr\u00fcr.<\/p>\n
    Pratik G\u00f6revler ve \u00c7\u00f6z\u00fcmleri<\/h2>\n
    G\u00f6rev 1: Ortalama Hesaplama<\/strong><\/p>\n
    \u00d6\u011frencilerin s\u0131nav sonu\u00e7lar\u0131na g\u00f6re s\u0131n\u0131f\u0131n genel performans\u0131n\u0131 de\u011ferlendirmek isteyin:<\/p>\n
    =LET(a1, 85, a2, 90, a3, 88, ort, (a1 + a2 + a3)\/3, ort)<\/code><\/pre>\n
    Bu form\u00fcl ile \u00fc\u00e7 \u00f6\u011frencinin s\u0131nav sonu\u00e7lar\u0131 tan\u0131mlanm\u0131\u015f ve s\u0131n\u0131f ortalamas\u0131 hesaplanm\u0131\u015ft\u0131r. Ortalama, de\u011fi\u015fken ‘ort’ i\u00e7inde saklan\u0131r ve sonu\u00e7 olarak bu de\u011fer d\u00f6nd\u00fcr\u00fcl\u00fcr.<\/p>\n
    G\u00f6rev 2: \u0130ndirimli Fiyat Hesaplama<\/strong><\/p>\n
    Bir ma\u011fazadaki \u00fcr\u00fcnlere \u00f6zel bir indirim uygulay\u0131n ve son fiyatlar\u0131 hesaplay\u0131n:<\/p>\n
    =LET(bazFiyat, 150, indirimOrani, 0.2, sonFiyat, bazFiyat - (bazFiyat * indirimOrani), sonFiyat)<\/code><\/pre>\n
    Bu form\u00fclde ‘bazFiyat’ olarak 150 de\u011feri ve ‘%20’ indirim olarak 0.2 de\u011feri atanm\u0131\u015ft\u0131r. ‘sonFiyat’ hesaplayarak, indirim uyguland\u0131ktan sonra \u00fcr\u00fcn\u00fcn son fiyat\u0131n\u0131 verir.<\/p>\n
    Bu \u00f6rneklerde LET fonksiyonu kullan\u0131larak, form\u00fcl i\u00e7erisinde tekrarlanan hesaplamalar\u0131n \u00f6n\u00fcne ge\u00e7ilmi\u015f ve hesaplama s\u00fcreci optimize edilmi\u015ftir. De\u011fi\u015fkenlerin kullan\u0131m\u0131, form\u00fcllerin anla\u015f\u0131labilirli\u011fini art\u0131r\u0131rken, hata yapma riskini de azaltabilir.<\/p>\n
    Uygulamalarda En \u0130yi Pratikler<\/h2>\n
    Fonksiyonun etkin kullan\u0131m\u0131 i\u00e7in baz\u0131 ipu\u00e7lar\u0131:<\/p>\n
      \n
    • De\u011fi\u015fken isimlerini anlaml\u0131 ve k\u0131sa tutun. Karma\u015f\u0131k form\u00fcllerde, hangi de\u011fi\u015fkenin neyi temsil etti\u011fi a\u00e7\u0131k\u00e7a anla\u015f\u0131lmal\u0131d\u0131r.<\/li>\n
    • \u00c7ok fazla de\u011fi\u015fken kullanmaktan ka\u00e7\u0131n\u0131n, bu form\u00fcllerin karma\u015f\u0131kl\u0131\u011f\u0131n\u0131 art\u0131rabilir.<\/li>\n
    • LET fonksiyonunu kullanarak, form\u00fcllerdeki hesaplaman\u0131n ne kadar h\u0131zland\u0131\u011f\u0131n\u0131 ve basitle\u015fti\u011fini g\u00f6zlemleyin.<\/li>\n<\/ul>\n
      LET fonksiyonunun sa\u011flad\u0131\u011f\u0131 yap\u0131sall\u0131k ve esneklik, Excel ve Google E-Tablolar i\u015flevselli\u011fini en \u00fcst d\u00fczeye \u00e7\u0131karmak i\u00e7in m\u00fckemmel ara\u00e7lard\u0131r. Form\u00fcllerinizde bu fonksiyonu kullanarak, daha verimli ve anla\u015f\u0131l\u0131r hesaplamalar yapabilirsiniz.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Bir form\u00fclde ara hesaplamalar\u0131, de\u011ferleri veya adlar\u0131 tan\u0131mlamay\u0131 sa\u011flamak i\u00e7in Hesaplama sonu\u00e7lar\u0131na adlar atar<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[577],"tags":[],"class_list":["post-15512","post","type-post","status-publish","format-standard","hentry","category-matematik-ve-trigonometri"],"acf":[],"yoast_head":"\nExcel'de LET (\u0130zin) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da LET (\u0130zin) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/tr\/let\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de LET (\u0130zin) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da LET (\u0130zin) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/tr\/let\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:30:42+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel'de LET (\u0130zin) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/let\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/let\/\",\"name\":\"Excel'de LET (\u0130zin) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:52+00:00\",\"dateModified\":\"2021-02-25T16:30:42+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da LET (\u0130zin) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/tr\/let\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/let\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/let\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Matematik ve trigonometri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/matematik-ve-trigonometri\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"\u0130zin\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel'de LET (\u0130zin) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da LET (\u0130zin) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","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:\/\/functiontranslator.com\/tr\/let\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de LET (\u0130zin) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da LET (\u0130zin) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","og_url":"https:\/\/functiontranslator.com\/tr\/let\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:30:42+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de LET (\u0130zin) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/let\/","url":"https:\/\/functiontranslator.com\/tr\/let\/","name":"Excel'de LET (\u0130zin) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:52+00:00","dateModified":"2021-02-25T16:30:42+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da LET (\u0130zin) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/tr\/let\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/let\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/let\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Matematik ve trigonometri","item":"https:\/\/functiontranslator.com\/tr\/matematik-ve-trigonometri\/"},{"@type":"ListItem","position":3,"name":"\u0130zin"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15512","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/comments?post=15512"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15512\/revisions"}],"predecessor-version":[{"id":26780,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15512\/revisions\/26780"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15512"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15512"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15512"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}