{"id":4698,"date":"2022-03-14T23:59:56","date_gmt":"2022-03-14T20:59:56","guid":{"rendered":"https:\/\/www.hostixo.com\/blog\/?p=4698"},"modified":"2022-03-23T06:09:36","modified_gmt":"2022-03-23T03:09:36","slug":"isinize-yarayacak-microsoft-excel-formulleri","status":"publish","type":"post","link":"https:\/\/www.hostixo.com\/blog\/isinize-yarayacak-microsoft-excel-formulleri\/","title":{"rendered":"Her T\u00fcrl\u00fc \u0130\u015finize Yarayacak Birbirinden Farkl\u0131 Microsoft Excel Form\u00fclleri"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u0130\u00e7indekiler \u2714<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"\u0130\u00e7indekiler Tablosunu A\u00e7\/Kapat\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.hostixo.com\/blog\/isinize-yarayacak-microsoft-excel-formulleri\/#Microsoft_Excel_Nedir_Ne_Ise_Yarar\" >Microsoft Excel Nedir? Ne \u0130\u015fe Yarar?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.hostixo.com\/blog\/isinize-yarayacak-microsoft-excel-formulleri\/#Microsoft_Excel_Formulleri_Ne_Ise_Yarar\" >Microsoft Excel Form\u00fclleri Ne \u0130\u015fe Yarar?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.hostixo.com\/blog\/isinize-yarayacak-microsoft-excel-formulleri\/#Microsoft_Excel_Hucre_Nedir\" >Microsoft Excel H\u00fccre Nedir?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.hostixo.com\/blog\/isinize-yarayacak-microsoft-excel-formulleri\/#Birbirinden_Farkli_Islevlere_Sahip_Microsoft_Excel_Formuller_Listesi\" >Birbirinden Farkl\u0131 \u0130\u015flevlere Sahip Microsoft Excel Form\u00fcller Listesi<\/a><\/li><\/ul><\/nav><\/div>\n<p>Bir\u00e7ok Excel kullan\u0131c\u0131s\u0131, <strong>Microsoft Excel form\u00fclleri<\/strong> hakk\u0131nda fikir sahibi olamayabiliyor. Ancak bu form\u00fcller asl\u0131nda Excel\u2019in kullan\u0131m\u0131n\u0131 \u00e7ok farkl\u0131 bir boyuta ta\u015f\u0131yabiliyorlar. Bizim amac\u0131m\u0131zda yaz\u0131m\u0131zda sizleri bu form\u00fcller hakk\u0131nda bilgi sahibi yapabilmek.<\/p>\n<p>Microsoft Excel, y\u0131llard\u0131r bir\u00e7ok farkl\u0131 ama\u00e7la kullan\u0131labilen bir program. Microsoft Office uygulamalar\u0131 aras\u0131nda yer alan bu program, normal \u015fartlarda olduk\u00e7a basit bir kullan\u0131ma sahip. Yani bir\u00e7ok ki\u015fi bu program \u00fczerinden tablo olu\u015fturma gibi \u015feyleri \u00e7ok fazla ayr\u0131nt\u0131ya girmeden yapabiliyor.<\/p>\n<p>Ancak Microsoft Excel\u2019in asl\u0131nda az bilinen \u00f6nemli bir y\u00f6n\u00fc daha var. Bu program, form\u00fcller sayesinde \u00e7ok daha farkl\u0131 i\u015flevlere sahip olabiliyor. Yani Excel form\u00fclleri kullanarak birbirinden farkl\u0131 bir\u00e7ok \u015fey yapabiliyorsunuz. \u0130\u015fte bu <strong>Microsoft Excel form\u00fclleri<\/strong> ilk ba\u015fta kullan\u0131c\u0131lara olduk\u00e7a kar\u0131\u015f\u0131k gelebiliyorlar. Ancak tabii ki kullan\u0131c\u0131lar bu form\u00fcllere zamanla al\u0131\u015fabiliyorlar.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Microsoft_Excel_Nedir_Ne_Ise_Yarar\"><\/span><strong>Microsoft Excel Nedir? Ne \u0130\u015fe Yarar?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-4704 lazyload\" data-src=\"https:\/\/www.hostixo.com\/blog\/wp-content\/uploads\/2022\/03\/hostixo-blog-microsoft-excel-formulleri-excel-nedir.jpg\" alt=\"hostixo-blog-microsoft-excel-formulleri-excel-nedir\" width=\"640\" height=\"360\" title=\"\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 640px; --smush-placeholder-aspect-ratio: 640\/360;\"><noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-4704\" src=\"https:\/\/www.hostixo.com\/blog\/wp-content\/uploads\/2022\/03\/hostixo-blog-microsoft-excel-formulleri-excel-nedir.jpg\" alt=\"hostixo-blog-microsoft-excel-formulleri-excel-nedir\" width=\"640\" height=\"360\" title=\"\"><\/noscript><\/p>\n<p><strong>Microsoft Excel form\u00fclleri<\/strong> konusundan \u00f6nce tabii ki Microsoft Excel hakk\u0131nda biraz bilgi sahibi olman\u0131z gerekiyor. Excel, Microsoft\u2019un seneler \u00f6nce geli\u015ftirdi\u011fi bir program. Y\u0131llard\u0131r \u00f6zellikle ofislerde \u00e7ok fazla tercih edilen bu program, Microsoft Office programlar\u0131 aras\u0131nda yer al\u0131yor.<\/p>\n<p>Bir <strong><a href=\"https:\/\/www.office.com\/\" target=\"_blank\" rel=\"noopener\">Microsoft Office<\/a><\/strong> \u00fcyesi olan Excel, asl\u0131nda bir say\u0131 ve tablo olu\u015fturma program\u0131 olarak da tan\u0131mlanabilir. Bu programda basit bir \u015fekilde tablo olu\u015fturma gibi i\u015flemleri ger\u00e7ekle\u015ftirebilmeniz m\u00fcmk\u00fcn. Program\u0131 a\u00e7t\u0131\u011f\u0131n\u0131zda kar\u015f\u0131n\u0131za sat\u0131r ve s\u00fctunlardan olu\u015fan h\u00fccreler \u00e7\u0131kar.<\/p>\n<p>Bu h\u00fccrelere eklemeler yapabilir veya \u00fcst k\u0131s\u0131mdan bir\u00e7ok farkl\u0131 se\u00e7enekle haz\u0131r tablolar vs. ekleyebilirsiniz. \u0130\u015fte bu kadar basit g\u00f6r\u00fcnen program\u0131n asl\u0131nda \u00e7ok bilinmeyen ama fazlas\u0131yla \u00f6nemli bir y\u00f6n\u00fc mevcut.<\/p>\n<p>\u00c7\u00fcnk\u00fc bu program, Microsoft Excel form\u00fclleri sayesinde birbirinden farkl\u0131 ve detayl\u0131 \u00f6zelliklere eri\u015febilmenize olanak tan\u0131yor. Yani baz\u0131 form\u00fcller sayesinde olduk\u00e7a basit kullan\u0131m\u0131 olan Excel \u00fczerinde \u00e7ok daha farkl\u0131 projelere imza atabiliyorsunuz.<\/p>\n<p>\u00d6zellikle Excel kullanan ki\u015filerin bu form\u00fcller hakk\u0131nda bilgi sahibi olmas\u0131 olduk\u00e7a \u00f6nemli. Bizde bu y\u00fczden yaz\u0131m\u0131zda sizler i\u00e7in bu form\u00fcllerden bahsetmeye \u00e7al\u0131\u015faca\u011f\u0131z.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Microsoft_Excel_Formulleri_Ne_Ise_Yarar\"><\/span><strong>Microsoft Excel Form\u00fclleri Ne \u0130\u015fe Yarar?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-4703 lazyload\" data-src=\"https:\/\/www.hostixo.com\/blog\/wp-content\/uploads\/2022\/03\/hostixo-blog-microsoft-excel-formulleri-formul-nedir.jpg\" alt=\"hostixo-blog-microsoft-excel-formulleri-formul-nedir\" width=\"640\" height=\"482\" title=\"\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 640px; --smush-placeholder-aspect-ratio: 640\/482;\"><noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-4703\" src=\"https:\/\/www.hostixo.com\/blog\/wp-content\/uploads\/2022\/03\/hostixo-blog-microsoft-excel-formulleri-formul-nedir.jpg\" alt=\"hostixo-blog-microsoft-excel-formulleri-formul-nedir\" width=\"640\" height=\"482\" title=\"\"><\/noscript><\/p>\n<p><strong>Microsoft Excel form\u00fclleri<\/strong> ile birbirinden farkl\u0131 bir\u00e7ok i\u015flem yap\u0131labiliyor. Excel&#8217;de form\u00fcller ve fonksiyonlar sayesinde toplama gibi basit i\u015flemler dahil bir\u00e7ok farkl\u0131 i\u015flem yap\u0131labiliyor. Yani asl\u0131nda form\u00fcller Microsoft Excel&#8217;in kullan\u0131m\u0131n\u0131 \u00e7ok farkl\u0131 bir boyuta ta\u015f\u0131yabiliyor. Ancak bir\u00e7ok ki\u015fi bu program\u0131n form\u00fcllerinden haberdar olamayabiliyor.<\/p>\n<p>\u0130\u015fte bizde bu y\u00fczden sizlere bu k\u0131s\u0131mda form\u00fcllerin ne i\u015fe yarad\u0131\u011f\u0131ndan biraz bahsetmek istiyoruz. Bu noktada ilk olarak Excel form\u00fclleriyle basit matematik i\u015flemlerini ger\u00e7ekle\u015ftirebilece\u011finizi belirtmek istiyoruz. \u00d6rne\u011fin, bu form\u00fcllerle toplama \u00e7\u0131karmadan tutun mant\u0131ksal s\u0131namalara kadar bir\u00e7ok farkl\u0131 i\u015flemi ger\u00e7ekle\u015ftirebilirsiniz.<\/p>\n<p>Ayr\u0131ca Microsoft Excel form\u00fclleri aras\u0131nda tarih form\u00fclleri gibi form\u00fcllerde mevcut. Uzun laf\u0131n k\u0131sas\u0131, Excel form\u00fclleri sayesinde Excel \u00fczerinde matematiksel i\u015flemler dahil bir\u00e7ok farkl\u0131 i\u015flem ger\u00e7ekle\u015ftirebilirsiniz. E\u011fer sizde Excel form\u00fclleri hakk\u0131nda daha fazlas\u0131n\u0131 merak ediyorsan\u0131z, yaz\u0131m\u0131z\u0131n devam\u0131n\u0131 okuman\u0131zda fayda var.<\/p>\n<h3><strong>Microsoft Excel Form\u00fclleri Nas\u0131l Kullan\u0131l\u0131r?<\/strong><\/h3>\n<p><strong>Microsoft Excel form\u00fclleri<\/strong>, daha \u00f6nce belirtti\u011fimiz gibi bir\u00e7ok farkl\u0131 i\u015flem i\u00e7in kullan\u0131labiliyorlar. Bu form\u00fcller asl\u0131nda Excel\u2019in kullan\u0131m\u0131n\u0131 \u00e7ok farkl\u0131 bir boyuta ta\u015f\u0131yabiliyorlar. Excel form\u00fcllerini kullanmak i\u00e7in ilk \u00f6nce Excel\u2019de bir h\u00fccreye \u201c=\u201d girmeniz gerekiyor.<\/p>\n<p>Daha sonra e\u015fittir i\u015faretinin yan\u0131na Excel i\u00e7in \u00f6zel haz\u0131rlanm\u0131\u015f baz\u0131 kelimeleri vs. girdi\u011finizde form\u00fcl olu\u015fmu\u015f oluyor. Excel\u2019de h\u00fccreye yazd\u0131\u011f\u0131n\u0131z form\u00fcller, ana men\u00fcdeki form\u00fcl \u00e7ubu\u011funda da g\u00f6steriliyorlar. Excel \u00fczerinde form\u00fcl kullan\u0131m\u0131 basit\u00e7e bu \u015fekilde olu\u015fuyor. Yaz\u0131m\u0131z\u0131n devam\u0131nda birbirinden kullan\u0131\u015fl\u0131 \u00f6nemli Excel form\u00fcllerini bulabilirsiniz.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Microsoft_Excel_Hucre_Nedir\"><\/span><strong>Microsoft Excel H\u00fccre Nedir?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>Microsoft Excel form\u00fclleri<\/strong> konusundan \u00f6nce Microsoft Excel\u2019de bulunan h\u00fccrelerden biraz bahsetmek istiyoruz. Asl\u0131nda Microsoft Excel\u2019in h\u00fccrelerin bir araya gelmesiyle olu\u015ftu\u011funu s\u00f6yleyebiliriz. Excel\u2019de veri girilen yerleri h\u00fccre olarak tan\u0131mlayabiliriz.<\/p>\n<p>\u00d6rne\u011fin, bir form\u00fcl girece\u011finiz zaman belirli bir h\u00fccre kullanabilirsiniz. Ancak girece\u011finiz veriye tek bir h\u00fccre yetmiyorsa, h\u00fccreyi geni\u015fletmeniz vs. m\u00fcmk\u00fcnd\u00fcr. Bunlar\u0131n yan\u0131 s\u0131ra, h\u00fccrelerin sat\u0131r ve s\u00fctunlar\u0131n kesi\u015fmesiyle olu\u015ftu\u011funu s\u00f6yleyebiliriz.<\/p>\n<p>Ayr\u0131ca bu h\u00fccrelerinin adreslerinin <a href=\"https:\/\/www.hostixo.com\/blog\/linuxda-komut-satiri-ile-islem-yonetimi\/\">sat\u0131r<\/a> numaralar\u0131 ve s\u00fctun harfleriyle tan\u0131mland\u0131\u011f\u0131n\u0131 da belirtmemizde fayda var. \u00d6rne\u011fin, C1 h\u00fccresi dendi\u011finde C s\u00fctunundaki 1 numaral\u0131 sat\u0131rda yer alan h\u00fccreden bahsedilmektedir.<\/p>\n<p>Microsoft Excel form\u00fclleri kullan\u0131l\u0131rken h\u00fccrelerin aras\u0131na \u201c:\u201d i\u015fareti konulursa, i\u015faretin konuldu\u011fu aral\u0131ktaki h\u00fccreler i\u015fleme dahil olur.<\/p>\n<p>Ancak h\u00fccreler aras\u0131nda \u201c;\u201d konulursa bu durumda sadece ad\u0131 yaz\u0131lan h\u00fccreler i\u015fleme dahil olur.<\/p>\n<p>H\u00fccrelerin \u00f6zelliklerini de\u011fi\u015ftirmek i\u00e7in bir h\u00fccreyi veya baz\u0131 h\u00fccreleri se\u00e7erek sa\u011f t\u0131klayabilirsiniz. Ard\u0131ndan kar\u015f\u0131n\u0131za \u00e7\u0131kan se\u00e7eneklerden \u2018H\u00fccreleri Bi\u00e7imlendir\u2019 se\u00e7ene\u011fine t\u0131klamal\u0131s\u0131n\u0131z. Sonras\u0131nda kar\u015f\u0131n\u0131zdaki \u201cSay\u0131\u201d, \u201cSaat\u201d, \u201cMetin\u201d veya \u201cTarih\u201d gibi se\u00e7eneklerden istedi\u011finizi se\u00e7ebilirsiniz. Bu men\u00fcden hangi \u00f6zelli\u011fi se\u00e7tiyseniz, h\u00fccre o \u00f6zelli\u011fe sahip olacakt\u0131r.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Birbirinden_Farkli_Islevlere_Sahip_Microsoft_Excel_Formuller_Listesi\"><\/span><strong>Birbirinden Farkl\u0131 \u0130\u015flevlere Sahip Microsoft Excel Form\u00fcller<\/strong><strong> Listesi<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-4738 lazyload\" data-src=\"https:\/\/www.hostixo.com\/blog\/wp-content\/uploads\/2022\/03\/hostixo-blog-microsoft-excel-formulleri-kullanisli-excel-formulleri-2022.jpg\" alt=\"hostixo-blog-microsoft-excel-formulleri-kullanisli-excel-formulleri-2022\" width=\"640\" height=\"395\" title=\"\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 640px; --smush-placeholder-aspect-ratio: 640\/395;\"><noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-4738\" src=\"https:\/\/www.hostixo.com\/blog\/wp-content\/uploads\/2022\/03\/hostixo-blog-microsoft-excel-formulleri-kullanisli-excel-formulleri-2022.jpg\" alt=\"hostixo-blog-microsoft-excel-formulleri-kullanisli-excel-formulleri-2022\" width=\"640\" height=\"395\" title=\"\"><\/noscript><\/p>\n<p>Bir\u00e7ok farkl\u0131 ama\u00e7la kullanabilece\u011finiz baz\u0131 <strong>Microsoft Excel form\u00fclleri<\/strong> bulunuyor. Bizde bu y\u00fczden yaz\u0131m\u0131z\u0131n bu k\u0131sm\u0131nda baz\u0131 Excel form\u00fcllerinden sizler i\u00e7in bahsetmek istiyoruz. Listemizdeki form\u00fcller Excel en \u00e7ok kullan\u0131lan form\u00fcller aras\u0131nda g\u00f6sterilebilirler. E\u011fer sizde daha detayl\u0131 bir Excel kullan\u0131m\u0131 yani Excel&#8217;de birbirinden farkl\u0131 i\u015flemler yapmak istiyorsan\u0131z, yaz\u0131m\u0131zdaki form\u00fcllere g\u00f6z atabilirsiniz. Baz\u0131 dikkat \u00e7eken Excel form\u00fclleri ve a\u00e7\u0131klamalar\u0131 a\u015fa\u011f\u0131daki \u015fekilde olu\u015fuyor.<\/p>\n<h3><strong>=MAK (MAX) Form\u00fcl\u00fc<\/strong><\/h3>\n<p><strong>Microsoft Excel form\u00fclleri<\/strong> aras\u0131nda bulunan <strong>MAX form\u00fcl\u00fc<\/strong>, se\u00e7ti\u011finiz h\u00fccreler aras\u0131ndaki en y\u00fcksek de\u011fere sahip olan\u0131 bulman\u0131z\u0131 sa\u011flar.<\/p>\n<h4><strong>Form\u00fcl Kullan\u0131m\u0131<\/strong><\/h4>\n<p>\u0130lk olarak sonucu g\u00f6rmek istedi\u011finiz h\u00fccreye \u201c=\u201d i\u015faretini girin ve \u00fcstteki &#8216;Form\u00fcller&#8217; sekmesine t\u0131klayarak \u2018\u0130\u015flev Ekle\u2019 butonuna bas\u0131n.<\/p>\n<p>Sonras\u0131nda \u201cMAK\u201d komutunu se\u00e7ip &#8216;Tamam&#8217; butonuna bast\u0131\u011f\u0131n\u0131zda a\u00e7\u0131lan pencerede h\u00fccreler otomatik se\u00e7ilecektir. Ancak siz yine de se\u00e7ilen h\u00fccreleri istedi\u011finiz gibi de\u011fi\u015ftirebilirsiniz.<\/p>\n<p>Form\u00fcl\u00fc elle yazmak i\u00e7in bir h\u00fccreye \u201cMAK(D1:D7)\u201d yazabilirsiniz. Bunu yazd\u0131\u011f\u0131n\u0131zda D1 ve D7 h\u00fccreleri aras\u0131ndaki h\u00fccrelerin maksimum de\u011feri sonu\u00e7 olarak kar\u015f\u0131n\u0131za \u00e7\u0131kar.<\/p>\n<p>E\u011fer istedi\u011finiz h\u00fccrelerin aras\u0131nda \u201c;\u201d koyarsan\u0131z, sadece belirtti\u011finiz h\u00fccreleri i\u015fleme dahil etmi\u015f olursunuz. Yani \u201cMAK(D1;D7;D9)\u201d yazd\u0131\u011f\u0131n\u0131zda, sadece parantez i\u00e7erisindeki h\u00fccrelerin maksimum de\u011feri size g\u00f6sterilir.<\/p>\n<p>E\u011fer bu form\u00fclde \u201cMAK\u201d yerine \u201cMIN\u201d yazarsan\u0131z, belirtti\u011finiz h\u00fccreler aras\u0131ndaki maksimum de\u011fer yerine minimum de\u011fere ula\u015fabilirsiniz.<\/p>\n<h3><strong>=ORTALAMA (AVERAGE) Form\u00fcl\u00fc<\/strong><\/h3>\n<p><strong>Microsoft Excel form\u00fclleri<\/strong> aras\u0131nda bulunan <strong>=ORTALAMA<\/strong> (=AVERAGE) form\u00fcl\u00fc, ortalama bulmak i\u00e7in kullan\u0131l\u0131r.<\/p>\n<h4><strong>Form\u00fcl Kullan\u0131m\u0131<\/strong><\/h4>\n<p>\u0130lk olarak sonucu g\u00f6rmek istedi\u011finiz h\u00fccreye \u201c=\u201d girin ve sonras\u0131nda \u00fcstteki \u2018Form\u00fcller\u2019 sekmesine t\u0131klayarak \u2018\u0130\u015flev Ekle\u2019 se\u00e7ene\u011fine t\u0131klayal\u0131m.<\/p>\n<p>Ard\u0131ndan kar\u015f\u0131m\u0131za gelen se\u00e7eneklerden \u2018ORTALAMA\u2019 se\u00e7ene\u011fini se\u00e7elim ve \u2018Tamam\u2019 butonuna t\u0131klayal\u0131m.<\/p>\n<p>Sonras\u0131nda a\u00e7\u0131lan pencerede sizden say\u0131lar istenecektir. Burada ortalamas\u0131n\u0131 bulmak istedi\u011finiz say\u0131lar\u0131 girdikten sonra \u2018Tamam\u2019 butonuna bast\u0131\u011f\u0131n\u0131zda \u201c=\u201d i\u015fareti koydu\u011funuz h\u00fccrede sonucu g\u00f6rebilirsiniz.<\/p>\n<p>Bu form\u00fcl\u00fc elle yazmak i\u00e7in sonucu g\u00f6rmek istedi\u011finiz h\u00fccreye \u201cORTALAMA(D1:D7)\u201d yazabilirsiniz. Bu durumda D1 ve D7 h\u00fccreleri aras\u0131ndaki say\u0131lar\u0131n ortalamas\u0131 size g\u00f6sterilecektir.<\/p>\n<p>E\u011fer form\u00fclde \u201c:\u201d yerine \u201c;\u201d kullan\u0131rsan\u0131z, yani \u201cORTALAMA(D1;D7) yazarsan\u0131z, bu durumda sadece belirtti\u011finiz h\u00fccrelerdeki de\u011ferlerin ortalamas\u0131n\u0131 g\u00f6rebilirsiniz.<\/p>\n<h3><strong>=TOPLA (SUM) Form\u00fcl\u00fc<\/strong><\/h3>\n<p><strong>Microsoft Excel form\u00fclleri<\/strong> aras\u0131nda bulunan <strong>SUM form\u00fcl\u00fc<\/strong> sayesinde istedi\u011finiz say\u0131lar\u0131 toplayabilir veya kendiniz se\u00e7ti\u011finiz h\u00fccrelerdeki say\u0131lar\u0131 toplayabilirsiniz. K\u0131sacas\u0131 bu form\u00fcl say\u0131lar\u0131 toplaman\u0131za yarar.<\/p>\n<h4><strong>Form\u00fcl Kullan\u0131m\u0131<\/strong><\/h4>\n<p>Sonucu g\u00f6rmek istedi\u011fini h\u00fccreye &#8220;=&#8221; girerek \u00fcstteki &#8216;Form\u00fcller&#8217; sekmesine t\u0131klay\u0131n.<\/p>\n<p>Ard\u0131ndan &#8216;\u0130\u015flev Ekle&#8217; se\u00e7ene\u011fine t\u0131klayarak a\u00e7\u0131lan pencereden &#8216;TOPLA&#8217; form\u00fcl\u00fcn\u00fc se\u00e7in ve &#8216;Tamam&#8217; butonuna t\u0131klay\u0131n.<\/p>\n<p>Sonras\u0131nda a\u00e7\u0131lan pencerede toplamak istedi\u011finiz say\u0131lar\u0131 girerek &#8216;Tamam&#8217; butonuna bast\u0131\u011f\u0131n\u0131zda belirtti\u011finiz h\u00fccrede sonucu g\u00f6rebilirsiniz.<\/p>\n<p>Form\u00fcl\u00fc elle yazmak i\u00e7in &#8220;=TOPLA(D1:D7) yazabilirsiniz. Bu durumda D1 ve D7 h\u00fccreleri aras\u0131nda bulunan say\u0131lar toplan\u0131r ve form\u00fcl\u00fc yazd\u0131\u011f\u0131n\u0131z h\u00fccrede sonu\u00e7 g\u00f6sterilir.<\/p>\n<p>E\u011fer &#8220;:&#8221; yerine &#8220;;&#8221; kullan\u0131rsan\u0131z yani form\u00fcl\u00fc &#8220;=TOPLA(D1;D7) \u015feklinde yazarsan\u0131z, sadece belirtilen h\u00fccrelerdeki say\u0131lar toplan\u0131r.<\/p>\n<h3><strong>=E\u011eER (IF) Form\u00fcl\u00fc<\/strong><\/h3>\n<p><strong>Microsoft Excel form\u00fclleri<\/strong> aras\u0131nda bulunan <strong>IF form\u00fcl\u00fc<\/strong> sayesinde <strong>\u015fart ifadesi olu\u015fturabilirsiniz<\/strong>. B\u00f6ylece ilgili h\u00fccredeki ko\u015fula g\u00f6re yan\u0131t olu\u015fturabilirsiniz.<\/p>\n<h4><strong>Form\u00fcl Kullan\u0131m\u0131<\/strong><\/h4>\n<p>Bu k\u0131s\u0131mda bir \u00f6\u011frencinin s\u0131nav notuyla ilgili bir \u00f6rneklendirme yapmak istiyoruz. E\u011fer \u00f6\u011frenci s\u0131navdan 70 veya \u00fcst\u00fc bir not ald\u0131ysa ba\u015far\u0131l\u0131, 70&#8217;in alt\u0131nda bir not ald\u0131ysa ba\u015far\u0131s\u0131z say\u0131lacak.<\/p>\n<p>Form\u00fcl\u00fc kullanmak i\u00e7in sonucu g\u00f6rmek istedi\u011finiz h\u00fccreye &#8220;=E\u011eER(A22&lt;70;&#8221;BA\u015eARISIZ&#8221;;&#8221;BA\u015eARILI&#8221;)&#8221; form\u00fcl\u00fcn\u00fc yaz\u0131n. Bu form\u00fclde &#8220;A22&#8221; yazd\u0131\u011f\u0131 i\u00e7in &#8220;A22&#8221; h\u00fccresine s\u0131nav notunu girmelisiniz. E\u011fer notu farkl\u0131 bir h\u00fccreye \u00f6rne\u011fin &#8220;D1&#8221; h\u00fccresine girmek istiyorsan\u0131z, bu durumda form\u00fclde &#8220;A22&#8221; yerine &#8220;D1&#8221; yazmal\u0131s\u0131n\u0131z.<\/p>\n<p>Daha sonra form\u00fclde belirtti\u011finiz h\u00fccreye (bizim \u00f6rne\u011fimizde &#8220;A22&#8221; h\u00fccresi) s\u0131nav notunu yazd\u0131\u011f\u0131n\u0131zda form\u00fcl\u00fc yazd\u0131\u011f\u0131n\u0131z h\u00fccrede nota g\u00f6re sonu\u00e7 yazacakt\u0131r. Yani s\u0131nav notu 70&#8217;in alt\u0131ndaysa form\u00fcl\u00fc yazd\u0131\u011f\u0131n\u0131z h\u00fccrede &#8220;BA\u015eARISIZ&#8221;, 70 ve \u00fcst\u00fcndeyse &#8220;BA\u015eARILI&#8221; yazacakt\u0131r.<\/p>\n<h3><strong>=B\u0130RLE\u015eT\u0130R (CONCATENATE) Form\u00fcl\u00fc<\/strong><\/h3>\n<p><strong>Microsoft Excel Form\u00fclleri<\/strong> aras\u0131nda bulunan <strong>B\u0130RLE\u015eT\u0130R form\u00fcl\u00fc<\/strong> sayesinde h\u00fccrelerdeki verileri birle\u015ftirebilirsiniz.<\/p>\n<h4><strong>Form\u00fcl Kullan\u0131m\u0131<\/strong><\/h4>\n<p>Sonucu g\u00f6rmek istedi\u011finiz h\u00fccreye &#8220;=B\u0130RLE\u015eT\u0130R(B5:B12)&#8221; yaz\u0131n. Bu form\u00fcl\u00fc yazd\u0131\u011f\u0131n\u0131zda B5 ve B12 h\u00fccrelerindeki veriler birle\u015ftirilecek ve form\u00fcl\u00fc yazd\u0131\u011f\u0131n\u0131z h\u00fccrede size g\u00f6sterilecektir.<\/p>\n<h3><strong>=YUVARLA (ROUND) Form\u00fcl\u00fc<\/strong><\/h3>\n<p><strong>YUVARLA komutu<\/strong> sayesinde tam say\u0131 olmayan rakamlar\u0131 a\u015fa\u011f\u0131 veya yukar\u0131 yuvarlama yapabilirsiniz.<\/p>\n<h4><strong>Form\u00fcl Kullan\u0131m\u0131<\/strong><\/h4>\n<p>Bu form\u00fcl &#8220;YUVARLA&#8221;, &#8220;YUKARIYUVARLA&#8221; ve &#8220;A\u015eA\u011eIYUVARLA&#8221; gibi komutlarla kullan\u0131l\u0131r.<\/p>\n<p>Bu komutu kullanmak i\u00e7in sonucu g\u00f6rmek istedi\u011finiz h\u00fccreye &#8220;YUVARLA(A4;0)&#8221; yazabilirsiniz. Bu komuttaki &#8220;A4&#8221; k\u0131sm\u0131 yuvarlamak istedi\u011finiz say\u0131y\u0131 girece\u011finiz h\u00fccreyi ifade ediyor. &#8220;A4&#8221; k\u0131sm\u0131ndan hemen sonraki &#8220;0&#8221; ise ka\u00e7\u0131nc\u0131 basama\u011f\u0131n i\u015fleme al\u0131naca\u011f\u0131 ifade ediliyor. Yani &#8220;YUVARLA(A4;0)&#8221; yazd\u0131\u011f\u0131n\u0131zda virg\u00fclden \u00f6nceki en yak\u0131n say\u0131ya yuvarlama yap\u0131lacakt\u0131r.<\/p>\n<p>E\u011fer say\u0131y\u0131 belirli bir tarafa do\u011fru yuvarlamak istiyorsan\u0131z, bu durumda di\u011fer komutlar\u0131 kullanmal\u0131s\u0131n\u0131z. Yani say\u0131y\u0131 yukar\u0131 yuvarlamak i\u00e7in komuttaki &#8220;YUVARLA&#8221; yerine &#8220;YUKARIYUVARLA&#8221; yazabilirsiniz. Say\u0131y\u0131 a\u015fa\u011f\u0131 yuvarlamak i\u00e7in ise yine komuttaki &#8220;YUVARLA&#8221; yerine &#8220;A\u015eA\u011eIYUVARLA&#8221; yazman\u0131z yeterli olacakt\u0131r.<\/p>\n<h3><strong>=\u015e\u0130MD\u0130 (NOW) Form\u00fcl\u00fc<\/strong><\/h3>\n<p><strong>Microsoft Excel form\u00fclleri<\/strong> aras\u0131nda bulunan <strong>\u015e\u0130MD\u0130 form\u00fcl\u00fc<\/strong> sayesinde an\u0131n tarihini ve saatini g\u00f6rebilirsiniz.<\/p>\n<h4><strong>Form\u00fcl Kullan\u0131m\u0131<\/strong><\/h4>\n<p>Bunun i\u00e7in sonucu g\u00f6rmek istedi\u011finiz h\u00fccreye =\u015e\u0130MD\u0130() yazarak Enter tu\u015funa basman\u0131z yeterli. Bu ad\u0131m\u0131n ard\u0131ndan form\u00fcl\u00fc yazd\u0131\u011f\u0131n\u0131z h\u00fccrede o an\u0131n tarihi ve saati g\u00f6z\u00fckecektir. Ancak e\u011fer mevcut tarihten farkl\u0131 bir tarihe ula\u015fmak istiyorsan\u0131z, form\u00fcle birka\u00e7 ekleme yapman\u0131z gerekiyor. \u00d6rne\u011fin, mevcut tarihten 7 g\u00fcn \u00f6ncesine ula\u015fmak i\u00e7in sonucu g\u00f6rmek istedi\u011finiz h\u00fccreye &#8220;=\u015e\u0130MD\u0130()-7&#8221; yazarak Enter tu\u015funa basabilirsiniz.<\/p>\n<h3><strong>=K\u00dc\u00c7\u00dcKHARF (LOWER) Form\u00fcl\u00fc<\/strong><\/h3>\n<p>Bu form\u00fcl sayesinde bir h\u00fccredeki t\u00fcm harfleri vs. b\u00fcy\u00fckten k\u00fc\u00e7\u00fc\u011fe \u00e7evirebilmeniz m\u00fcmk\u00fcn. \u00d6rne\u011fin, bir tablodaki harflerin tamam\u0131n\u0131 k\u00fc\u00e7\u00fcltmek istiyorsan\u0131z bu form\u00fcl\u00fc kullanabilirsiniz.<\/p>\n<h4><strong>Form\u00fcl Kullan\u0131m\u0131<\/strong><\/h4>\n<p>Form\u00fcl\u00fcn kullan\u0131m\u0131 i\u00e7in sonucu g\u00f6rmek istedi\u011finiz h\u00fccreye &#8220;=K\u00dc\u00c7\u00dcKHARF(D4)&#8221; yazabilirsiniz. Form\u00fcl\u00fcn i\u00e7erisinde &#8220;D4&#8221; yazd\u0131\u011f\u0131 i\u00e7in tamam\u0131n\u0131 k\u00fc\u00e7\u00fck harfe \u00e7evirmek istedi\u011finiz yaz\u0131y\u0131 &#8220;D4&#8221; h\u00fccresine yazmal\u0131s\u0131n\u0131z. Daha sonra t\u00fcm harfler istedi\u011finiz gibi k\u00fc\u00e7\u00fclt\u00fclecektir.<\/p>\n<h3><strong>=B\u00dcY\u00dcKHARF (UPPER) Form\u00fcl\u00fc<\/strong><\/h3>\n<p><strong>B\u00dcY\u00dcKHARF<\/strong> form\u00fcl\u00fcyse <strong>K\u00dc\u00c7\u00dcKHARF<\/strong> form\u00fcl\u00fcn\u00fcn aksine belirtti\u011finiz h\u00fccredeki t\u00fcm harfleri vs. b\u00fcy\u00fcltmeye yarar. Yani bu form\u00fcl\u00fc de harflerin tamam\u0131n\u0131 b\u00fcy\u00fck yapmak i\u00e7in kullanabilirsiniz.<\/p>\n<h4><strong>Form\u00fcl Kullan\u0131m\u0131<\/strong><\/h4>\n<p>B\u00dcY\u00dcKHARF form\u00fcl\u00fcn\u00fc kullanmak i\u00e7in sonucu g\u00f6rmek istedi\u011finiz h\u00fccreye &#8220;=B\u00dcY\u00dcKHARF(D4)&#8221; yazmal\u0131s\u0131n\u0131z. Form\u00fclde h\u00fccre olarak &#8220;D4&#8221; belirti\u011fi i\u00e7in tamam\u0131n\u0131 b\u00fcy\u00fck harfe \u00e7evirmek istedi\u011finiz yaz\u0131y\u0131 &#8220;D4&#8221; h\u00fccresine yazman\u0131z gerekiyor. Bu h\u00fccreye herhangi bir yaz\u0131 yazd\u0131\u011f\u0131n\u0131zda, yaz\u0131 form\u00fcl\u00fc yazd\u0131\u011f\u0131n\u0131z h\u00fccrede tamam\u0131 b\u00fcy\u00fck olarak size g\u00f6sterilecektir.<\/p>\n<h3><strong>=BA\u011e_DE\u011e_DOLU_SAY (COUNTA) Form\u00fcl\u00fc<\/strong><\/h3>\n<p><strong>BA\u011e_DE\u011e_DOLU_SAY form\u00fcl\u00fc<\/strong> sayesinde, Excel&#8217;de belirli aral\u0131ktaki h\u00fccrelerin ka\u00e7 tanesinde veri oldu\u011funu \u00f6\u011frenebilirsiniz. \u00d6rne\u011fin, yukar\u0131dan a\u015fa\u011f\u0131ya ufak bir tablo olu\u015fturdu\u011funuzu ve tablonun &#8220;A1&#8221; h\u00fccresinden &#8220;A10&#8221; h\u00fccresine kadar oldu\u011funu varsayal\u0131m.<\/p>\n<p>Ancak tablodaki baz\u0131 h\u00fccrelerin bo\u015f olduklar\u0131n\u0131 hayal edelim. \u0130\u015fte bu durumda BA\u011e_DE\u011e_DOLU_SAY form\u00fcl\u00fc sayesinde ka\u00e7 tane h\u00fccrede veri bulundu\u011funu \u00f6\u011frenebilirsiniz. \u00d6rne\u011fin, bu form\u00fcl\u00fc kullanarak bir tablodaki ka\u00e7 ki\u015finin borcunu \u00f6dedi\u011fini, ka\u00e7 ki\u015finin \u00f6demedi\u011fini k\u0131sa yoldan h\u0131zl\u0131ca \u00f6\u011frenebilirsiniz.<\/p>\n<h4><strong>Form\u00fcl Kullan\u0131m\u0131<\/strong><\/h4>\n<p>Form\u00fcl\u00fcn kullan\u0131m\u0131 i\u00e7in sonucu g\u00f6rmek istedi\u011finiz h\u00fccreye &#8220;=BA\u011e_DE\u011e_DOLU_SAY(A1:A10) yazman\u0131z gerekiyor. Form\u00fclde &#8220;A1:A10&#8221; yazd\u0131\u011f\u0131 i\u00e7in &#8220;A1&#8221; ve &#8220;A10&#8221; h\u00fccreleri aras\u0131nda ka\u00e7 adet veri i\u00e7eren h\u00fccrenin oldu\u011fu sonu\u00e7 olarak size g\u00f6sterilecektir. Bu y\u00fczden form\u00fcldeki h\u00fccreleri verileri girdi\u011finiz h\u00fccrelere g\u00f6re istedi\u011finiz gibi d\u00fczenleyebilirsiniz.<\/p>\n<h3><strong>=KIRP Form\u00fcl\u00fc<\/strong><\/h3>\n<p><strong>KIRP form\u00fcl\u00fc<\/strong> sayesinde, bir h\u00fccrede bulunan kelimelerin ba\u015f\u0131ndaki ve sonundaki bo\u015fluklar\u0131 silebilirsiniz. Yani bu form\u00fcl\u00fcn bo\u015fluk silme gibi olduk\u00e7a basit bir i\u015flevi var.<\/p>\n<h4><strong>Form\u00fcl Kullan\u0131m\u0131<\/strong><\/h4>\n<p>KIRP form\u00fcl\u00fcn\u00fc kullanmak i\u00e7in sonucun g\u00f6sterilece\u011fi h\u00fccreye &#8220;=KIRP(D1)&#8221; yaz\u0131n. Sonras\u0131nda form\u00fclde &#8220;D1&#8221; h\u00fccresi hedef g\u00f6sterildi\u011fi i\u00e7in &#8220;D1&#8221; h\u00fccresine yazd\u0131\u011f\u0131n\u0131z kelimelerin ba\u015f\u0131ndaki ve sonundaki bo\u015fluklar silinerek sonu\u00e7 h\u00fccresinde g\u00f6sterilecektir.<\/p>\n<h3><strong>=E\u011eERSAY Form\u00fcl\u00fc\u00a0<\/strong><\/h3>\n<p><strong>E\u011eERSAY form\u00fcl\u00fc<\/strong> sayesinde belirli h\u00fccrelerin aras\u0131nda \u00f6zel bir kelimeyi vs. bulabilirsiniz. \u00d6rne\u011fin, C1 h\u00fccresinden C8 h\u00fccresine kadar bir sebze tablosu olu\u015fturdu\u011fumuzu varsayal\u0131m. Bu sebze tablosunun i\u00e7inden p\u0131rasalar\u0131 bulmak istedi\u011fimizde bu form\u00fcl\u00fc kullanabiliriz.<\/p>\n<h4><strong>Form\u00fcl Kullan\u0131m\u0131<\/strong><\/h4>\n<p>E\u011eERSAY form\u00fcl\u00fcn\u00fc kullanmak i\u00e7in sonucu g\u00f6rmek istedi\u011finiz h\u00fccreye =E\u011eERSAY(C1:C8;&#8221;P\u0131rasa&#8221;) yazman\u0131z gerekiyor. Form\u00fcle &#8220;C1&#8221; ve &#8220;C8&#8221; yazd\u0131\u011f\u0131n\u0131z i\u00e7in bu h\u00fccreler aras\u0131nda &#8220;P\u0131rasa&#8221; kelimesi aran\u0131yor. Daha sonra aratt\u0131\u011f\u0131n\u0131z kelimenin ka\u00e7 tane oldu\u011fu form\u00fcl\u00fc yazd\u0131\u011f\u0131n\u0131z h\u00fccrede sonu\u00e7 olarak g\u00f6steriliyor. \u00d6rne\u011fin, &#8220;C1&#8221; ve &#8220;C8&#8221; h\u00fccreleri aras\u0131nda 4 tane &#8220;P\u0131rasa&#8221; kelimesi varsa form\u00fcl\u00fc yazd\u0131\u011f\u0131n\u0131z h\u00fccrede size sonu\u00e7 olarak 4 g\u00f6steriliyor.<\/p>\n<h3><strong>=UZUNLUK Form\u00fcl\u00fc<\/strong><\/h3>\n<p><strong>UZUNLUK form\u00fcl\u00fc<\/strong> sayesinde bir h\u00fccredeki metinlerin veya say\u0131sal verilerin ka\u00e7 karakterden olu\u015ftuklar\u0131n\u0131 bulabilmeniz m\u00fcmk\u00fcn. \u00d6rne\u011fin, bir h\u00fccrede yazan &#8220;uzun&#8221; kelimesinin 4 karakterden olu\u015ftu\u011funu bu form\u00fcl sayesinde h\u0131zl\u0131ca bulabilirsiniz.<\/p>\n<h4><strong>Form\u00fcl Kullan\u0131m\u0131<\/strong><\/h4>\n<p>Form\u00fcl\u00fc kullanmak i\u00e7in sonucu g\u00f6r\u00fcnt\u00fclemek istedi\u011finiz h\u00fccreye &#8220;=UZUNLUK(A5)&#8221; yaz\u0131n. Bizim \u00f6rne\u011fimizdeki form\u00fclde &#8220;A5&#8221; yazd\u0131\u011f\u0131 i\u00e7in &#8220;A5&#8221; h\u00fccresine karakter say\u0131s\u0131n\u0131 bulmak istedi\u011fini metini veya say\u0131sal veriyi girmeniz gerekiyor. Form\u00fclde belirtti\u011finiz h\u00fccreye gerekli verileri girdikten sonra form\u00fcl\u00fc yazd\u0131\u011f\u0131n\u0131z h\u00fccrede girdi\u011finiz verinin ka\u00e7 karakterden olu\u015ftu\u011funu g\u00f6rebilirsiniz.<\/p>\n<h3><strong>=\u00c7ARPIM Form\u00fcl\u00fc<\/strong><\/h3>\n<p>\u00c7ARPIM form\u00fcl\u00fcn\u00fc kullanarak Excel&#8217;de \u00e7arpma i\u015flemlerinizi ger\u00e7ekle\u015ftirebilirsiniz. Bu form\u00fcl Excel&#8217;in en basit form\u00fclleri aras\u0131nda g\u00f6sterilebilir<\/p>\n<h4><strong>Form\u00fcl Kullan\u0131m\u0131<\/strong><\/h4>\n<p>\u00c7ARPIM form\u00fcl\u00fcn\u00fc kullanmak i\u00e7in sonucu g\u00f6rmek istedi\u011finiz h\u00fccreye &#8220;=\u00c7ARPIM(C1:C4)&#8221; yazabilirsiniz. Form\u00fcl\u00fc bu \u015fekilde yazd\u0131\u011f\u0131n\u0131zda Excel&#8217;de C1 ve C4 h\u00fccrelerine yazd\u0131\u011f\u0131n\u0131z say\u0131lar birbirleriyle \u00e7arp\u0131l\u0131r. Ard\u0131ndan \u00e7arp\u0131m\u0131n sonucu form\u00fcl\u00fc yazd\u0131\u011f\u0131n\u0131z h\u00fccrede size g\u00f6sterilir.<\/p>\n<h3><strong>=BA\u011e_DE\u011e_SAY Form\u00fcl\u00fc<\/strong><\/h3>\n<p><strong>Microsoft Excel form\u00fclleri<\/strong> aras\u0131nda bulunan <strong>BA\u011e_DE\u011e_SAY form\u00fcl\u00fc<\/strong>, belirtilen aral\u0131ktaki h\u00fccrelerin ka\u00e7\u0131nda say\u0131sal de\u011fer oldu\u011funu bulmak i\u00e7in kullan\u0131labilir. \u00d6rne\u011fin, E1 ile E7 h\u00fccreleri aras\u0131nda 3 tane h\u00fccreye sadece say\u0131sal veriler girdi\u011finizi varsayal\u0131m.<\/p>\n<p>\u0130\u015fte bu form\u00fclle E1 ile E7 h\u00fccrelerinin aral\u0131\u011f\u0131n\u0131 kontrol etti\u011finizde kar\u015f\u0131n\u0131za sonu\u00e7 olarak &#8220;3&#8221; \u00e7\u0131kacakt\u0131r. Ancak bu form\u00fclde bo\u015f h\u00fccrelerin ve say\u0131 hari\u00e7 veri girilen h\u00fccrelerin say\u0131lmad\u0131\u011f\u0131n\u0131 belirtelim. Yani form\u00fclle E1 ve E7 h\u00fccrelerinin aral\u0131\u011f\u0131n\u0131 kontrol etti\u011finizde, form\u00fcl bo\u015f h\u00fccreleri ve say\u0131lar hari\u00e7 (kelime vb.) veriler bulunan h\u00fccreleri saymaz.<\/p>\n<h4><strong>Form\u00fcl Kullan\u0131m\u0131<\/strong><\/h4>\n<p>BA\u011e_DA\u011e_SAY form\u00fcl\u00fcn\u00fc kullanmak i\u00e7in sonucun g\u00f6sterilece\u011fi h\u00fccreye &#8220;=BA\u011e_DA\u011e_SAY(E1:E7)&#8221; yaz\u0131n. Form\u00fclde &#8220;E1:E7&#8221; yazd\u0131\u011f\u0131 i\u00e7in E1 ile E7 h\u00fccrelerinin aral\u0131\u011f\u0131ndaki say\u0131sal veriler say\u0131lacak ve sonu\u00e7 form\u00fcl\u00fc yazd\u0131\u011f\u0131n\u0131z h\u00fccrede size g\u00f6sterilecektir.<\/p>\n<h3><strong>=SOLDAN, =SA\u011eDAN ve =PAR\u00c7AAL Form\u00fclleri<\/strong><\/h3>\n<p><strong>SOLDAN<\/strong>, <strong>SA\u011eDAN<\/strong> ve <strong>PAR\u00c7AAL<\/strong> form\u00fclleri, basit\u00e7e a\u00e7\u0131klamam\u0131z gerekirse bir h\u00fccredeki belirtti\u011finiz karakterleri o h\u00fccreden alman\u0131za olanak tan\u0131r. \u00d6rne\u011fin, A1 h\u00fccresinde &#8220;Londra 123&#8221; yazd\u0131\u011f\u0131n\u0131 farz edelim. SOLDAN form\u00fcl\u00fcn\u00fc kullanarak A1 h\u00fccresindeki veriden sadece &#8220;Londra&#8221; k\u0131sm\u0131n\u0131 alabilir ve form\u00fcl\u00fc yazd\u0131\u011f\u0131 h\u00fccrede sonucu g\u00f6r\u00fcnt\u00fcleyebilirsiniz.<\/p>\n<h4><strong>Form\u00fcllerin Kullan\u0131m\u0131<\/strong><\/h4>\n<p>Bu k\u0131s\u0131mda ilk olarak <strong>Microsoft Excel form\u00fclleri<\/strong> aras\u0131nda bulunan SOLDAN ve SA\u011eDAN form\u00fcllerini \u00f6rnek verelim. A1 h\u00fccresinde &#8220;Londra 123&#8221; yazd\u0131\u011f\u0131n\u0131 farz edelim ve bizim &#8220;Londra&#8221; k\u0131sm\u0131n\u0131 bu veriden almak istedi\u011fimizi varsayal\u0131m. Bu durumda sonucu g\u00f6rmek istedi\u011fimiz h\u00fccreye &#8220;=SOLDAN(A1;6)&#8221; yazmam\u0131z gerekiyor. Form\u00fcl\u00fcn anlam\u0131, &#8220;A1&#8221; h\u00fccresindeki verinin sol taraf\u0131ndaki &#8220;6&#8221; karakteri al demek oluyor. B\u00f6ylece form\u00fcl\u00fc bu \u015fekilde yazd\u0131\u011f\u0131n\u0131zda, form\u00fcl\u00fc yazd\u0131\u011f\u0131n\u0131z h\u00fccrede kar\u015f\u0131n\u0131za &#8220;Londra&#8221; diye bir sonu\u00e7 \u00e7\u0131k\u0131yor.<\/p>\n<p>Sa\u011fdaki k\u0131sm\u0131 yani &#8220;123&#8221; k\u0131sm\u0131n\u0131 almak i\u00e7inse sonucu g\u00f6rmek istedi\u011finiz h\u00fccreye &#8220;=SA\u011eDAN(A1:3)&#8221; yazman\u0131z gerekiyor. Bu form\u00fcl\u00fcn anlam\u0131ysa, &#8220;A1&#8221; h\u00fccresinin sa\u011f k\u0131sm\u0131ndaki &#8220;3&#8221; karakteri al demek oluyor. B\u00f6ylece &#8220;A1&#8221; h\u00fccresindeki &#8220;Londra 123&#8221; verisinden sadece &#8220;123&#8221; k\u0131sm\u0131 form\u00fcl\u00fc yazd\u0131\u011f\u0131n\u0131z h\u00fccrede size sonu\u00e7 olarak g\u00f6steriliyor.<\/p>\n<p>PAR\u00c7AAL form\u00fcl\u00fcndeyse veriyi ka\u00e7\u0131nc\u0131 karakterden itibaren ve ka\u00e7 karakter alaca\u011f\u0131n\u0131z\u0131 siz belirliyorsunuz. \u00d6rne\u011fin, bu kez &#8220;A1&#8221; h\u00fccresinde &#8220;Londra123&#8221; yazd\u0131\u011f\u0131n\u0131 varsayal\u0131m. Sizin bu h\u00fccreden sadece &#8220;Lon&#8221; k\u0131sm\u0131n\u0131 almak istedi\u011finizi farz edelim. Bu durumda sonucu g\u00f6rmek istedi\u011finiz h\u00fccreye &#8220;=PAR\u00c7AAL(A1;1;3)&#8221; yazman\u0131z gerekiyor.<\/p>\n<p>Bu form\u00fclde &#8220;A1&#8221; veriyi almak istedi\u011finiz h\u00fccre, &#8220;1&#8221; veriyi ka\u00e7\u0131nc\u0131 karakterden itibaren almak istedi\u011finiz, &#8220;3&#8221; ise veriden ka\u00e7 karakter almak istedi\u011finiz oluyor. Yani yaz\u0131m\u0131zdaki form\u00fcl\u00fc yazd\u0131\u011f\u0131n\u0131zda &#8220;A1&#8221; h\u00fccresindeki verinin 1. karakterinden ba\u015flayarak toplam 3 karakterini alm\u0131\u015f oluyorsunuz. Daha sonra form\u00fcl\u00fc yazd\u0131\u011f\u0131n\u0131z h\u00fccrede sonu\u00e7 &#8220;Lon&#8221;\u00a0 olarak kar\u015f\u0131n\u0131za \u00e7\u0131k\u0131yor.<\/p>\n<h3><strong>=DE\u011e\u0130\u015eT\u0130R Form\u00fcl\u00fc<\/strong><\/h3>\n<p><strong>Microsoft Excel Form\u00fclleri<\/strong> aras\u0131nda bulunan <strong>DE\u011e\u0130\u015eT\u0130R<\/strong> form\u00fcl\u00fcn\u00fc kullanarak bir h\u00fccredeki veriyi farkl\u0131 bir veriyle de\u011fi\u015ftirebilirsiniz. Ancak bu form\u00fcl\u00fc kullan\u0131rken veriyi ka\u00e7\u0131nc\u0131 karakterden itibaren de\u011fi\u015ftirmek istedi\u011finizi ve verideki ka\u00e7 karakteri de\u011fi\u015ftirece\u011finizi belirtmeniz gerekiyor.<\/p>\n<h4><strong>Form\u00fcl Kullan\u0131m\u0131<\/strong><\/h4>\n<p>DE\u011e\u0130\u015eT\u0130R form\u00fcl\u00fcn\u00fcn kullan\u0131m\u0131n\u0131 daha iyi anlayabilmeniz i\u00e7in size bu k\u0131s\u0131mda bir \u00f6rneklendirmek yapmak istiyoruz. \u00d6rne\u011fin, D1 h\u00fccresinde &#8220;<a href=\"https:\/\/www.hostixo.com\/\" data-internallinksmanager029f6b8e52c=\"10\" title=\"hostixo\">hostixo<\/a>.com\/<a href=\"https:\/\/www.hostixo.com\/hosting\/\" data-internallinksmanager029f6b8e52c=\"1\" title=\"hosting paketleri\">hosting<\/a>&#8221; yazd\u0131\u011f\u0131n\u0131 ve sizin bu yaz\u0131y\u0131 &#8220;hostixo.com\/blog&#8221; olarak de\u011fi\u015ftirmek istedi\u011finizi varsayal\u0131m. Bu durumda sonucu g\u00f6rmek istedi\u011finiz h\u00fccreye &#8220;=DE\u011e\u0130\u015eT\u0130R(D1;13;7;&#8221;blog&#8221;)&#8221; yazman\u0131z gerekiyor.<\/p>\n<p>Bu form\u00fclde &#8220;D1&#8221;, de\u011fi\u015ftirilecek verinin bulundu\u011fu h\u00fccreyi ifade ediyor. &#8220;13&#8221; ise verinin ka\u00e7\u0131nc\u0131 karakterden itibaren de\u011fi\u015ftirilece\u011fini ifade ediyor. Form\u00fcldeki &#8220;7&#8221; de\u011feriyse verideki ka\u00e7 karakterin de\u011fi\u015ftirilece\u011fini belirliyor. Son olarak, verideki &#8220;blog&#8221; k\u0131sm\u0131ysa de\u011fi\u015ftirilecek verinin yerine yaz\u0131lacak yeni veriyi ifade ediyor. Sonu\u00e7 olarak form\u00fcl\u00fc yazd\u0131\u011f\u0131n\u0131z h\u00fccrede kar\u015f\u0131n\u0131za &#8220;hostixo.com\/blog&#8221; \u00e7\u0131k\u0131yor.<\/p>\n<p>DE\u011e\u0130\u015eT\u0130R form\u00fcl\u00fcyle birlikte <strong>Microsoft Excel form\u00fclleri<\/strong> listemizin sonuna gelmi\u015f bulunuyoruz. Listemizde i\u015finize yarayacak bir\u00e7ok Microsoft Excel form\u00fcl\u00fcnden sizler i\u00e7in bahsetmeye \u00e7al\u0131\u015ft\u0131k. Listemizdeki form\u00fcller sayesinde Microsoft Excel&#8217;i \u00e7ok daha verimli \u015fekilde kullanabilece\u011finizi umuyoruz. E\u011fer listemizdeki form\u00fclleri do\u011fru \u015fekilde kullan\u0131rsan\u0131z, Excel \u00fczerinde bir\u00e7ok farkl\u0131 i\u015flemi rahatl\u0131kla ger\u00e7ekle\u015ftirebilirsiniz.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bir\u00e7ok Excel kullan\u0131c\u0131s\u0131, Microsoft Excel form\u00fclleri hakk\u0131nda fikir sahibi olamayabiliyor. Ancak bu form\u00fcller asl\u0131nda Excel\u2019in kullan\u0131m\u0131n\u0131 \u00e7ok farkl\u0131 bir boyuta ta\u015f\u0131yabiliyorlar. Bizim amac\u0131m\u0131zda yaz\u0131m\u0131zda sizleri bu form\u00fcller hakk\u0131nda bilgi sahibi yapabilmek. Microsoft Excel, y\u0131llard\u0131r bir\u00e7ok farkl\u0131 ama\u00e7la kullan\u0131labilen bir program. Microsoft Office uygulamalar\u0131 aras\u0131nda yer alan bu program, normal \u015fartlarda olduk\u00e7a basit bir kullan\u0131ma sahip. &hellip;<\/p>\n","protected":false},"author":1,"featured_media":4702,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_mbp_gutenberg_autopost":false,"footnotes":""},"categories":[33,1],"tags":[],"class_list":["post-4698","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-diger","category-genel"],"_links":{"self":[{"href":"https:\/\/www.hostixo.com\/blog\/wp-json\/wp\/v2\/posts\/4698","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostixo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostixo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostixo.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostixo.com\/blog\/wp-json\/wp\/v2\/comments?post=4698"}],"version-history":[{"count":0,"href":"https:\/\/www.hostixo.com\/blog\/wp-json\/wp\/v2\/posts\/4698\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.hostixo.com\/blog\/wp-json\/wp\/v2\/media\/4702"}],"wp:attachment":[{"href":"https:\/\/www.hostixo.com\/blog\/wp-json\/wp\/v2\/media?parent=4698"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostixo.com\/blog\/wp-json\/wp\/v2\/categories?post=4698"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostixo.com\/blog\/wp-json\/wp\/v2\/tags?post=4698"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}