{"id":1851,"date":"2023-10-31T11:46:31","date_gmt":"2023-10-31T11:46:31","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/excelde-fonksiyon-nedir\/"},"modified":"2023-12-10T06:00:36","modified_gmt":"2023-12-10T06:00:36","slug":"excelde-fonksiyon-nedir","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/excelde-fonksiyon-nedir\/","title":{"rendered":"Excel&#39;de bir i\u015flev nedir?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-3250910098\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Excel&#8217;de i\u015flev, kullan\u0131c\u0131 taraf\u0131ndan girilen de\u011ferleri ba\u011f\u0131ms\u0131z de\u011fi\u015fken olarak kullanarak belirli bir hesaplamay\u0131 ger\u00e7ekle\u015ftiren \u00f6nceden tan\u0131mlanm\u0131\u015f bir form\u00fcld\u00fcr. Her Excel fonksiyonunun belirli bir amac\u0131 vard\u0131r, basit bir ifadeyle belirli bir de\u011feri hesaplar. Her fonksiyonun, h\u00fccredeki sonucun de\u011ferini elde etmek i\u00e7in kendi arg\u00fcmanlar\u0131 (girilecek de\u011fer) vard\u0131r.<\/p><h2> Bile\u015fenler<\/h2><p> Her fonksiyonun iki ana bile\u015feni vard\u0131r. K\u0131sacas\u0131 her fonksiyon (birka\u00e7 tanesi hari\u00e7) a\u015fa\u011f\u0131daki iki unsurdan olu\u015fur:<\/p><ul><li> Fonksiyon ad\u0131<\/li><li> Arg\u00fcmanlar<\/li><\/ul><p> Size bir \u00f6rnek g\u00f6stereyim. A\u015fa\u011f\u0131da A1 h\u00fccresine ekledi\u011fimiz fonksiyona bir g\u00f6z atal\u0131m.<\/p><p> Art\u0131k form\u00fcl \u00e7ubu\u011funa bakarsan\u0131z, fonksiyonun yap\u0131s\u0131n\u0131 isim ve arg\u00fcmanlar olmak \u00fczere iki par\u00e7aya b\u00f6lerek anlayabilirsiniz.<\/p><h3> \u0130\u015flev ba\u011f\u0131ms\u0131z de\u011fi\u015fkenleri<\/h3><p> Daha \u00f6nce de belirtti\u011fim gibi, bir fonksiyonda istenilen sonucu elde etmek i\u00e7in giri\u015f de\u011ferlerini belirtmeniz gerekir. Arg\u00fcman, belirtmeniz gereken de\u011ferdir. Bir fonksiyonun s\u00f6zdizimine bakarsan\u0131z, her fonksiyonun i\u00e7inde belirtilmesi gereken tan\u0131mlanm\u0131\u015f arg\u00fcmanlar oldu\u011funu g\u00f6rebilirsiniz.<\/p><p> Arg\u00fcman t\u00fcrleri \u015funlard\u0131r:<\/p><ul><li> Zorunlu: Kullan\u0131c\u0131n\u0131n belirtmesi i\u00e7in zorunlu bir ba\u011f\u0131ms\u0131z de\u011fi\u015fken zorunludur ve bu olmadan bir i\u015flev sonucunu hesaplayamaz.<\/li><li> \u0130ste\u011fe ba\u011fl\u0131: Bu ba\u011f\u0131ms\u0131z de\u011fi\u015fkenleri belirtmeyi atlarsan\u0131z, i\u015flevin sonu\u00e7 de\u011ferini hesaplamas\u0131 durdurulmaz.<\/li><li> Arg\u00fcman yok: Bir arg\u00fcman belirtmenize gerek olmayan birka\u00e7 i\u015flev (\u015e\u0130MD\u0130 gibi) vard\u0131r.<\/li><\/ul><h2> Excel&#8217;de bir i\u015flev nas\u0131l eklenir<\/h2><p> Excel&#8217;de bir h\u00fccreye fonksiyon eklemenin en kolay yolu, eklemek istedi\u011finiz fonksiyonun ad\u0131n\u0131 e\u015fittir i\u015faretinden ba\u015flayarak yazmakt\u0131r.<\/p><p> SUM i\u015flevini eklemek istedi\u011finizi varsayal\u0131m:<\/p><ul><li> \u00d6ncelikle = yazman\u0131z ve ard\u0131ndan SUM yazman\u0131z gerekir.<\/li><li> Bundan sonra a\u00e7\u0131l\u0131\u015f parantezlerini girin.<\/li><li> Arg\u00fcmanlar\u0131 belirtin (bir h\u00fccreye bak\u0131n veya de\u011ferleri do\u011frudan fonksiyona girebilirsiniz).<\/li><li> Sonunda kapatma parantezlerini yaz\u0131n ve Enter tu\u015funa bas\u0131n.<\/li><\/ul><h2> Ana t\u00fcrler<\/h2><p> \u0130\u015fte ana t\u00fcrler:<\/p><ul><li> <strong>Metin \u0130\u015flevleri<\/strong> : Metin i\u00e7eren verilerle u\u011fra\u015f\u0131yorsan\u0131z, etkili bir \u015fekilde \u00e7al\u0131\u015fmak i\u00e7in \u00f6\u011frenmeniz gereken i\u015flevlerden baz\u0131lar\u0131n\u0131 burada bulabilirsiniz.<\/li><li> <strong>Tarih i\u015flevleri<\/strong> : Tarihler, her g\u00fcn kulland\u0131\u011f\u0131n\u0131z verilerin ana bile\u015fenlerinden biridir ve verilerinizi daha iyi analiz etmenize yard\u0131mc\u0131 olur.<\/li><li> <strong>Zaman Fonksiyonlar\u0131<\/strong> : Tarihler gibi, zaman da verilerde mevcut olabilir ve zaman de\u011ferlerine sahip oldu\u011funuz verileri i\u015flemek i\u00e7in zaman fonksiyonlar\u0131n\u0131 kullanabilirsiniz.<\/li><li> <strong>Mant\u0131k \u0130\u015flevleri<\/strong> : Mant\u0131k i\u015flevleri, e-tablonuzda en kullan\u0131\u015fl\u0131 form\u00fcllerden baz\u0131lar\u0131n\u0131 olu\u015fturman\u0131za yard\u0131mc\u0131 olabilir.<\/li><li> <strong>Matematik \u0130\u015flevleri<\/strong> : Excel tamamen hesaplamalar, analizler ve matematik i\u015flevleriyle ilgilidir ve hesaplamalarda ve analizlerde daha iyi olmak i\u00e7in bu i\u015flevleri kullanabilirsiniz.<\/li><li> <strong>\u0130statistiksel i\u015flevler<\/strong> : Excel&#8217;in en iyi yanlar\u0131ndan biri, verileri kolayca analiz etmek i\u00e7in kullanabilece\u011finiz bir dizi istatistiksel i\u015flevin bulunmas\u0131d\u0131r.<\/li><li> <strong>Arama \u0130\u015flevleri<\/strong> : Excel&#8217;de, bir h\u00fccre veya h\u00fccre aral\u0131\u011f\u0131 hakk\u0131nda belirli bir de\u011feri veya bilgiyi araman\u0131za yard\u0131mc\u0131 olabilecek belirli i\u015flevler vard\u0131r.<\/li><li> <strong>Bilgi fonksiyonu<\/strong> : Bunlar sa\u011flad\u0131\u011f\u0131n\u0131z de\u011ferler hakk\u0131nda bilgi almak i\u00e7in kullanabilece\u011finiz baz\u0131 spesifik fonksiyonlard\u0131r.<\/li><li> <strong>Finansal i\u015flevler<\/strong> : Bu i\u015flevler, yayg\u0131n ancak \u00f6nemli finansal hesaplamalardan baz\u0131lar\u0131n\u0131 kolayca hesaplaman\u0131za yard\u0131mc\u0131 olabilir.<\/li><\/ul>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1851","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de bir i\u015flev nedir? \u2013 Excel Dan\u0131\u015fman\u0131<\/title>\n<meta name=\"description\" content=\"\u0130\u015flev, kullan\u0131c\u0131 taraf\u0131ndan girilen de\u011ferleri ba\u011f\u0131ms\u0131z de\u011fi\u015fken olarak kullanarak belirli bir hesaplamay\u0131 ger\u00e7ekle\u015ftiren \u00f6nceden tan\u0131mlanm\u0131\u015f bir form\u00fcld\u00fcr.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/tr\/excelde-fonksiyon-nedir\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de bir i\u015flev nedir? \u2013 Excel Dan\u0131\u015fman\u0131\" \/>\n<meta property=\"og:description\" content=\"\u0130\u015flev, kullan\u0131c\u0131 taraf\u0131ndan girilen de\u011ferleri ba\u011f\u0131ms\u0131z de\u011fi\u015fken olarak kullanarak belirli bir hesaplamay\u0131 ger\u00e7ekle\u015ftiren \u00f6nceden tan\u0131mlanm\u0131\u015f bir form\u00fcld\u00fcr.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/excelde-fonksiyon-nedir\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:00:36+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/excelde-fonksiyon-nedir\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/excelde-fonksiyon-nedir\/\",\"name\":\"Excel&#39;de bir i\u015flev nedir? \u2013 Excel Dan\u0131\u015fman\u0131\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"datePublished\":\"2023-10-31T11:46:31+00:00\",\"dateModified\":\"2023-12-10T06:00:36+00:00\",\"description\":\"\u0130\u015flev, kullan\u0131c\u0131 taraf\u0131ndan girilen de\u011ferleri ba\u011f\u0131ms\u0131z de\u011fi\u015fken olarak kullanarak belirli bir hesaplamay\u0131 ger\u00e7ekle\u015ftiren \u00f6nceden tan\u0131mlanm\u0131\u015f bir form\u00fcld\u00fcr.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/excelde-fonksiyon-nedir\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/excelde-fonksiyon-nedir\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/excelde-fonksiyon-nedir\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de bir i\u015flev nedir?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"name\":\"Excel Advisor\",\"description\":\"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel&#39;de bir i\u015flev nedir? \u2013 Excel Dan\u0131\u015fman\u0131","description":"\u0130\u015flev, kullan\u0131c\u0131 taraf\u0131ndan girilen de\u011ferleri ba\u011f\u0131ms\u0131z de\u011fi\u015fken olarak kullanarak belirli bir hesaplamay\u0131 ger\u00e7ekle\u015ftiren \u00f6nceden tan\u0131mlanm\u0131\u015f bir form\u00fcld\u00fcr.","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:\/\/exceladvisor.org\/tr\/excelde-fonksiyon-nedir\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de bir i\u015flev nedir? \u2013 Excel Dan\u0131\u015fman\u0131","og_description":"\u0130\u015flev, kullan\u0131c\u0131 taraf\u0131ndan girilen de\u011ferleri ba\u011f\u0131ms\u0131z de\u011fi\u015fken olarak kullanarak belirli bir hesaplamay\u0131 ger\u00e7ekle\u015ftiren \u00f6nceden tan\u0131mlanm\u0131\u015f bir form\u00fcld\u00fcr.","og_url":"https:\/\/exceladvisor.org\/tr\/excelde-fonksiyon-nedir\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:00:36+00:00","twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"3 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/excelde-fonksiyon-nedir\/","url":"https:\/\/exceladvisor.org\/tr\/excelde-fonksiyon-nedir\/","name":"Excel&#39;de bir i\u015flev nedir? \u2013 Excel Dan\u0131\u015fman\u0131","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"datePublished":"2023-10-31T11:46:31+00:00","dateModified":"2023-12-10T06:00:36+00:00","description":"\u0130\u015flev, kullan\u0131c\u0131 taraf\u0131ndan girilen de\u011ferleri ba\u011f\u0131ms\u0131z de\u011fi\u015fken olarak kullanarak belirli bir hesaplamay\u0131 ger\u00e7ekle\u015ftiren \u00f6nceden tan\u0131mlanm\u0131\u015f bir form\u00fcld\u00fcr.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/excelde-fonksiyon-nedir\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/excelde-fonksiyon-nedir\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/excelde-fonksiyon-nedir\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de bir i\u015flev nedir?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/tr\/#website","url":"https:\/\/exceladvisor.org\/tr\/","name":"Excel Advisor","description":"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!","publisher":{"@id":"https:\/\/exceladvisor.org\/tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/tr\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/tr\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1851","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/comments?post=1851"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1851\/revisions"}],"predecessor-version":[{"id":2420,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1851\/revisions\/2420"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1851"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}