{"id":15632,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/sirali\/"},"modified":"2021-02-25T16:35:42","modified_gmt":"2021-02-25T16:35:42","slug":"sequence","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/sequence\/","title":{"rendered":"SIRALI"},"content":{"rendered":"<p><b>SEQUENCE (SIRALI)<\/b> fonksiyonu, belirli bir say\u0131da ard\u0131\u015f\u0131k say\u0131lardan olu\u015fan diziler olu\u015fturmak amac\u0131yla hem Microsoft Excel hem de Google Sheets&#8217;te yer al\u0131r. Bu fonksiyon, matematiksel ve istatistiksel tablo haz\u0131rlama gibi \u00e7e\u015fitli senaryolarda olduk\u00e7a \u00f6nemlidir.<\/p>\n<h2>Syntax ve Parametreler<\/h2>\n<p><code>SIRALI(sat\u0131r_say\u0131s\u0131, [s\u00fctun_say\u0131s\u0131], [ba\u015flang\u0131\u00e7], [art\u0131\u015f])<\/code><\/p>\n<ul>\n<li><b>sat\u0131r_say\u0131s\u0131:<\/b> Olu\u015fturulacak dizi i\u00e7indeki sat\u0131r say\u0131s\u0131d\u0131r ve bu parametre zorunludur.<\/li>\n<li><b>s\u00fctun_say\u0131s\u0131:<\/b> Her bir sat\u0131rda bulunacak s\u00fctun say\u0131s\u0131d\u0131r ve bu parametre iste\u011fe ba\u011fl\u0131d\u0131r; varsay\u0131lan de\u011feri 1&#8217;dir.<\/li>\n<li><b>ba\u015flang\u0131\u00e7:<\/b> Dizi elemanlar\u0131n\u0131n ba\u015flayaca\u011f\u0131 de\u011ferdir ve bu parametre iste\u011fe ba\u011fl\u0131d\u0131r; varsay\u0131lan de\u011feri 1&#8217;dir.<\/li>\n<li><b>art\u0131\u015f:<\/b> Dizi elemanlar\u0131 aras\u0131ndaki art\u0131\u015f miktar\u0131n\u0131 belirler ve bu parametre iste\u011fe ba\u011fl\u0131d\u0131r; varsay\u0131lan de\u011feri 1&#8217;dir.<\/li>\n<\/ul>\n<p><b>\u00d6rnek:<\/b> <\/p>\n<pre><code>=SEQUENCE(4, 3, 5, 2)<\/code><\/pre>\n<\/p>\n<p>Bu \u00f6rnekte, 5&#8217;ten ba\u015flayarak her yeni eleman bir \u00f6ncekine g\u00f6re 2 birim artarak 4 sat\u0131r ve 3 s\u00fctundan olu\u015fan bir dizi olu\u015fturulmu\u015ftur.<\/p>\n<table>\n<tr>\n<td>5<\/td>\n<td>7<\/td>\n<td>9<\/td>\n<\/tr>\n<tr>\n<td>11<\/td>\n<td>13<\/td>\n<td>15<\/td>\n<\/tr>\n<tr>\n<td>17<\/td>\n<td>19<\/td>\n<td>21<\/td>\n<\/tr>\n<tr>\n<td>23<\/td>\n<td>25<\/td>\n<td>27<\/td>\n<\/tr>\n<\/table>\n<h2>Kullan\u0131m Senaryolar\u0131 ve \u00c7\u00f6z\u00fcmler<\/h2>\n<p>SEQUENCE Fonksiyonun Kullan\u0131labilece\u011fi Senaryolar:<\/p>\n<h2>1. Takvim Olu\u015fturma<\/h2>\n<p>Bir ay i\u00e7in tarihleri s\u0131rayla listelemek i\u00e7in SEQUENCE fonksiyonu kullan\u0131labilir.<\/p>\n<p><b>\u00d6rnek:<\/b> Diyelim ki 2023 y\u0131l\u0131n\u0131n Mart ay\u0131 i\u00e7in bir takvim haz\u0131rlamak istiyoruz.<\/p>\n<pre><code>=SEQUENCE(31, 1, DATE(2023, 3, 1))<\/code><\/pre>\n<p>Bu form\u00fcl, 1 Mart 2023&#8217;ten ba\u015flayarak s\u0131ral\u0131 \u015fekilde 31 g\u00fcnl\u00fck bir liste olu\u015fturur.<\/p>\n<h2>2. \u00c7arp\u0131m Tablosu Olu\u015fturma<\/h2>\n<p>Matematik e\u011fitimi i\u00e7in \u00e7arp\u0131m tablosu haz\u0131rlama:<\/p>\n<pre><code>=SEQUENCE(10, 10, 1, 1) * TRANSPOSE(SEQUENCE(10, 10, 1, 1))<\/code><\/pre>\n<p>Bu form\u00fcl ile 1&#8217;den 10&#8217;a kadar olan say\u0131larla olu\u015fturulan \u00e7arp\u0131m tablosu, 10&#215;10&#8217;luk bir tablo \u015feklinde sunulur.<\/p>\n<table>\n<tr>\n<td>1<\/td>\n<td>2<\/td>\n<td>3<\/td>\n<td>&#8230;<\/td>\n<td>10<\/td>\n<\/tr>\n<tr>\n<td>2<\/td>\n<td>4<\/td>\n<td>6<\/td>\n<td>&#8230;<\/td>\n<td>20<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>6<\/td>\n<td>9<\/td>\n<td>&#8230;<\/td>\n<td>30<\/td>\n<\/tr>\n<tr>\n<td>&#8230;<\/td>\n<td>&#8230;<\/td>\n<td>&#8230;<\/td>\n<td>&#8230;<\/td>\n<td>&#8230;<\/td>\n<\/tr>\n<tr>\n<td>10<\/td>\n<td>20<\/td>\n<td>30<\/td>\n<td>&#8230;<\/td>\n<td>100<\/td>\n<\/tr>\n<\/table>\n<p>SEQUENCE fonksiyonu, Excel ve Google Sheets kullan\u0131larak yap\u0131lan veri analizi ve matematiksel hesaplamalar\u0131 kolayla\u015ft\u0131r\u0131r ve otomatikle\u015ftirir. Kullan\u0131c\u0131lar, bu fonksiyonun sundu\u011fu esneklik sayesinde \u00e7e\u015fitli veri setlerini h\u0131zl\u0131 ve etkin bir \u015fekilde olu\u015fturabilir.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dizideki s\u0131ral\u0131 say\u0131lar\u0131n listesini olu\u015fturur; \u00f6rne\u011fin, 1, 2, 3, 4<\/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-15632","post","type-post","status-publish","format-standard","hentry","category-matematik-ve-trigonometri"],"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 SEQUENCE (SIRALI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da SEQUENCE (SIRALI) 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\/sequence\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de SEQUENCE (SIRALI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da SEQUENCE (SIRALI) 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\/sequence\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:35: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&#039;de SEQUENCE (SIRALI) 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\/sequence\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/sequence\/\",\"name\":\"Excel'de SEQUENCE (SIRALI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:53+00:00\",\"dateModified\":\"2021-02-25T16:35:42+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da SEQUENCE (SIRALI) 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\/sequence\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/sequence\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/sequence\/#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\":\"SIRALI\"}]},{\"@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 SEQUENCE (SIRALI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da SEQUENCE (SIRALI) 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\/sequence\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de SEQUENCE (SIRALI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da SEQUENCE (SIRALI) 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\/sequence\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:35:42+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de SEQUENCE (SIRALI) 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\/sequence\/","url":"https:\/\/functiontranslator.com\/tr\/sequence\/","name":"Excel'de SEQUENCE (SIRALI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:53+00:00","dateModified":"2021-02-25T16:35:42+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da SEQUENCE (SIRALI) 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\/sequence\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/sequence\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/sequence\/#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":"SIRALI"}]},{"@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\/15632","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=15632"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15632\/revisions"}],"predecessor-version":[{"id":26900,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15632\/revisions\/26900"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15632"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15632"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15632"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}