{"id":15633,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/seritopla\/"},"modified":"2021-02-25T16:35:45","modified_gmt":"2021-02-25T16:35:45","slug":"seriessum","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/seriessum\/","title":{"rendered":"SER\u0130TOPLA"},"content":{"rendered":"

Seriler Toplam\u0131n\u0131 Hesaplama<\/h2>\n

SERIESSUM veya T\u00fcrk\u00e7e kar\u015f\u0131l\u0131\u011f\u0131 ile SER\u0130TOPLA fonksiyonu, matematikte bulunan kuvvet serilerini hesaplamak i\u00e7in kullan\u0131lan bir i\u015flevdir. Excel ve Google E-Tablolar’da, bu i\u015flev \u00f6zellikle finansal analizler ve m\u00fchendislik hesaplamalar\u0131nda faydal\u0131d\u0131r. Fonksiyonun genel yap\u0131s\u0131 ve kullan\u0131m\u0131 hakk\u0131nda detayl\u0131 a\u00e7\u0131klamalar yapmak gerekirse:<\/p>\n

\u0130\u015flevin S\u00f6zdizimi<\/h2>\n

SERIESSUM i\u015flevi a\u015fa\u011f\u0131daki s\u00f6zdizimine sahiptir:<\/p>\n

SERIESSUM(x, n, m, katsay\u0131lar)<\/code><\/pre>\n
    \n
  • x<\/code>: Serinin de\u011fi\u015fkenidir ve serideki her terimin kuvvetinin baz\u0131n\u0131 olu\u015fturur.<\/li>\n
  • n<\/code>: x’in ilk kuvvetidir.<\/li>\n
  • m<\/code>: Serideki terimlerin art\u0131\u015f miktar\u0131n\u0131 belirler, yani her bir sonraki terim bir \u00f6ncekinin kuvvetine ‘m’ ekleyerek devam eder.<\/li>\n
  • katsay\u0131lar<\/code>: Serideki her bir terimin \u00f6n\u00fcndeki katsay\u0131lar\u0131 i\u00e7eren bir dizi veya aral\u0131kt\u0131r.<\/li>\n<\/ul>\n
    \u00d6rnek olarak, bir kuvvet serisi hesaplanacaksa:<\/p>\n
    SERIESSUM(2, 0, 1, {1, -1, 1})<\/code><\/pre>\n
    Bu \u00f6rnekte, x = 2<\/code> (serinin de\u011fi\u015fkeni), n = 0<\/code> (ilk terimde x’in kuvveti), m = 1<\/code> (sonraki her terimde kuvvetin art\u0131\u015f miktar\u0131) ve katsay\u0131lar {1, -1, 1} dizisini kullan\u0131r. Burada hesaplanacak serinin form\u00fcl\u00fc: 1*2^0 - 1*2^1 + 1*2^2<\/code> olur ve sonu\u00e7 olarak 3<\/code> elde edilir.<\/p>\n
    Pratik Kullan\u0131m \u00d6rnekleri<\/h2>\n
    Finansal Analiz: \u0130ndirimli Nakit Ak\u0131\u015flar\u0131<\/h3>\n
    \u00d6zellikle finans alan\u0131nda, gelecek nakit ak\u0131\u015flar\u0131n\u0131n bug\u00fcnk\u00fc de\u011feri hesaplan\u0131rken kullan\u0131labilir. Diyelim ki, bir i\u015fletme gelecek 3 y\u0131l i\u00e7in s\u0131ras\u0131yla 10000, 15000 ve 18000 TL nakit ak\u0131\u015f\u0131 tahmin etmekte. Bu ak\u0131\u015flar\u0131n bug\u00fcnk\u00fc de\u011ferini %10’luk bir indirim oran\u0131yla hesaplamak i\u00e7in: <\/p>\n
    SERIESSUM(0.1, 0, 1, {10000, 15000, 18000})<\/code><\/pre>\n
     Not: Burada x = 0.1<\/code> (indirim oran\u0131), n = 0<\/code>, m = 1<\/code> ve katsay\u0131lar ise gelecekteki nakit ak\u0131\u015flar\u0131n\u0131 temsil eder. Bu indirimli nakit ak\u0131\u015flar\u0131 toplam\u0131n\u0131 verir.<\/p>\n
    M\u00fchendislik: Alternatif Ak\u0131m Devre Analizleri<\/h3>\n
    Elektrik m\u00fchendisli\u011finde, sinusoidal ak\u0131mlar veya voltajlar seri olarak ifade edilebilir. E\u011fer bir AC devresindeki gerilim dalga formu Fourier serisi ile ifade edilmekteyse, katsay\u0131lar\u0131 ve frekanslar\u0131 belirleyerek toplam harmonik distorsiyonu (THD) hesaplamak i\u00e7in kullan\u0131labilir. \u00d6rnek form\u00fcl: <\/p>\n
    SERIESSUM(x, 0, 2, {V1, V2, V3, ...})<\/code><\/pre>\n
     Burada x<\/code>, a\u00e7\u0131sal frekans\u0131 (\u03c9t<\/code>), n = 0<\/code>, m = 2<\/code> (harmonikler i\u00e7in art\u0131\u015f miktar\u0131) ve V1, V2, V3<\/code> ise harmoniklerin genlikleri olacakt\u0131r.<\/p>\n
    Genel olarak SERIESSUM, karma\u015f\u0131k seri hesaplamalar\u0131n\u0131 basit ve etkin bir \u015fekilde yapman\u0131za olanak tan\u0131r, b\u00f6ylelikle mali, m\u00fchendislik ve bilimsel veriler \u00fczerinde daha h\u0131zl\u0131 ve do\u011fru analizler ger\u00e7ekle\u015ftirebilirsiniz. Ancak, i\u015flevin do\u011fru kullan\u0131labilmesi i\u00e7in serinin do\u011fru bir \u015fekilde tan\u0131mlanm\u0131\u015f olmas\u0131 gerekmektedir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Form\u00fcl esas\u0131nda kuvvet serisi toplam\u0131n\u0131 verir<\/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-15633","post","type-post","status-publish","format-standard","hentry","category-matematik-ve-trigonometri"],"acf":[],"yoast_head":"\nExcel'de SERIESSUM (SER\u0130TOPLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da SERIESSUM (SER\u0130TOPLA) 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\/seriessum\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de SERIESSUM (SER\u0130TOPLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da SERIESSUM (SER\u0130TOPLA) 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\/seriessum\/\" \/>\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:45+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 SERIESSUM (SER\u0130TOPLA) 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\/seriessum\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/seriessum\/\",\"name\":\"Excel'de SERIESSUM (SER\u0130TOPLA) 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:45+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da SERIESSUM (SER\u0130TOPLA) 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\/seriessum\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/seriessum\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/seriessum\/#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\":\"SER\u0130TOPLA\"}]},{\"@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 SERIESSUM (SER\u0130TOPLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da SERIESSUM (SER\u0130TOPLA) 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\/seriessum\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de SERIESSUM (SER\u0130TOPLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da SERIESSUM (SER\u0130TOPLA) 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\/seriessum\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:35:45+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de SERIESSUM (SER\u0130TOPLA) 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\/seriessum\/","url":"https:\/\/functiontranslator.com\/tr\/seriessum\/","name":"Excel'de SERIESSUM (SER\u0130TOPLA) 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:45+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da SERIESSUM (SER\u0130TOPLA) 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\/seriessum\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/seriessum\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/seriessum\/#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":"SER\u0130TOPLA"}]},{"@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\/15633","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=15633"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15633\/revisions"}],"predecessor-version":[{"id":26901,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15633\/revisions\/26901"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15633"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15633"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15633"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}