{"id":1496,"date":"2023-11-20T14:34:55","date_gmt":"2023-11-20T14:34:55","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/excel-fonksiyonlari\/"},"modified":"2023-12-10T05:59:28","modified_gmt":"2023-12-10T05:59:28","slug":"excel-fonksiyonlari","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/excel-fonksiyonlari\/","title":{"rendered":"En \u00f6nemli 10 excel i\u0307\u015flevi"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-525575431\"><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> <div class=\"gb-container gb-container-3b8286e6\"><h2 id=\"10-if-function\" class=\"wp-block-heading\"> 1. E\u011eER i\u015flevi<\/h2><p> <strong>IF Fonksiyonu, belirtti\u011finiz ko\u015ful DO\u011eRU ise bir de\u011fer d\u00f6nd\u00fcr\u00fcr, aksi takdirde ba\u015fka bir de\u011fer d\u00f6nd\u00fcr\u00fcr.<\/strong> Basit\u00e7e s\u00f6ylemek gerekirse, IF i\u015flevi \u00f6nce bir ko\u015fulu test edebilir ve bu ko\u015fulun sonucuna g\u00f6re bir de\u011fer d\u00f6nd\u00fcrebilir.<\/p><h3 id=\"11-syntax-\" class=\"wp-block-heading\"> S\u00f6zdizimi<\/h3><p> E\u011eER(mant\u0131ksal_test, e\u011fer_do\u011fruysa_de\u011fer, e\u011fer_yanl\u0131\u015fsa_de\u011fer)<\/p><h3 id=\"12-arguments-\" class=\"wp-block-heading\"> Arg\u00fcmanlar<\/h3><ul><li> <strong>mant\u0131ksal_test:<\/strong> De\u011ferlendirmek istedi\u011finiz ko\u015ful.<\/li><li> <strong>value_if_true:<\/strong> Bu ko\u015fulun DO\u011eRU olmas\u0131 durumunda almak istedi\u011finiz de\u011fer.<\/li><li> <strong>value_if_false:<\/strong> Bu ko\u015fulun YANLI\u015e olmas\u0131 durumunda almak istedi\u011finiz de\u011fer.<\/li><\/ul><h3 id=\"13-notes-\" class=\"wp-block-heading\"> Yorumlar<\/h3><ul><li> Ger\u00e7ekle\u015ftirebilece\u011finiz maksimum i\u00e7 i\u00e7e ko\u015ful say\u0131s\u0131 64&#8217;t\u00fcr.<\/li><li> Bir ko\u015fulu de\u011ferlendirmek i\u00e7in kar\u015f\u0131la\u015ft\u0131rma i\u015fle\u00e7lerini kullanabilirsiniz.<\/li><\/ul><h3 id=\"14-example\" class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte farkl\u0131 ko\u015fullar\u0131 de\u011ferlendirmek i\u00e7in bir kar\u015f\u0131la\u015ft\u0131rma operat\u00f6r\u00fc kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37036\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-si-fonction-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-if-fonksiyon-\u00f6rnek-1\" width=\"1274\" height=\"378\"><\/figure><\/div><ol><li> Ko\u015fulun kar\u015f\u0131lan\u0131p kar\u015f\u0131lanmad\u0131\u011f\u0131 sonucunu almak i\u00e7in belirli bir metin kulland\u0131k.<\/li><li> Sonucu elde etmek i\u00e7in DO\u011eRU ve YANLI\u015e&#8217;\u0131 da kullanabilirsiniz.<\/li><li> Sonucu almak i\u00e7in de\u011fer belirtmeyi atlarsan\u0131z, ko\u015ful DO\u011eRU ise s\u0131f\u0131r de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/li><li> Ve sonucu almak i\u00e7in bir de\u011fer belirtmeyi atlarsan\u0131z, ko\u015ful YANLI\u015e ise s\u0131f\u0131r de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/li><\/ol><p> A\u015fa\u011f\u0131daki \u00f6rnekte, i\u00e7 i\u00e7e ge\u00e7me form\u00fcl\u00fc olu\u015fturmak i\u00e7in IF i\u015flevini kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37037\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-si-fonction-exemple-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-if-fonksiyon-\u00f6rnek-2\" width=\"487\" height=\"385\"><\/figure><\/div><p> Bir ko\u015ful belirledik ve e\u011fer bu ko\u015ful yanl\u0131\u015fsa ba\u015fka bir ko\u015fulu de\u011ferlendirmek ve bir g\u00f6revi ger\u00e7ekle\u015ftirmek i\u00e7in ba\u015fka bir IF kulland\u0131k ve bu ko\u015ful YANLI\u015e ise ba\u015fka bir IF kulland\u0131k.<\/p><p> Bu \u015fekilde i\u00e7 i\u00e7e ge\u00e7me form\u00fcl\u00fc olu\u015fturmak i\u00e7in IF&#8217;yi be\u015f kez kulland\u0131k. Yuvalama form\u00fcl\u00fc i\u00e7in ayn\u0131 \u015feyi 64 kez kullanabilirsiniz. <\/p><\/div><div class=\"gb-container gb-container-94098a45\"><h2 id=\"15-iferror-function\" class=\"wp-block-heading\"> 2.E\u011eERHATA i\u015flevi<\/h2><p> <strong>E\u011eERHATA i\u015flevi, bir hata olu\u015ftu\u011funda belirli bir de\u011fer d\u00f6nd\u00fcr\u00fcr.<\/strong> Basit bir ifadeyle de\u011feri test edebilir ve e\u011fer bu de\u011fer bir hata ise belirtti\u011finiz de\u011feri d\u00f6nd\u00fcr\u00fcr.<\/p><h3 id=\"16-syntax-\" class=\"wp-block-heading\"> S\u00f6zdizimi<\/h3><p> <em>E\u011eERHATA(de\u011fer; hata_varsa_de\u011fer)<\/em><\/p><h3 id=\"17-arguments-\" class=\"wp-block-heading\"> Arg\u00fcmanlar<\/h3><ul><li> <strong>de\u011fer:<\/strong> Hata a\u00e7\u0131s\u0131ndan test etmek istedi\u011finiz de\u011fer.<\/li><li> <strong>value_if_error:<\/strong> Bir hata olu\u015ftu\u011funda geri almak istedi\u011finiz de\u011fer.<\/li><\/ul><h3 id=\"18-notes-\" class=\"wp-block-heading\"> Yorumlar<\/h3><ul><li> E\u011eERHATA i\u015flevi, hatan\u0131n t\u00fcr\u00fcyle de\u011fil, hatan\u0131n olu\u015fmas\u0131yla ilgilidir.<\/li><li> De\u011feri veya value_if_error&#8217;u yok sayarsan\u0131z sonu\u00e7ta 0 de\u011feri d\u00f6nd\u00fcr\u00fcl\u00fcr.<\/li><li> #YOK, #REF!, #B\u00d6L\/0!, #DE\u011eER!, #SAYI!, #\u0130S\u0130M? testlerini yapabilir. ve #BO\u015e!.<\/li><li> Bir diziyi de\u011ferlendirirseniz, belirtilen her \u00f6\u011fe i\u00e7in bir dizi sonu\u00e7 d\u00f6nd\u00fcr\u00fcr.<\/li><\/ul><h3 id=\"19-example\" class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte #B\u00d6L\/0! yerine E\u011eERHATA i\u015flevini kulland\u0131k. anlaml\u0131 bir metinle. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37041\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-excel-iferror-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-iferror-fonksiyon-\u00f6rnek-1\" width=\"441\" height=\"240\"><\/figure><\/div><p> E\u011eERHATA yaln\u0131zca 2007 ve \u00f6nceki s\u00fcr\u00fcmlerle uyumludur. Bu sorunu \u00e7\u00f6zmek i\u00e7in ISERROR komutunu kullanabilirsiniz. <\/p><\/div><div class=\"gb-container gb-container-01635ccf\"><h2 id=\"40-trunc-function\" class=\"wp-block-heading\">3.TRUNC i\u015flevi<\/h2><p> TRUNC i\u015flevi, <strong>orijinal say\u0131y\u0131 kestikten sonra bir tamsay\u0131 d\u00f6nd\u00fcr\u00fcr.<\/strong> Basit bir ifadeyle, bir say\u0131daki ondal\u0131k basamaklar\u0131 belirli bir hassasiyetle kald\u0131r\u0131r ve ard\u0131ndan sonucun tam say\u0131 k\u0131sm\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/p><h3 id=\"41-syntax-\" class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>TRUNC(say\u0131; [say\u0131_basamak])<\/em><\/p><h3 id=\"42-arguments-\" class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>say\u0131:<\/strong> Kesmek istedi\u011finiz say\u0131.<\/li><li> <strong>[num_digits]:<\/strong> Bir say\u0131y\u0131 kesme hassasiyetini belirten bir say\u0131.<\/li><\/ul><h3 id=\"43-notes-\" class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> Birden fazla belirtmeyi g\u00f6z ard\u0131 ederseniz bir hata d\u00f6nd\u00fcrecektir.<\/li><li> S\u0131f\u0131rdan yuvarlan\u0131r.<\/li><li> Ayn\u0131 mesafede iki kat\u0131n\u0131z varsa, yuvarlad\u0131\u011f\u0131n\u0131z say\u0131n\u0131n daha b\u00fcy\u00fck kat\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/li><\/ul><h3 id=\"44-example\" class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte, tarihlerden saati \u00e7\u0131karmak amac\u0131yla verileri k\u0131saltmak i\u00e7in TRUNC&#8217;u kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37359\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-tronc-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-trunc-fonksiyonu-\u00f6rnek-1\" width=\"395\" height=\"418\"><\/figure><\/div><\/div><div class=\"gb-container gb-container-8dc99f1c\"><h2 id=\"50-sumif-function\" class=\"wp-block-heading\">4. ETOPLA i\u015flevi<\/h2><p> ETOPLA i\u015flevi <strong>, belirtti\u011finiz ko\u015fulu kar\u015f\u0131layan say\u0131lar\u0131n toplam\u0131n\u0131<\/strong> d\u00f6nd\u00fcr\u00fcr. Basit bir ifadeyle, yaln\u0131zca ko\u015fulu sa\u011flayan de\u011ferlerin toplam\u0131n\u0131 dikkate al\u0131r ve hesaplar.<\/p><h3 id=\"51-syntax-\" class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>ETOPLA(aral\u0131k; \u00f6l\u00e7\u00fct; [toplam_aral\u0131k])<\/em><\/p><h3 id=\"52-arguments-\" class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>aral\u0131k:<\/strong> Kriterleri kontrol etmek istedi\u011finiz h\u00fccre aral\u0131\u011f\u0131.<\/li><li> <strong>kriter:<\/strong> bir say\u0131, bir metin, bir ifade, bir h\u00fccre referans\u0131 veya bir fonksiyon olabilen bir kriter.<\/li><li> <strong>[sum_range]:<\/strong> Toplama istedi\u011finiz de\u011ferleri i\u00e7eren h\u00fccre aral\u0131\u011f\u0131.<\/li><\/ul><h3 id=\"53-notes-\" class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> Toplam_aral\u0131k belirtilmezse aral\u0131ktaki h\u00fccreler toplan\u0131r.<\/li><li> Metin kriterlerini belirtmek i\u00e7in veya \u00e7ift t\u0131rnak i\u00e7ine al\u0131nmas\u0131 gereken matematiksel semboller i\u00e7eren \u00e7ift t\u0131rnak kulland\u0131\u011f\u0131n\u0131zdan emin olun.<\/li><li> \u00d6l\u00e7\u00fct aral\u0131\u011f\u0131n\u0131n ve toplam aral\u0131\u011f\u0131n\u0131n boyutu ayn\u0131 boyutta olmal\u0131d\u0131r.<\/li><\/ul><h3 id=\"54-example\" class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte kriter aral\u0131\u011f\u0131 olarak A1:A9&#8217;u, toplam aral\u0131\u011f\u0131 olarak da B1:B9&#8217;u belirledik ve ard\u0131ndan C de\u011ferine sahip A12&#8217;de kriterleri belirledik. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37333\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-toplam-i\u015flevi-\u00f6rnek-1\" width=\"453\" height=\"510\"><\/figure><\/div><p> Kriterleri do\u011frudan fonksiyona da ekleyebilirsiniz. A\u015fa\u011f\u0131daki \u00f6rnekte, &#8220;S&#8221; alfabesine sahip bir kriteri belirtmek i\u00e7in y\u0131ld\u0131z i\u015fareti joker karakterini kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37334\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-toplam-i\u015flevi-\u00f6rnek-2\" width=\"450\" height=\"480\"><\/figure><\/div><p> Ve e\u011fer toplam aral\u0131\u011f\u0131n\u0131 g\u00f6z ard\u0131 ederseniz, bu size \u00f6l\u00e7\u00fct aral\u0131\u011f\u0131n\u0131n toplam\u0131n\u0131 verecektir. Ancak bu ancak kriter aral\u0131\u011f\u0131n\u0131n say\u0131sal de\u011ferlere sahip olmas\u0131 durumunda m\u00fcmk\u00fcn olacakt\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37335\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-3.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-toplam-i\u015flevi-\u00f6rnek-3\" width=\"410\" height=\"411\"><\/figure><\/div><\/div><div class=\"gb-container gb-container-a35391aa\"><h2 class=\"wp-block-heading\"> 5. INDEX i\u015flevi<\/h2><p> <strong>INDEX i\u015flevi, dizin numaras\u0131na g\u00f6re de\u011ferler listesinden bir de\u011fer d\u00f6nd\u00fcr\u00fcr.<\/strong> Basit bir ifadeyle INDEX, de\u011ferler listesinden bir de\u011fer d\u00f6nd\u00fcr\u00fcr ve bu de\u011ferin konumunu belirtmeniz gerekir.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> INDEX&#8217;in iki farkl\u0131 s\u00f6zdizimi vard\u0131r. <strong>\u0130lkinde<\/strong> , konumunu kullanarak bir listeden basit\u00e7e bir de\u011fer almak i\u00e7in bir dizinin dizi bi\u00e7imini kullanabilirsiniz.<\/p><p> INDEX(dizi; sat\u0131r_say\u0131s\u0131; [s\u00fctun_say\u0131s\u0131])<\/p><p> <strong>\u0130kincisinde<\/strong> ise ger\u00e7ek hayatta daha az kullan\u0131lan bir sponsorluk formunu kullanabilirsiniz ancak birden fazla tan\u0131t\u0131m yapacak \u00fcr\u00fcn yelpazeniz varsa bunu kullanabilirsiniz.<\/p><p> INDEX(referans; sat\u0131r_say\u0131s\u0131; [s\u00fctun_say\u0131s\u0131]; [alan_say\u0131s\u0131])<\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>dizi:<\/strong> Bir h\u00fccre aral\u0131\u011f\u0131 veya bir dizi sabiti.<\/li><li> <strong>referans:<\/strong> bir h\u00fccre aral\u0131\u011f\u0131 veya birka\u00e7 aral\u0131k.<\/li><li> <strong>row_number:<\/strong> De\u011feri almak istedi\u011finiz sat\u0131r numaras\u0131.<\/li><li> <strong>[s\u00fctun_numaras\u0131]:<\/strong> De\u011feri almak istedi\u011finiz s\u00fctunun numaras\u0131.<\/li><li> <strong>[alan_numaras\u0131]:<\/strong> Birden fazla h\u00fccre aral\u0131\u011f\u0131na at\u0131fta bulunuyorsan\u0131z (referans s\u00f6z dizimini kullanarak), bunlar\u0131n t\u00fcm\u00fc aras\u0131ndan bir aral\u0131\u011fa at\u0131fta bulunacak bir say\u0131 belirtin.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> Sat\u0131r_say\u0131s\u0131 ve s\u00fctun_say\u0131s\u0131 arg\u00fcmanlar\u0131 belirtildi\u011finde, ikisinin kesi\u015fimindeki h\u00fccredeki de\u011feri d\u00f6nd\u00fcr\u00fcr.<\/li><li> Sat\u0131r_say\u0131s\u0131 veya s\u00fctun_say\u0131s\u0131&#8217;n\u0131 0 (s\u0131f\u0131r) olarak belirtirseniz s\u0131ras\u0131yla t\u00fcm s\u00fctun veya sat\u0131r i\u00e7in de\u011ferler dizisini d\u00f6nd\u00fcr\u00fcr.<\/li><li> Sat\u0131r_say\u0131s\u0131 ve s\u00fctun_say\u0131s\u0131 aral\u0131k d\u0131\u015f\u0131nda oldu\u011funda #BA\u015eV! de\u011ferini d\u00f6nd\u00fcr\u00fcr. hata.<\/li><li> Alan_numaras\u0131 belirtti\u011finiz say\u0131 aral\u0131klar\u0131ndan b\u00fcy\u00fckse #REF! de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek 1 \u2013 Bir listeden de\u011fer almak i\u00e7in ARRAY&#8217;in kullan\u0131lmas\u0131<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte Haziran ay\u0131na ait miktar\u0131 almak i\u00e7in INDEX fonksiyonunu kulland\u0131k. Listede Jun 6. s\u0131rada (6. s\u0131ra) bu y\u00fczden sat\u0131r_numaras\u0131&#8217;nda 6&#8217;y\u0131 belirledim. INDEX sonu\u00e7ta 1904 de\u011ferini d\u00f6nd\u00fcrd\u00fc. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37057\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Exemple-de-fonction-dindex-Excel-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-indeks-i\u015flevi-\u00f6rnek-1\" width=\"557\" height=\"334\"><\/figure><\/div><p> Ve birden fazla s\u00fctunu olan bir aral\u0131ktan bahsediyorsan\u0131z s\u00fctun numaras\u0131n\u0131 belirtmeniz gerekir.<\/p><h3 class=\"wp-block-heading\"> \u00d6rnek 2 \u2013 Birden fazla listenin de\u011ferini almak i\u00e7in REFERENCE&#8217;\u0131 kullanma<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte t\u00fcm aral\u0131\u011f\u0131 tek seferde se\u00e7mek yerine \u00fc\u00e7 farkl\u0131 aral\u0131kta se\u00e7tim. Son arg\u00fcmanda bu \u00fc\u00e7 farkl\u0131 aral\u0131ktan kullan\u0131lacak aral\u0131\u011f\u0131 tan\u0131mlayacak alan_numaras\u0131&#8217;nda 2&#8217;yi belirttik. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37060\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Exemple-de-fonction-dindex-Excel-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-indeks-i\u015flevi-\u00f6rnek-2\" width=\"627\" height=\"311\"><\/figure><\/div><p> \u015eimdi ikinci sat\u0131rda 5. sat\u0131r ve 1. s\u00fctuna de\u011finiyoruz. INDEX, 2. sat\u0131r\u0131n 5. sat\u0131r\u0131ndaki 172 de\u011ferini d\u00f6nd\u00fcrd\u00fc.<\/p><\/div><div class=\"gb-container gb-container-3b02e5f8\"><h2 class=\"wp-block-heading\"> 6.D\u00dc\u015eEYARA \u0130\u015flevi<\/h2><p> <strong>D\u00dc\u015eEYARA i\u015flevi, bir tablonun ilk s\u00fctununda bir de\u011fer arar ve dizin numaras\u0131n\u0131 kullanarak kar\u015f\u0131l\u0131k gelen de\u011ferin ayn\u0131 sat\u0131r\u0131ndaki de\u011feri d\u00f6nd\u00fcr\u00fcr.<\/strong> Basit bir ifadeyle dikey arama ger\u00e7ekle\u015ftirir.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>D\u00dc\u015eEYARA(aranan_de\u011fer,tablo_dizisi,s\u00fctun_indeks_say\u0131s\u0131,aral\u0131k_bak)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>aranan_de\u011fer:<\/strong> Bir s\u00fctunda aramak istedi\u011finiz de\u011fer. Arama de\u011ferini i\u00e7eren bir h\u00fccreye ba\u015fvurabilir veya bu de\u011feri do\u011frudan i\u015fleve girebilirsiniz.<\/li><li> <strong>table_array:<\/strong> De\u011feri bulmak istedi\u011finiz adland\u0131r\u0131lm\u0131\u015f aral\u0131k olan bir h\u00fccre aral\u0131\u011f\u0131.<\/li><li> <strong>col_index_num:<\/strong> Bir say\u0131, de\u011feri almak istedi\u011finiz s\u00fctun numaras\u0131n\u0131 temsil eder.<\/li><li> <strong>range_lookup:<\/strong> Tam e\u015fle\u015fme i\u00e7in false veya 0, uygun e\u015fle\u015fme i\u00e7in true veya 1 kullan\u0131n. Varsay\u0131lan Do\u011fru&#8217;dur.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> D\u00dc\u015eEYARA arad\u0131\u011f\u0131n\u0131z de\u011feri bulamazsa #YOK sonucunu d\u00f6nd\u00fcr\u00fcr.<\/li><li> D\u00dc\u015eEYARA yaln\u0131zca arama de\u011ferinin sa\u011f\u0131ndaki de\u011feri verebilir. E\u011fer sa\u011f taraftan bakmak istiyorsan\u0131z bunun i\u00e7in INDEX ve MATCH kullanabilirsiniz.<\/li><li> Tam e\u015flemeyi kullan\u0131rsan\u0131z yaln\u0131zca s\u00fctunda ilk s\u0131rada yer alan de\u011ferle e\u015fle\u015fir.<\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/vlookup-ozellikli-joker-karakterler\/\">D\u00dc\u015eEYARA ile joker karakterleri<\/a> de kullanabilirsiniz.<\/li><li> Uygun bir e\u015fle\u015fme istiyorsan\u0131z DO\u011eRU veya 1&#8217;i, tam bir e\u015fle\u015fme i\u00e7in YANLI\u015e veya 0&#8217;\u0131 kullanabilirsiniz.<\/li><li> Uygun bir e\u015fle\u015fme kullan\u0131rsan\u0131z (True): Tam e\u015fle\u015fme yoksa listedeki bir sonraki en k\u00fc\u00e7\u00fck de\u011feri d\u00f6nd\u00fcr\u00fcr.<\/li><li> Arad\u0131\u011f\u0131n\u0131z de\u011fer listedeki en k\u00fc\u00e7\u00fck de\u011ferden k\u00fc\u00e7\u00fckse, D\u00dc\u015eEYARA #YOK sonucunu d\u00f6nd\u00fcr\u00fcr.<\/li><li> E\u011fer arad\u0131\u011f\u0131n\u0131z kesin bir de\u011fer varsa size tam olarak o de\u011feri verecektir.<\/li><li> Listeyi artan d\u00fczende s\u0131ralad\u0131\u011f\u0131n\u0131zdan emin olun.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><h4 class=\"wp-block-heading\"> 1. Kategoriler i\u00e7in D\u00dc\u015eEYARA&#8217;y\u0131 Kullanma<\/h4><p> A\u015fa\u011f\u0131daki \u00f6rnekte ald\u0131klar\u0131 notlar\u0131 olan \u00f6\u011frencilerin bir listesi var ve a\u00e7\u0131klamalar s\u00fctununda notlar\u0131na g\u00f6re bir not istiyoruz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37377\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-excel-vlookup-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-vlookup-fonksiyonu-\u00f6rnek-1\" width=\"385\" height=\"386\"><\/figure><\/div><p> Yukar\u0131daki marka listesine a\u015fa\u011f\u0131daki kategori aral\u0131\u011f\u0131na g\u00f6re a\u00e7\u0131klamalar eklemek istiyoruz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37378\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-excel-vlookup-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-vlookup-i\u015flevi-\u00f6rnek-2\" width=\"369\" height=\"132\"><\/figure><\/div><p> Bu konuda kullanaca\u011f\u0131m\u0131z iki se\u00e7ene\u011fimiz var.<\/p><p> <strong>\u0130LK se\u00e7enek<\/strong> IF ile yuvalama form\u00fcl\u00fc olu\u015fturmakt\u0131r ve bu biraz zaman al\u0131r, <strong>\u0130K\u0130NC\u0130<\/strong> se\u00e7enek ise D\u00dc\u015eEYARA ile uygun e\u015fle\u015fmeye sahip bir form\u00fcl olu\u015fturmakt\u0131r. Ve form\u00fcl \u015f\u00f6yle olacak:<\/p><p> =D\u00dc\u015eEYARA(B2,$E$2:$G$5,3,DO\u011eRU) <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37379\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-excel-vlookup-3.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-vlookup-fonksiyonu-\u00f6rnek-3\" width=\"479\" height=\"321\"><\/figure><\/div><p> <strong>Nas\u0131l \u00e7al\u0131\u015f\u0131r<\/strong><\/p><p> Arama de\u011ferini e\u015fle\u015ftirmek ve de\u011feri &#8220;A\u00e7\u0131klamalar&#8221; s\u00fctunundan geri almak i\u00e7in &#8220;MIN MARKS&#8221; s\u00fctununu kullan\u0131yorum.<\/p><p> TRUE kulland\u0131\u011f\u0131n\u0131zda ve tam e\u015fle\u015fme arama de\u011feri olmad\u0131\u011f\u0131nda arama de\u011ferinden bir sonraki en k\u00fc\u00e7\u00fck de\u011feri d\u00f6nd\u00fcrece\u011fini daha \u00f6nce belirtmi\u015ftim. \u00d6rne\u011fin kategori tablosunda 77 de\u011ferini arad\u0131\u011f\u0131m\u0131zda 77&#8217;den sonraki en k\u00fc\u00e7\u00fck de\u011fer 65&#8217;tir.<\/p><p> Bu nedenle a\u00e7\u0131klamalarda \u201c\u0130yi\u201d notu ald\u0131k.<\/p><h4 class=\"wp-block-heading\"> 2. D\u00dc\u015eEYARA i\u015flevinde hata y\u00f6netimi<\/h4><p> D\u00dc\u015eEYARA&#8217;y\u0131 kullan\u0131rken ortaya \u00e7\u0131kan en yayg\u0131n sorunlardan biri, hi\u00e7bir e\u015fle\u015fme bulunmad\u0131\u011f\u0131nda #YOK sonucunu alman\u0131zd\u0131r. Ancak bu sorunun \u00e7\u00f6z\u00fcm\u00fc basit ve kolayd\u0131r. Size basit bir \u00f6rnekle g\u00f6stereyim.<\/p><p> A\u015fa\u011f\u0131daki \u00f6rnekte adlar\u0131n ve ya\u015flar\u0131n\u0131n bir listesi var ve E6 h\u00fccresinde listede bir ad\u0131 aramak i\u00e7in D\u00dc\u015eEYARA i\u015flevini kullan\u0131yoruz. Listede olmayan bir ad\u0131 her yazd\u0131\u011f\u0131mda #N\/A mesaj\u0131 al\u0131yorum. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37380\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-excel-vlookup-4.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-vlookup-i\u015flevi-\u00f6rnek-4\" width=\"560\" height=\"404\"><\/figure><\/div><p> Ancak burada istedi\u011fim hata yerine anlaml\u0131 bir mesaj g\u00f6r\u00fcnt\u00fclemek. Form\u00fcl \u015f\u00f6yle olacakt\u0131r: =E\u011eERYA(D\u00dc\u015eEYARA(D6,Sayfa3!$A$1:$B$14,2,0),\u201dBulunamad\u0131\u201d) <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37381\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-excel-vlookup-5.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-vlookup-fonksiyonu-\u00f6rnek-5\" width=\"601\" height=\"359\"><\/figure><\/div><p> <strong>Nas\u0131l \u00e7al\u0131\u015f\u0131r<\/strong> : IFNA, #N\/A i\u00e7in bir de\u011feri test edebilir ve bir hata olmas\u0131 durumunda, hatan\u0131n yerine bir de\u011fer belirtebilirsiniz.<\/p><\/div><div class=\"gb-container gb-container-c8d02e8d\"><h2 class=\"wp-block-heading\"> 7. IFNA i\u015flevi<\/h2><p> <strong>E\u011eER #YOK hatas\u0131 olu\u015fursa IFNA i\u015flevi belirli bir de\u011fer d\u00f6nd\u00fcr\u00fcr.<\/strong> E\u011eERHATA&#8217;dan farkl\u0131 olarak yaln\u0131zca #YOK hatas\u0131n\u0131 de\u011ferlendirir ve belirtti\u011finiz de\u011feri d\u00f6nd\u00fcr\u00fcr.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> IFNA(de\u011fer; e\u011fer_e\u011fer_na)<\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>de\u011fer:<\/strong> #YOK hatas\u0131 a\u00e7\u0131s\u0131ndan test etmek istedi\u011finiz de\u011fer.<\/li><li> <strong>value_if_na:<\/strong> Bir hata olu\u015ftu\u011funda d\u00f6nd\u00fcrmek istedi\u011finiz de\u011fer.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> Herhangi bir arg\u00fcman belirtmezseniz, IFNA bunu bo\u015f bir dize (&#8220;&#8221;) olarak de\u011ferlendirecektir.<\/li><li> E\u011fer de\u011fer bir dizi ise sonucu bir dizi olarak d\u00f6nd\u00fcr\u00fcr.<\/li><li> Di\u011fer t\u00fcm #REF!, #DIV\/0!, #VALUE!, #NUM!, #NAME? hatalar\u0131n\u0131 yok sayar. ve #BO\u015e!.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> D\u00dc\u015eEYARA i\u015flevinde #YOK, aranan de\u011fer arama aral\u0131\u011f\u0131nda olmad\u0131\u011f\u0131nda ortaya \u00e7\u0131kar ve bunun i\u00e7in IFNA kullanarak anlaml\u0131 bir mesaj belirledik. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37051\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-ifna-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-ifna-i\u015flevi-\u00f6rnek-1\" width=\"537\" height=\"259\"><\/figure><\/div><p class=\"qt-tip\"> <strong>Not:<\/strong> IFNA, Excel 2013&#8217;te tan\u0131t\u0131ld\u0131\u011f\u0131ndan \u00f6nceki s\u00fcr\u00fcmlerde mevcut de\u011fildir.<\/p><\/div><div class=\"gb-container gb-container-593242fc\"><h2 class=\"wp-block-heading\"> 8. RAND i\u015flevi<\/h2><p> <strong>RAND i\u015flevi 0 ile 1 aras\u0131nda rastgele bir say\u0131 d\u00f6nd\u00fcr\u00fcr.<\/strong> Basit bir ifadeyle, 0 ile 1 aras\u0131nda rastgele bir say\u0131 olu\u015fturabilirsiniz (\u00e7al\u0131\u015fma sayfas\u0131nda her de\u011fi\u015fiklik yapt\u0131\u011f\u0131n\u0131zda de\u011ferini g\u00fcnceller).<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>RAND()<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> RAND i\u015flevlerinde belirtilecek ba\u011f\u0131ms\u0131z de\u011fi\u015fken yok<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> Bir kata s\u0131f\u0131r koyarsan\u0131z sonu\u00e7ta s\u0131f\u0131r d\u00f6ner.<\/li><li> Birden fazla belirtmeyi g\u00f6z ard\u0131 ederseniz bir hata d\u00f6nd\u00fcrecektir.<\/li><li> S\u0131f\u0131rdan yuvarlan\u0131r.<\/li><li> Ayn\u0131 mesafede iki kat\u0131n\u0131z varsa, yuvarlad\u0131\u011f\u0131n\u0131z say\u0131n\u0131n daha b\u00fcy\u00fck kat\u0131n\u0131 verecektir.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> 0 ile 1 aras\u0131nda say\u0131lara sahip olman\u0131n yan\u0131 s\u0131ra, RAND&#8217;\u0131 iki belirli say\u0131 aras\u0131ndaki rastgele say\u0131lar i\u00e7in de kullanabilirsiniz. A\u015fa\u011f\u0131daki \u00f6rnekte 50 ile 100 aras\u0131nda rastgele bir say\u0131 \u00fcreten bir form\u00fcl olu\u015fturmak i\u00e7in kulland\u0131m. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37234\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-rand-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-rand-fonksiyon-\u00f6rnek-1\" width=\"449\" height=\"394\"><\/figure><\/div><p> Bu form\u00fcl\u00fc bir h\u00fccreye girdi\u011finizde RAND&#8217;\u0131n d\u00f6nd\u00fcrd\u00fc\u011f\u00fc de\u011ferleri kulland\u0131\u011f\u0131m\u0131z denklemle \u00e7arparak 100 ile 50 aras\u0131nda bir say\u0131 verir. Bu form\u00fcl\u00fc anlamak i\u00e7in onu \u00fc\u00e7 b\u00f6l\u00fcme ay\u0131rmam\u0131z gerekir:<\/p><ol><li> \u0130lk olarak, y\u00fcksek say\u0131dan k\u00fc\u00e7\u00fck say\u0131y\u0131 tespit etti\u011finde ikisi aras\u0131ndaki fark\u0131 elde edersiniz.<\/li><li> Daha sonra bu fark\u0131, \u00e7\u0131karma i\u015fleminden sonra d\u00f6nd\u00fcr\u00fclen rastgele say\u0131yla \u00e7arpar.<\/li><li> \u00dc\u00e7\u00fcnc\u00fcs\u00fc, denklemin \u00fc\u00e7\u00fcnc\u00fc k\u0131sm\u0131na kalan en k\u00fc\u00e7\u00fck say\u0131y\u0131 i\u00e7eren bu say\u0131y\u0131 ekleyin.<\/li><\/ol><p> <strong>\u0130lgili:<\/strong> <a href=\"https:\/\/exceladvisor.org\/tr\/rastgele-harfler-olustur\/\">Excel&#8217;de Rastgele Harfleri H\u0131zl\u0131 Bir \u015eekilde Olu\u015fturma<\/a><\/p><\/div><div class=\"gb-container gb-container-c4855d41\"><h2 class=\"wp-block-heading\"> 9. TOPLA i\u015flevi<\/h2><p> SUM i\u015flevi <strong>, sa\u011flanan de\u011ferlerin toplam\u0131n\u0131<\/strong> d\u00f6nd\u00fcr\u00fcr. Basit bir ifadeyle, SUM i\u015fleviyle bir de\u011ferler listesinin toplam\u0131n\u0131 hesaplayabilirsiniz (i\u015fleve do\u011frudan bir de\u011fer girebilir veya bir h\u00fccre aral\u0131\u011f\u0131na ba\u015fvurabilirsiniz).<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>TOPLA(say\u01311,[say\u01312],\u2026)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>say\u01311<\/strong> : say\u0131, say\u0131lar\u0131 i\u00e7eren h\u00fccre aral\u0131\u011f\u0131 veya say\u0131 i\u00e7eren tek h\u00fccre.<\/li><li> <strong>[say\u01312]<\/strong> : say\u0131, say\u0131lar\u0131 i\u00e7eren h\u00fccre aral\u0131\u011f\u0131 veya say\u0131 i\u00e7eren tek h\u00fccre.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> Metin de\u011ferlerini yok sayar.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte, say\u0131lar\u0131 aralar\u0131na virg\u00fcl kullanarak do\u011frudan fonksiyona ekleyebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37324\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-somme-excel-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-toplam-i\u015flevi-\u00f6rnek-1\" width=\"433\" height=\"284\"><\/figure><\/div><p> Ayr\u0131ca say\u0131lar\u0131n toplam\u0131n\u0131 hesaplamak i\u00e7in yaln\u0131zca bir aral\u0131\u011fa ba\u015fvurabilirsiniz ve herhangi bir metin, mant\u0131ksal de\u011fer veya bo\u015f h\u00fccre varsa bunlar\u0131 yok sayar. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37325\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-somme-excel-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-toplam-i\u015flevi-\u00f6rnek-2\" width=\"392\" height=\"434\"><\/figure><\/div><p> Bahsetti\u011finiz h\u00fccrede bir hata de\u011feri varsa sonu\u00e7ta #YOK sonucunu d\u00f6nd\u00fcr\u00fcr. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37326\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-somme-excel-3.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-toplam-i\u015flevi-\u00f6rnek-3\" width=\"440\" height=\"429\"><\/figure><\/div><p> Metin olarak bi\u00e7imlendirilmi\u015f say\u0131sal de\u011ferleriniz varsa bunlar\u0131 yok sayacakt\u0131r. SUM&#8217;u kullanmadan \u00f6nce bunlar\u0131 say\u0131lara d\u00f6n\u00fc\u015ft\u00fcrmeniz \u00f6nerilir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37328\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-somme-excel-4-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-toplam-i\u015flevi-\u00f6rnek-4\" width=\"430\" height=\"493\"><\/figure><\/div><\/div><div class=\"gb-container gb-container-d78822f8\"><h2 class=\"wp-block-heading\"> 10. VEYA i\u015flevi<\/h2><p> <strong>VEYA \u0130\u015flevi, belirtti\u011finiz ko\u015fullar\u0131 test ettikten sonra bir Boole de\u011feri (DO\u011eRU veya YANLI\u015e) d\u00f6nd\u00fcr\u00fcr.<\/strong> Basit bir ifadeyle, AND i\u015fleviyle birden \u00e7ok ko\u015fulu test edebilirsiniz ve bu ko\u015fullardan herhangi biri (veya t\u00fcm\u00fc) DO\u011eRU ise DO\u011eRU de\u011ferini d\u00f6nd\u00fcr\u00fcr ve yaln\u0131zca bu ko\u015fullar\u0131n t\u00fcm\u00fc YANLI\u015e oldu\u011funda YANLI\u015e de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> VEYA(mant\u0131k1, [mant\u0131k2], \u2026)<\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>mant\u0131ksal1:<\/strong> Kontrol etmek istedi\u011finiz ko\u015ful.<\/li><li> <strong>[mant\u0131ksal2]:<\/strong> Kontrol etmek istedi\u011finiz ek ko\u015fullar.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> Referans h\u00fccresi veya tablo bo\u015f bir h\u00fccre veya metin i\u00e7eriyorsa de\u011ferler g\u00f6z ard\u0131 edilecektir.<\/li><li> Ko\u015fullar\u0131n sonucu mant\u0131ksal bir de\u011fer olmal\u0131d\u0131r (DO\u011eRU veya YANLI\u015e).<\/li><li> Mant\u0131ksal de\u011fer d\u00f6nd\u00fcr\u00fclmezse hata verir.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte, IF i\u015flevini kullanarak, bir \u00f6\u011frencinin iki dersin herhangi birinde 60 puan \u00fczerinde puan almas\u0131 durumunda form\u00fcl\u00fcn DO\u011eRU sonucunu d\u00f6nd\u00fcrece\u011fi bir ko\u015ful olu\u015fturduk. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37225\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-ou-fonction-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-veya-i\u015flev-\u00f6rne\u011fi-1\" width=\"472\" height=\"280\"><\/figure><\/div><p> \u015eimdi a\u015fa\u011f\u0131daki \u00f6rnekte bir form\u00fclde mant\u0131ksal de\u011ferler elde etmek i\u00e7in bir say\u0131 kulland\u0131k. Yukar\u0131daki ko\u015fulu ters s\u0131rada da ger\u00e7ekle\u015ftirebilirsiniz.<\/p><p> Say\u0131lar yerine DO\u011eRU ve YANLI\u015e&#8217;\u0131 kullanabilirsiniz. OR i\u015flevi bu mant\u0131ksal de\u011ferleri say\u0131 olarak ele al\u0131r.<\/p><\/div><div class=\"gb-container gb-container-68a47082\"><h2 class=\"wp-block-heading\"> Daha fazla e\u011fitim<\/h2><p> <a href=\"https:\/\/exceladvisor.org\/tr\/excel-istatistik-fonksiyonlari\/\"><strong>\u0130statistiksel Fonksiyonlar<\/strong><\/a> \/ <a href=\"https:\/\/exceladvisor.org\/tr\/excel-tarih-fonksiyonlari\/\"><strong>Tarih Fonksiyonlar\u0131<\/strong><\/a> \/ <a href=\"https:\/\/exceladvisor.org\/tr\/excel-dize-islevleri\/\"><strong>String \u2013 Metin Fonksiyonlar\u0131<\/strong><\/a> \/ <a href=\"https:\/\/exceladvisor.org\/tr\/finansal-fonksiyonlari-excel\/\"><strong>Finansal Fonksiyonlar<\/strong><\/a><\/p><\/div>","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-1496","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>En \u00d6nemli 10 Excel \u0130\u015flevi (\u00d6rneklerle)<\/title>\n<meta name=\"description\" content=\"Bu k\u0131lavuz, kullanabilece\u011finiz \u00f6rnek dosyalar da dahil olmak \u00fczere \u00f6rneklerle birlikte en iyi Excel i\u015flevleriyle tamamen y\u00fcklenmi\u015ftir...\" \/>\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\/excel-fonksiyonlari\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"En \u00d6nemli 10 Excel \u0130\u015flevi (\u00d6rneklerle)\" \/>\n<meta property=\"og:description\" content=\"Bu k\u0131lavuz, kullanabilece\u011finiz \u00f6rnek dosyalar da dahil olmak \u00fczere \u00f6rneklerle birlikte en iyi Excel i\u015flevleriyle tamamen y\u00fcklenmi\u015ftir...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/excel-fonksiyonlari\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T05:59:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-si-fonction-exemple-1.png\" \/>\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=\"14 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-fonksiyonlari\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/excel-fonksiyonlari\/\",\"name\":\"En \u00d6nemli 10 Excel \u0130\u015flevi (\u00d6rneklerle)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-fonksiyonlari\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-fonksiyonlari\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-si-fonction-exemple-1.png\",\"datePublished\":\"2023-11-20T14:34:55+00:00\",\"dateModified\":\"2023-12-10T05:59:28+00:00\",\"description\":\"Bu k\u0131lavuz, kullanabilece\u011finiz \u00f6rnek dosyalar da dahil olmak \u00fczere \u00f6rneklerle birlikte en iyi Excel i\u015flevleriyle tamamen y\u00fcklenmi\u015ftir...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-fonksiyonlari\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/excel-fonksiyonlari\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-fonksiyonlari\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-si-fonction-exemple-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-si-fonction-exemple-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-fonksiyonlari\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"En \u00f6nemli 10 excel i\u0307\u015flevi\"}]},{\"@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":"En \u00d6nemli 10 Excel \u0130\u015flevi (\u00d6rneklerle)","description":"Bu k\u0131lavuz, kullanabilece\u011finiz \u00f6rnek dosyalar da dahil olmak \u00fczere \u00f6rneklerle birlikte en iyi Excel i\u015flevleriyle tamamen y\u00fcklenmi\u015ftir...","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\/excel-fonksiyonlari\/","og_locale":"tr_TR","og_type":"article","og_title":"En \u00d6nemli 10 Excel \u0130\u015flevi (\u00d6rneklerle)","og_description":"Bu k\u0131lavuz, kullanabilece\u011finiz \u00f6rnek dosyalar da dahil olmak \u00fczere \u00f6rneklerle birlikte en iyi Excel i\u015flevleriyle tamamen y\u00fcklenmi\u015ftir...","og_url":"https:\/\/exceladvisor.org\/tr\/excel-fonksiyonlari\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T05:59:28+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-si-fonction-exemple-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"14 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/excel-fonksiyonlari\/","url":"https:\/\/exceladvisor.org\/tr\/excel-fonksiyonlari\/","name":"En \u00d6nemli 10 Excel \u0130\u015flevi (\u00d6rneklerle)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/excel-fonksiyonlari\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/excel-fonksiyonlari\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-si-fonction-exemple-1.png","datePublished":"2023-11-20T14:34:55+00:00","dateModified":"2023-12-10T05:59:28+00:00","description":"Bu k\u0131lavuz, kullanabilece\u011finiz \u00f6rnek dosyalar da dahil olmak \u00fczere \u00f6rneklerle birlikte en iyi Excel i\u015flevleriyle tamamen y\u00fcklenmi\u015ftir...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/excel-fonksiyonlari\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/excel-fonksiyonlari\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/excel-fonksiyonlari\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-si-fonction-exemple-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-si-fonction-exemple-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/excel-fonksiyonlari\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"En \u00f6nemli 10 excel i\u0307\u015flevi"}]},{"@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\/1496","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=1496"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1496\/revisions"}],"predecessor-version":[{"id":2325,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1496\/revisions\/2325"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1496"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}