{"id":15273,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/bahtmetin\/"},"modified":"2021-02-25T16:22:34","modified_gmt":"2021-02-25T16:22:34","slug":"bahttext","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/bahttext\/","title":{"rendered":"BAHTMET\u0130N"},"content":{"rendered":"

Excel ve Google Sheets’te BAHTTEXT (BAHTMET\u0130N) Fonksiyonu<\/h2>\n

BAHTTEXT fonksiyonu, say\u0131sal de\u011ferleri Tay baht\u0131 cinsinden metin format\u0131na \u00e7evirmek i\u00e7in kullan\u0131l\u0131r. Bu fonksiyon, \u00f6zellikle finansal raporlama ve resmi dok\u00fcmanlarda, say\u0131lar\u0131 do\u011fru bir \u015fekilde metin olarak ifade etmek amac\u0131yla tercih edilir.<\/p>\n

Fonksiyonun S\u00f6zdizimi<\/h2>\n

BAHTTEXT fonksiyonunun genel s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n

=BAHTTEXT(say\u0131)<\/code><\/pre>\n
Bu form\u00fclde \u2018say\u0131\u2019 parametresi, baht cinsinden metne d\u00f6n\u00fc\u015ft\u00fcr\u00fclmek istenen say\u0131sal de\u011feri belirtir.<\/p>\n\n\n\n
Parametre<\/th>\nA\u00e7\u0131klama<\/th>\n<\/tr>\n
say\u0131<\/td>\nD\u00f6n\u00fc\u015ft\u00fcr\u00fclecek say\u0131sal de\u011ferdir ve pozitif veya negatif olabilir.<\/td>\n<\/tr>\n<\/table>\n
\u00d6rnek Kullan\u0131m:<\/strong><\/p>\n
=BAHTTEXT(123)<\/code> sonucunda \u2018y\u00fcz yirmi \u00fc\u00e7 baht\u2019 olarak d\u00f6necektir.<\/pre>\n
Pratik Kullan\u0131m Senaryolar\u0131<\/h2>\n
BAHTTEXT fonksiyonu, finansal belgelerin haz\u0131rlanmas\u0131 ve analiz i\u015flemlerinde s\u0131kl\u0131kla kullan\u0131lmaktad\u0131r. \u0130\u015fte bu fonksiyonun baz\u0131 pratik kullan\u0131m \u00f6rnekleri:<\/p>\n
Senaryo 1: Fatura Haz\u0131rlama<\/h3>\n
Bir \u00fcr\u00fcn listesinin fiyatlar\u0131n\u0131 baht cinsinden metne d\u00f6n\u00fc\u015ft\u00fcrerek fatura metni olu\u015fturabilirsiniz. \u00d6rne\u011fin:<\/p>\n
=BAHTTEXT(A2)<\/code><\/pre>\n
Burada A2 h\u00fccresi, fatura tutar\u0131n\u0131 i\u00e7ermekte ve bu de\u011fer, Tay baht\u0131 cinsinden metne d\u00f6n\u00fc\u015ft\u00fcr\u00fclmektedir.<\/p>\n
Senaryo 2: Finansal Raporlama<\/h3>\n
Bir i\u015fletmenin y\u0131ll\u0131k gelir raporunu Tay baht\u0131 cinsinden haz\u0131rlarken, her bir gelir kalemi i\u00e7in BAHTTEXT fonksiyonunu kullanabilirsiniz:<\/p>\n
=BAHTTEXT(B3)<\/code><\/pre>\n
Bu durumda B3 h\u00fccresi, y\u0131ll\u0131k gelir miktar\u0131n\u0131 g\u00f6sterir ve bu miktar, fonksiyon sayesinde Tay baht\u0131 olarak metin format\u0131na d\u00f6n\u00fc\u015ft\u00fcr\u00fcl\u00fcr.<\/p>\n
Detayl\u0131 \u00d6rneklerle Kullan\u0131m<\/h2>\n
    \n
  • \n
    \u00d6rnek 1:<\/strong> Fatura detay sayfas\u0131nda, her bir \u00fcr\u00fcn i\u00e7in \u00f6denen tutar\u0131 Tay baht\u0131 metin format\u0131na \u00e7evirmek:<\/p>\n
    C1 h\u00fccresinde \u2018\u00dcr\u00fcn Tutar\u0131\u2019 ba\u015fl\u0131\u011f\u0131 alt\u0131nda 650 yaz\u0131yor. Bu tutar\u0131 metne \u00e7evirmek i\u00e7in,<\/code> =BAHTTEXT(C1)<\/pre>\n
    fonksiyonu kullan\u0131l\u0131r ve \u2018alt\u0131 y\u00fcz elli baht\u2019 olarak geri d\u00f6ner.<\/p>\n<\/li>\n
  • \n
    \u00d6rnek 2:<\/strong> Bir gelir tablosunda, \u00e7e\u015fitli kalemlerin y\u0131ll\u0131k toplamlar\u0131n\u0131 Tay baht\u0131 cinsinden raporlamak i\u00e7in her bir h\u00fccreye ayr\u0131 ayr\u0131 fonksiyon uygulan\u0131r:<\/p>\n
    D5 h\u00fccresinde 2000 yaz\u0131yor. Metin format\u0131na d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in,<\/code> =BAHTTEXT(D5)<\/pre>\n
    fonksiyonu uygulan\u0131r ve \u2018iki bin baht\u2019 olarak sonu\u00e7 elde edilir.<\/p>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
    Say\u0131y\u0131, \u00df (baht) 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-15273","post","type-post","status-publish","format-standard","hentry","category-metin"],"acf":[],"yoast_head":"\nExcel'de BAHTTEXT (BAHTMET\u0130N) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da BAHTTEXT (BAHTMET\u0130N) 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\/bahttext\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de BAHTTEXT (BAHTMET\u0130N) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da BAHTTEXT (BAHTMET\u0130N) 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\/bahttext\/\" \/>\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:22:34+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 BAHTTEXT (BAHTMET\u0130N) 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\/bahttext\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/bahttext\/\",\"name\":\"Excel'de BAHTTEXT (BAHTMET\u0130N) 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:22:34+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da BAHTTEXT (BAHTMET\u0130N) 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\/bahttext\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/bahttext\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/bahttext\/#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\":\"BAHTMET\u0130N\"}]},{\"@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 BAHTTEXT (BAHTMET\u0130N) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da BAHTTEXT (BAHTMET\u0130N) 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\/bahttext\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de BAHTTEXT (BAHTMET\u0130N) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da BAHTTEXT (BAHTMET\u0130N) 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\/bahttext\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:22:34+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de BAHTTEXT (BAHTMET\u0130N) 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\/bahttext\/","url":"https:\/\/functiontranslator.com\/tr\/bahttext\/","name":"Excel'de BAHTTEXT (BAHTMET\u0130N) 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:22:34+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da BAHTTEXT (BAHTMET\u0130N) 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\/bahttext\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/bahttext\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/bahttext\/#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":"BAHTMET\u0130N"}]},{"@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\/15273","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=15273"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15273\/revisions"}],"predecessor-version":[{"id":26541,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15273\/revisions\/26541"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15273"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15273"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15273"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}