{"id":15564,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/taksit_sayisi\/"},"modified":"2021-02-25T16:33:01","modified_gmt":"2021-02-25T16:33:01","slug":"nper","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/nper\/","title":{"rendered":"TAKS\u0130T_SAYISI"},"content":{"rendered":"<h2>Nas\u0131l Kullan\u0131l\u0131r: Finansal Fonksiyon Detaylar\u0131<\/h2>\n<p><code>NPER<\/code> i\u015flevi, belirli bir \u00f6deme, faiz oran\u0131 ve d\u00f6nem ba\u015f\u0131na d\u00fczenli \u00f6deme miktar\u0131 kullan\u0131larak tamamlanmas\u0131 gereken \u00f6deme say\u0131s\u0131n\u0131 hesaplamak i\u00e7in kullan\u0131l\u0131r. Bu i\u015flev, bir borcun tamamen \u00f6denmesi i\u00e7in gerekli taksit say\u0131s\u0131n\u0131 veya belirli bir yat\u0131r\u0131m\u0131n hedeflenen de\u011fere ula\u015fmas\u0131 i\u00e7in gereken d\u00f6nem say\u0131s\u0131n\u0131 bulmada etkilidir. MS Excel ve Google E-Tablolar\u2019da kullan\u0131m\u0131 benzerdir; ancak baz\u0131 k\u00fc\u00e7\u00fck farkl\u0131l\u0131klar vard\u0131r.<\/p>\n<h2>Fonksiyonun S\u00f6zdizimi ve Kullan\u0131m\u0131<\/h2>\n<ul>\n<li><strong>MS Excel:<\/strong> <code>NPER(or_rate, pmt, pv, [fv], [type])<\/code><\/li>\n<li><strong>Google E-Tablolar:<\/strong> <code>NPER(or_rate, pmt, pv, [fv], [type])<\/code><\/li>\n<\/ul>\n<p><strong>A\u00e7\u0131klamalar:<\/strong><\/p>\n<ul>\n<li><code>or_rate<\/code> &#8211; D\u00f6nem ba\u015f\u0131na faiz oran\u0131n\u0131 belirtir.<\/li>\n<li><code>pmt<\/code> &#8211; Her d\u00f6nem yat\u0131r\u0131lan sabit \u00f6deme miktar\u0131n\u0131 ifade eder.<\/li>\n<li><code>pv<\/code> &#8211; Mevcut toplam bor\u00e7 (negatif de\u011fer) veya mevcut yat\u0131r\u0131m de\u011feri (pozitif de\u011fer).<\/li>\n<li><code>fv<\/code> &#8211; (\u0130ste\u011fe Ba\u011fl\u0131) Hedeflenen bor\u00e7 miktar\u0131 veya yat\u0131r\u0131m de\u011feri, varsay\u0131lan de\u011feri 0&#8217;d\u0131r.<\/li>\n<li><code>type<\/code> &#8211; (\u0130ste\u011fe Ba\u011fl\u0131) \u00d6demelerin periyodun ba\u015f\u0131nda (1) veya sonunda (0) yap\u0131ld\u0131\u011f\u0131n\u0131 belirtir; varsay\u0131lan de\u011fer 0&#8217;d\u0131r.<\/li>\n<\/ul>\n<h2>Pratik Kullan\u0131m Senaryolar\u0131<\/h2>\n<h3>Kredi S\u00fcresi Hesaplama<\/h3>\n<p>Bir kredi i\u00e7in ayl\u0131k \u00f6deme miktar\u0131n\u0131, kredi tutar\u0131n\u0131 ve ayl\u0131k faiz oran\u0131n\u0131 bilerek kredi s\u00fcresini hesaplamak i\u00e7in <code>NPER<\/code> i\u015flevi kullan\u0131labilir.<\/p>\n<pre> <code> \u00d6rnek: Faiz Oran\u0131: %5 y\u0131ll\u0131k (ayl\u0131k oran olarak 0.05\/12) Ayda \u00d6denecek Miktar: -1500 TL Kredi Tutar\u0131: 50000 TL MS Excel veya Google E-Tablolar form\u00fcl\u00fc: =NPER(0.05\/12, -1500, 50000) <\/code> <\/pre>\n<p>Bu form\u00fcl, kredi borcunun tamam\u0131n\u0131n \u00f6denmesi i\u00e7in gereken toplam ayl\u0131k taksit say\u0131s\u0131n\u0131 verecektir.<\/p>\n<h3>Yat\u0131r\u0131m Hedefine Ula\u015fma S\u00fcresi<\/h3>\n<p>Birikim yaparak belirli bir hedefe ula\u015fmak istedi\u011finizde, d\u00fczenli yat\u0131r\u0131m miktar\u0131n\u0131z\u0131, ba\u015flang\u0131\u00e7 birikim tutar\u0131n\u0131z\u0131 ve faiz oran\u0131n\u0131z\u0131 kullanarak hedefe ula\u015f\u0131lacak s\u00fcreyi hesaplayabilirsiniz.<\/p>\n<pre> <code> \u00d6rnek: Faiz Oran\u0131: %7 y\u0131ll\u0131k (ayl\u0131k oran olarak 0.07\/12) Ayda Yat\u0131r\u0131lacak Miktar: 1000 TL Ba\u015flang\u0131\u00e7 Birikim Tutar\u0131: 5000 TL Hedef Miktar: 20000 TL MS Excel veya Google E-Tablolar form\u00fcl\u00fc: =NPER(0.07\/12, -1000, -5000, 20000) <\/code> <\/pre>\n<p>Bu form\u00fcl, belirtilen \u015fartlar alt\u0131nda hedef miktar olan 20.000 TL\u2019ye ula\u015fmak i\u00e7in gereken ay say\u0131s\u0131n\u0131 hesaplayacakt\u0131r.<\/p>\n<h2>\u00d6neriler ve Yorumlar<\/h2>\n<p><code>NPER<\/code> i\u015flevi, finansal planlama yaparken \u00f6zellikle faydal\u0131d\u0131r. Hesaplamalar\u0131n\u0131zda dikkate alman\u0131z gereken \u00f6nemli bir nokta, \u00f6deme miktar\u0131n\u0131n (<code>pmt<\/code>) pozitif veya negatif olmas\u0131n\u0131n sonu\u00e7lar\u0131 etkileyebilmesidir. Bor\u00e7 \u00f6demesi yap\u0131yorsan\u0131z, \u00f6deme miktar\u0131n\u0131 negatif; birikim yap\u0131yorsan\u0131z pozitif olarak girmelisiniz. Bu, finansal modellemelerde s\u0131k\u00e7a yap\u0131lan bir hata olup do\u011fru sonu\u00e7lar alman\u0131z\u0131 engelleyebilir.<\/p>\n<p>Son olarak, elde etti\u011finiz sonu\u00e7lar\u0131 yuvarlama yaparak kullanabilir, \u00f6deme plan\u0131n\u0131z\u0131 buna g\u00f6re d\u00fczenleyebilirsiniz. Planlamalar\u0131n\u0131zda esnek olmak ve m\u00fcmk\u00fcn olan en iyi sonucu elde etmek i\u00e7in farkl\u0131 senaryolar\u0131 test etmeyi unutmay\u0131n.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bir yat\u0131r\u0131m\u0131n d\u00f6nem say\u0131s\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":[578],"tags":[],"class_list":["post-15564","post","type-post","status-publish","format-standard","hentry","category-finansal"],"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 NPER (TAKS\u0130T_SAYISI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da NPER (TAKS\u0130T_SAYISI) 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\/nper\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de NPER (TAKS\u0130T_SAYISI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da NPER (TAKS\u0130T_SAYISI) 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\/nper\/\" \/>\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:33:01+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 NPER (TAKS\u0130T_SAYISI) 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=\"3 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/nper\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/nper\/\",\"name\":\"Excel'de NPER (TAKS\u0130T_SAYISI) 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:33:01+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da NPER (TAKS\u0130T_SAYISI) 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\/nper\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/nper\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/nper\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Finansal\",\"item\":\"https:\/\/functiontranslator.com\/tr\/finansal\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"TAKS\u0130T_SAYISI\"}]},{\"@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 NPER (TAKS\u0130T_SAYISI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da NPER (TAKS\u0130T_SAYISI) 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\/nper\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de NPER (TAKS\u0130T_SAYISI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da NPER (TAKS\u0130T_SAYISI) 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\/nper\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:33:01+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de NPER (TAKS\u0130T_SAYISI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"3 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/nper\/","url":"https:\/\/functiontranslator.com\/tr\/nper\/","name":"Excel'de NPER (TAKS\u0130T_SAYISI) 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:33:01+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da NPER (TAKS\u0130T_SAYISI) 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\/nper\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/nper\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/nper\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Finansal","item":"https:\/\/functiontranslator.com\/tr\/finansal\/"},{"@type":"ListItem","position":3,"name":"TAKS\u0130T_SAYISI"}]},{"@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\/15564","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=15564"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15564\/revisions"}],"predecessor-version":[{"id":26832,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15564\/revisions\/26832"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15564"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15564"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15564"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}