{"id":15377,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/lira\/"},"modified":"2021-02-25T16:25:58","modified_gmt":"2021-02-25T16:25:58","slug":"dollar","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/dollar\/","title":{"rendered":"L\u0130RA"},"content":{"rendered":"<p>Microsoft Excel ve Google Sheets, finansal analizler, muhasebe i\u015fleri ve b\u00fct\u00e7e planlamalar\u0131 gibi \u00e7ok \u00e7e\u015fitli alanlarda kullan\u0131lan g\u00fc\u00e7l\u00fc ara\u00e7lard\u0131r. Bu platformlarda bulunan fonksiyonlar, veri i\u015fleme ve analiz i\u015flemlerini kolayla\u015ft\u0131rmakta b\u00fcy\u00fck bir rol oynar. Bu yaz\u0131m\u0131zda, Excel ve Google Sheets&#8217;teki &#8220;DOLLAR&#8221; fonksiyonunun kullan\u0131m\u0131n\u0131 ve bu fonksiyonun sundu\u011fu faydal\u0131 \u00f6zellikleri inceleyece\u011fiz. MS Excel&#8217;de bu fonksiyon &#8220;DOLLAR&#8221; ad\u0131yla an\u0131l\u0131rken, Google Sheets&#8217;te &#8220;TO_TEXT&#8221; olarak benzer bir i\u015flev g\u00f6r\u00fcr. Bu yaz\u0131da daha \u00e7ok &#8220;DOLLAR&#8221; fonksiyonuna odaklanaca\u011f\u0131z.<\/p>\n<h2>Fonksiyonun S\u00f6zdizimi ve \u00d6rnekler<\/h2>\n<p><code>DOLLAR(say\u0131, basamaklar)<\/code> fonksiyonunun s\u00f6zdizimi iki ana parametre i\u00e7erir:<\/p>\n<ul>\n<li><strong>say\u0131:<\/strong> Dolar format\u0131na d\u00f6n\u00fc\u015ft\u00fcr\u00fclecek say\u0131sal de\u011fer.<\/li>\n<li><strong>basamaklar:<\/strong> Ondal\u0131k k\u0131s\u0131m i\u00e7in yuvarlama yap\u0131lacak basamak say\u0131s\u0131n\u0131 belirtir. E\u011fer bu de\u011fer belirtilmezse, varsay\u0131lan olarak 2 basamak kullan\u0131l\u0131r.<\/li>\n<\/ul>\n<pre> <code>=DOLLAR(1234.567) \/\/ \u00c7\u0131kt\u0131: \"$1,234.57\"<\/code> <code>=DOLLAR(1234.567, 1) \/\/ \u00c7\u0131kt\u0131: \"$1,234.6\"<\/code> <code>=DOLLAR(-1234.567, -1) \/\/ \u00c7\u0131kt\u0131: \"-$1,230\"<\/code> <code>=DOLLAR(1234.567, 0) \/\/ \u00c7\u0131kt\u0131: \"$1,235\"<\/code> <\/pre>\n<h2>Baz\u0131 Pratik Uygulamalar<\/h2>\n<p>\u015eimdi &#8220;DOLLAR&#8221; fonksiyonunun pratik kullan\u0131m\u0131na y\u00f6nelik baz\u0131 \u00f6rnekleri detayl\u0131 bir \u015fekilde inceleyece\u011fiz.<\/p>\n<h2>\u00d6rnek 1: Gelir Tablosu Haz\u0131rlama<\/h2>\n<p>\u015eirketiniz i\u00e7in ayl\u0131k gelirlerinizi dolar format\u0131nda d\u00fczenlemek ve sunmak zorundas\u0131n\u0131z. Her bir gelir rakam\u0131n\u0131 dolar format\u0131nda g\u00f6stererek ve toplam geliri hesaplayarak &#8220;DOLLAR&#8221; fonksiyonunu kullanabilirsiniz.<\/p>\n<pre><code><table> <tr> <th>Ay<\/th> <th>Gelir<\/th> <th>Formatl\u0131 Gelir<\/th> <\/tr> <tr> <td>Ocak<\/td> <td>5000<\/td> <td>=DOLLAR(B2, 0)<\/td> <\/tr> <tr> <td>\u015eubat<\/td> <td>5800<\/td> <td>=DOLLAR(B3, 0)<\/td> <\/tr> <tr> <td>Mart<\/td> <td>6200<\/td> <td>=DOLLAR(B4, 0)<\/td> <\/tr> <\/table><\/code><\/pre>\n<h2>\u00d6rnek 2: B\u00fct\u00e7e Planlamas\u0131 ve G\u00f6rselle\u015ftirme<\/h2>\n<p>Projelerin b\u00fct\u00e7elerini planlarken tahmini maliyetleri dolar format\u0131nda belirtmek \u00f6nemlidir. A\u015fa\u011f\u0131daki \u00f6rnekte &#8220;DOLLAR&#8221; fonksiyonunu kullanarak b\u00fct\u00e7e kalemlerini dolar format\u0131nda listeleyebilirsiniz.<\/p>\n<pre><code><table> <tr> <th>Kalem<\/th> <th>Maliyet<\/th> <th>Formatl\u0131 Maliyet<\/th> <\/tr> <tr> <td>Personel<\/td> <td>15000<\/td> <td>=DOLLAR(B2)<\/td> <\/tr> <tr> <td>Yaz\u0131l\u0131m<\/td> <td>2300<\/td> <td>=DOLLAR(B3)<\/td> <\/tr> <tr> <td>Donan\u0131m<\/td> <td>4500<\/td> <td>=DOLLAR(B4)<\/td> <\/tr> <\/table><\/code><\/pre>\n<p>Bu fonksiyon, hem MS Excel hem de Google Sheets&#8217;te mali verilerin g\u00f6sterimi ve raporlamas\u0131nda kullan\u0131c\u0131lara kolayl\u0131k sa\u011flar. Her iki tablo \u00f6rne\u011finde de g\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi, &#8220;DOLLAR&#8221; fonksiyonu sayesinde say\u0131sal de\u011ferleri daha d\u00fczenli ve anla\u015f\u0131l\u0131r bir bi\u00e7imde sunabilirsiniz.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bir say\u0131y\u0131 TL (T\u00fcrk Liras\u0131) para birimi bi\u00e7imini kullanarak metne d\u00f6n\u00fc\u015ft\u00fcr\u00fcr<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[581],"tags":[],"class_list":["post-15377","post","type-post","status-publish","format-standard","hentry","category-metin"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de DOLLAR (L\u0130RA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da DOLLAR (L\u0130RA) 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\/dollar\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de DOLLAR (L\u0130RA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da DOLLAR (L\u0130RA) 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\/dollar\/\" \/>\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:25:58+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel&#039;de DOLLAR (L\u0130RA) 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\/dollar\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/dollar\/\",\"name\":\"Excel'de DOLLAR (L\u0130RA) 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:25:58+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da DOLLAR (L\u0130RA) 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\/dollar\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/dollar\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/dollar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Metin\",\"item\":\"https:\/\/functiontranslator.com\/tr\/metin\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"L\u0130RA\"}]},{\"@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 DOLLAR (L\u0130RA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da DOLLAR (L\u0130RA) 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\/dollar\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de DOLLAR (L\u0130RA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da DOLLAR (L\u0130RA) 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\/dollar\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:25:58+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de DOLLAR (L\u0130RA) 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\/dollar\/","url":"https:\/\/functiontranslator.com\/tr\/dollar\/","name":"Excel'de DOLLAR (L\u0130RA) 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:25:58+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da DOLLAR (L\u0130RA) 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\/dollar\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/dollar\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/dollar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Metin","item":"https:\/\/functiontranslator.com\/tr\/metin\/"},{"@type":"ListItem","position":3,"name":"L\u0130RA"}]},{"@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\/15377","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=15377"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15377\/revisions"}],"predecessor-version":[{"id":26645,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15377\/revisions\/26645"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15377"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15377"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15377"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}