{"id":15619,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/romen\/"},"modified":"2021-02-25T16:34:56","modified_gmt":"2021-02-25T16:34:56","slug":"roman","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/roman\/","title":{"rendered":"ROMEN"},"content":{"rendered":"

Excel ve Google Sheets, veri analizi ve hesaplama alanlar\u0131nda m\u00fckemmel ara\u00e7lard\u0131r. Bu makalede, hem Microsoft Excel hem de Google Sheets’te kullan\u0131labilen “ROMAN” (T\u00fcrk\u00e7e versiyonunda “ROMEN”) fonksiyonunun kullan\u0131m\u0131n\u0131 ele alaca\u011f\u0131z. “ROMAN” fonksiyonu, belirtti\u011finiz say\u0131y\u0131 Roma rakam\u0131na \u00e7eviren bir i\u015flevdir. Bu i\u015flev finansal raporlamadan \u00f6\u011frenci projelerine kadar bir\u00e7ok alanda i\u015fe yarar.<\/p>\n

Romen Say\u0131lar\u0131na D\u00f6n\u00fc\u015ft\u00fcrme S\u00f6zdizimi<\/h2>\n

ROMAN<\/code> (Excel’de) veya ROMEN<\/code> (Google Sheets’te) fonksiyonunun s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n

ROMAN(number, [form]) ROMEN(say\u0131, [bi\u00e7im])<\/code><\/pre>\n
    \n
  • number (say\u0131)<\/strong>: Roma rakam\u0131na d\u00f6n\u00fc\u015ft\u00fcr\u00fclecek say\u0131.<\/li>\n
  • [form] ([bi\u00e7im])<\/strong>: \u0130ste\u011fe ba\u011fl\u0131 bir parametre olup, say\u0131n\u0131n d\u00f6n\u00fc\u015f\u00fcm \u015feklini belirler. 0 en detayl\u0131 (klasik) d\u00f6n\u00fc\u015f\u00fcm\u00fc sa\u011flarken, 4 daha \u00f6zet bir d\u00f6n\u00fc\u015f\u00fcm sa\u011flar.<\/li>\n<\/ul>\n
    \u0130\u015fte baz\u0131 \u00f6rnek kullan\u0131mlar:<\/p>\n\n\n\n\n\n
    Fonksiyon \u00c7a\u011fr\u0131s\u0131<\/th>\nSonu\u00e7<\/th>\nA\u00e7\u0131klama<\/th>\n<\/tr>\n
    ROMAN(1024)<\/code><\/td>\nMXXIV<\/td>\n1024 say\u0131s\u0131n\u0131n Roma rakam\u0131 kar\u015f\u0131l\u0131\u011f\u0131<\/td>\n<\/tr>\n
    ROMAN(1024, 0)<\/code><\/td>\nMXXIV<\/td>\nEn ayr\u0131nt\u0131l\u0131 d\u00f6n\u00fc\u015f\u00fcm ile 1024 say\u0131s\u0131n\u0131n Roma rakam\u0131 kar\u015f\u0131l\u0131\u011f\u0131<\/td>\n<\/tr>\n
    ROMAN(1024, 4)<\/code><\/td>\nMXXIV<\/td>\nEn \u00f6zet d\u00f6n\u00fc\u015f\u00fcm ile 1024 say\u0131s\u0131n\u0131n Roma rakam\u0131 kar\u015f\u0131l\u0131\u011f\u0131<\/td>\n<\/tr>\n<\/table>\n
    Pratik Kullan\u0131m \u00d6rnekleri<\/h2>\n
    Durum 1: Bir Y\u0131l\u0131n Roma Rakamlar\u0131yla G\u00f6sterimi<\/strong><\/p>\n
    \u00d6rne\u011fin, tarih \u00e7al\u0131\u015fmalar\u0131nda veya bir eserin telif hakk\u0131 tarihi gibi \u00f6zel durumlarda y\u0131llar Roma rakamlar\u0131yla ifade edilmek istenebilir. 1954 y\u0131l\u0131n\u0131 Roma rakamlar\u0131 ile yazd\u0131ral\u0131m:<\/p>\n
    =ROMAN(1954)<\/code><\/pre>\n
    Bu form\u00fcl sonucunda elde edilen MCMLIV<\/strong> de\u011feri, y\u0131l\u0131 estetik bir \u015fekilde ifade eder.<\/p>\n
    Durum 2: Bir S\u00fctunda Yer Alan Y\u0131llar\u0131n Roma Rakamlar\u0131na D\u00f6n\u00fc\u015ft\u00fcr\u00fclmesi<\/strong><\/p>\n
    \u00d6rne\u011fin, bir veri tablosunun A s\u00fctunu 1900’den 1905’e kadar olan y\u0131llar\u0131 i\u00e7ersin. B s\u00fctununda a\u015fa\u011f\u0131daki form\u00fcl\u00fc uygulayarak bu y\u0131llar\u0131 Roma rakamlar\u0131na \u00e7evirebiliriz:<\/p>\n
    =ROMAN(A1)<\/code><\/pre>\n
    Bu form\u00fcl\u00fc B s\u00fctunundaki di\u011fer h\u00fccrelere kopyalayarak i\u015flemi tamamlay\u0131n:<\/p>\n\n\n\n\n\n
    A S\u00fctunu<\/th>\nB S\u00fctunu<\/th>\n<\/tr>\n
    1900<\/td>\nMCM<\/td>\n<\/tr>\n
    1901<\/td>\nMCMI<\/td>\n<\/tr>\n
    1902<\/td>\nMCMII<\/td>\n<\/tr>\n<\/table>\n
    Yorum:<\/strong> Bu y\u00f6ntem sayesinde, tablodaki t\u00fcm y\u0131llar kolayl\u0131kla ve estetik bir \u015fekilde Roma rakamlar\u0131na d\u00f6n\u00fc\u015ft\u00fcr\u00fcl\u00fcr ki bu, raporlama ve g\u00f6rsel sunumlar i\u00e7in b\u00fcy\u00fck fayda sa\u011flar.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Arap rakamlar\u0131n\u0131 metin bi\u00e7imiyle Romen rakamlar\u0131na \u00e7evirir<\/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-15619","post","type-post","status-publish","format-standard","hentry","category-matematik-ve-trigonometri"],"acf":[],"yoast_head":"\nExcel'de ROMAN (ROMEN) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da ROMAN (ROMEN) 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\/roman\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de ROMAN (ROMEN) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da ROMAN (ROMEN) 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\/roman\/\" \/>\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:34:56+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 ROMAN (ROMEN) 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\/roman\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/roman\/\",\"name\":\"Excel'de ROMAN (ROMEN) 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:34:56+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da ROMAN (ROMEN) 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\/roman\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/roman\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/roman\/#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\":\"ROMEN\"}]},{\"@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 ROMAN (ROMEN) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da ROMAN (ROMEN) 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\/roman\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de ROMAN (ROMEN) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da ROMAN (ROMEN) 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\/roman\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:34:56+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de ROMAN (ROMEN) 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\/roman\/","url":"https:\/\/functiontranslator.com\/tr\/roman\/","name":"Excel'de ROMAN (ROMEN) 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:34:56+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da ROMAN (ROMEN) 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\/roman\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/roman\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/roman\/#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":"ROMEN"}]},{"@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\/15619","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=15619"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15619\/revisions"}],"predecessor-version":[{"id":26887,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15619\/revisions\/26887"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15619"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15619"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15619"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}