{"id":2109,"date":"2023-10-15T13:57:11","date_gmt":"2023-10-15T13:57:11","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/excel-bilgi-fonksiyonlari\/"},"modified":"2023-12-10T06:00:23","modified_gmt":"2023-12-10T06:00:23","slug":"excel-bilgi-fonksiyonlari","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/excel-bilgi-fonksiyonlari\/","title":{"rendered":"Excel&#39;de bilgi i\u015flevleri nas\u0131l kullan\u0131l\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-1154661585\"><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><strong><em><a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/exemples_de_fichiers_de_fonctions_dinformation_Excel.zip\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">\u00f6rnek dosya<\/a><\/em><\/strong><\/p><h2 class=\"wp-block-heading\"> 1. H\u00dcCRE i\u015flevi<\/h2><p> CELL i\u015flevi h\u00fccre hakk\u0131nda belirli bilgileri d\u00f6nd\u00fcr\u00fcr. Sonu\u00e7ta elde edilecek birden fazla bilgi t\u00fcr\u00fc aras\u0131ndan se\u00e7im yapabilirsiniz (i\u015flevde belirtebilirsiniz).<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>H\u00dcCRE(bilgi_t\u00fcr\u00fc, [ba\u015fvuru])<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>info_type:<\/strong> Bir h\u00fccre hakk\u0131nda kontrol etmek istedi\u011finiz bilgi t\u00fcr\u00fc. Referansta ihtiyac\u0131n\u0131z olan bilgi t\u00fcr\u00fcn\u00fc se\u00e7mek i\u00e7in bir a\u00e7\u0131l\u0131r listeniz var.<\/li><li> <strong>[referans]:<\/strong> Hakk\u0131nda bilgi almak istedi\u011finiz h\u00fccre.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> \u0130\u015flevdeki sonucu g\u00fcncellemek i\u00e7in h\u00fccrenin bi\u00e7imini de\u011fi\u015ftirirseniz \u00e7al\u0131\u015fma sayfas\u0131n\u0131 yeniden hesaplaman\u0131z gerekir.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte bir h\u00fccre hakk\u0131nda bilgi almak i\u00e7in t\u00fcm parametreleri kulland\u0131k. Bu i\u015flevi, bir h\u00fccre hakk\u0131ndaki bilgileri kullanman\u0131z gereken di\u011fer i\u015flevlerle birlikte kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36873\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-cellule-excel-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-h\u00fccre-i\u015flevi-\u00f6rnek-1\" width=\"533\" height=\"478\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 2. B\u0130LG\u0130 i\u015flevi<\/h2><p> INFO i\u015flevi mevcut i\u015fletim ortam\u0131 hakk\u0131nda bilgi verir. INFO i\u015flevini kullanarak elde edebilece\u011finiz yedi farkl\u0131 bilgi t\u00fcr\u00fc vard\u0131r.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>B\u0130LG\u0130(metin_t\u00fcr\u00fc)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>type_text:<\/strong> buna g\u00f6re ihtiyac\u0131n\u0131z olan bilgiler.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> Mevcut \u00e7al\u0131\u015fma ortam\u0131n\u0131z hakk\u0131nda bilgi almak i\u00e7in 7 farkl\u0131 ayar\u0131n\u0131z vard\u0131r.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte mevcut \u00e7al\u0131\u015fma ortam\u0131 hakk\u0131nda bilgi edinmek i\u00e7in t\u00fcm parametreleri kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37068\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-info-fonction-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-bilgi-i\u015flevi-\u00f6rnek-1\" width=\"1210\" height=\"439\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 3. ESBLANK i\u015flevi<\/h2><p> ISBLANK i\u015flevi, bir h\u00fccre bo\u015fsa TRUE de\u011ferini d\u00f6nd\u00fcr\u00fcr. Basit bir ifadeyle, ISBLANK i\u015fleviyle bir h\u00fccreye ba\u015fvurabilir, bo\u015f olup olmad\u0131\u011f\u0131n\u0131 kontrol edebilir ve bo\u015fsa TRUE sonucunu d\u00f6nd\u00fcrebilirsiniz.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>BEYAZ(de\u011fer)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>de\u011fer:<\/strong> test etmek istedi\u011finiz bir h\u00fccre veya de\u011fer.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> ISERROR, hatan\u0131n mutlak m\u0131 yoksa ba\u015fka bir form\u00fclden mi kaynakland\u0131\u011f\u0131n\u0131 her iki ko\u015fulda da kontrol eder.<\/li><li> Bir h\u00fccredeki her t\u00fcrl\u00fc hatay\u0131 de\u011ferlendirecektir. #YOK, #B\u00d6L\/0!, #AD?, #BO\u015e!, #SAYI!, #REF! ve #DE\u011eER!.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte, F1 h\u00fccresi bo\u015fsa kullan\u0131c\u0131ya mesaj g\u00f6ndermek i\u00e7in IF ile birlikte ISBLANK&#8217;\u0131 kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37072\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-excel-isblank-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-isblank-fonksiyonu-\u00f6rnek-1\" width=\"517\" height=\"294\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 4.ISERR i\u015flevi<\/h2><p> <strong>Bir de\u011fer #YOK d\u0131\u015f\u0131nda bir hata ise ISERR i\u015flevi DO\u011eRU de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/strong> ISERROR&#8217;dan farkl\u0131 olarak, #N\/A d\u0131\u015f\u0131ndaki t\u00fcm hatalar\u0131 dikkate ald\u0131\u011f\u0131n\u0131 ve bir hata varsa DO\u011eRU, aksi halde YANLI\u015e d\u00f6nd\u00fcrd\u00fc\u011f\u00fcn\u00fc kontrol edebilirsiniz.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>ISERR(de\u011fer)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>de\u011fer:<\/strong> hatay\u0131 kontrol etmek istedi\u011finiz h\u00fccre referans\u0131 veya de\u011feri.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> ISERR, hatan\u0131n mutlak olup olmad\u0131\u011f\u0131n\u0131 veya ba\u015fka bir form\u00fclden kaynaklan\u0131p kaynaklanmad\u0131\u011f\u0131n\u0131 her iki ko\u015fulda da kontrol edecektir.<\/li><li> #DIV\/0 h\u00fccresindeki t\u00fcm hata t\u00fcrlerini de\u011ferlendirir! #\u0130S\u0130M? #H\u00dcK\u00dcMS\u00dcZ! #SAYI! #REF! ve #DE\u011eER! ama #N\/A de\u011fil. #N\/A&#8217;y\u0131 kontrol etmek i\u00e7in ISNA ve ISERROR&#8217;u kullanabilirsiniz.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte, h\u00fccrede bir hata olmas\u0131 durumunda belirli bir metni almak i\u00e7in ISERR&#8217;yi IF ile birlikte kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37074\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-iserr-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-iserr-i\u015flevi-\u00f6rnek-1\" width=\"480\" height=\"375\"><\/figure><\/div><p> A\u015fa\u011f\u0131daki \u00f6rnekte, bir h\u00fccre aral\u0131\u011f\u0131n\u0131 hatalara kar\u015f\u0131 kontrol etmek i\u00e7in ISERR&#8217;yi bir tablo aral\u0131\u011f\u0131yla birlikte kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37075\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-iserr-exemple-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-iserr-i\u015flevi-\u00f6rnek-2\" width=\"500\" height=\"422\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 5. HATA i\u015flevi<\/h2><p> <strong>Bir de\u011fer hatal\u0131ysa ISERROR i\u015flevi TRUE de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/strong> T\u00fcm hatalar\u0131 dikkate al\u0131p almad\u0131\u011f\u0131n\u0131 kontrol edebilirsiniz ve bir hata varsa DO\u011eRU, aksi halde YANLI\u015e de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>ESTERHATA (de\u011fer)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>de\u011fer:<\/strong> hatay\u0131 kontrol etmek istedi\u011finiz h\u00fccre referans\u0131 veya de\u011feri.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> ISERROR, hatan\u0131n mutlak olup olmad\u0131\u011f\u0131n\u0131 veya ba\u015fka bir form\u00fclden kaynaklan\u0131p kaynaklanmad\u0131\u011f\u0131n\u0131 her iki ko\u015fulda da kontrol edecektir.<\/li><li> Bir h\u00fccredeki her t\u00fcrl\u00fc hatay\u0131 de\u011ferlendirecektir. #YOK, #B\u00d6L\/0!, #AD?, #BO\u015e!, #SAYI!, #REF! &amp; #DE\u011eER!.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte, bir h\u00fccrede hata olmas\u0131 durumunda belirli bir metni almak i\u00e7in ISERROR&#8217;u IF ile birlikte kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37077\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-derreur-excel-excel-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-hata-i\u015flevi-\u00f6rnek-1\" width=\"596\" height=\"327\"><\/figure><\/div><p> A\u015fa\u011f\u0131daki \u00f6rnekte, bir h\u00fccre aral\u0131\u011f\u0131ndaki hatay\u0131 kontrol etmek i\u00e7in ISERROR&#8217;u bir tablo aral\u0131\u011f\u0131yla birlikte kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37078\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-excel-iserror-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-hata-i\u015flevi-\u00f6rnek-2\" width=\"470\" height=\"438\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 6. ESEN i\u015flevi<\/h2><p> <strong>Sa\u011flanan de\u011fer bir \u00c7\u0130FT say\u0131 ise ISEVEN i\u015flevi TRUE de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/strong> Basit bir ifadeyle ISEVEN ile de\u011ferin \u00e7ift say\u0131 olup olmad\u0131\u011f\u0131n\u0131 kontrol edebilirsiniz.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>YED\u0130 (say\u0131)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>say\u0131:<\/strong> De\u011ferlendirmek istedi\u011finiz de\u011fer.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> Ayr\u0131ca, \u00e7ift t\u0131rnak kullanarak veya hatta onlar olmadan da fonksiyona do\u011frudan bir say\u0131 ekleyebilirsiniz.<\/li><li> Say\u0131sal olmayan bir de\u011fer belirtirseniz #DE\u011eER! hata de\u011feri.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131da farkl\u0131 arg\u00fcmanlar kulland\u0131k: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37080\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-iseven-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-iseeven-fonksiyon-\u00f6rnek-1\" width=\"471\" height=\"361\"><\/figure><\/div><ul><li> Verilen say\u0131 \u00e7ift ise TRUE de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/li><li> Negatif de\u011ferleri de ayn\u0131 \u015fekilde de\u011ferlendirir.<\/li><li> 0&#8217;\u0131 \u00e7ift say\u0131 olarak ele al\u0131r.<\/li><li> Ondal\u0131k basamakl\u0131 bir say\u0131 belirtirseniz, ondal\u0131k basamaklar\u0131 yok sayar ve tamsay\u0131y\u0131 de\u011ferlendirir. Bu \u00f6rnekte 0,5&#8217;i kesti ve 2 olarak de\u011ferlendirdi.<\/li><li> Excel, tarihi seri numaras\u0131 olarak saklad\u0131\u011f\u0131ndan ayn\u0131 \u015fekilde de\u011ferlendirir.<\/li><\/ul><h2 class=\"wp-block-heading\"> 7. E\u011eERFORM\u00dcL i\u015flevi<\/h2><p> <strong>ISFORMULA i\u015flevi, sa\u011flanan de\u011ferin (veya ba\u015fvurulan h\u00fccrenin) bir form\u00fcl\u00fc varsa DO\u011eRU de\u011ferini d\u00f6nd\u00fcr\u00fcr ve h\u00fccrede form\u00fcl yoksa YANLI\u015e de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/strong><\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>ESENFORM\u00dcL(referans)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>ba\u015fvuru:<\/strong> De\u011ferlendirmek istedi\u011finiz h\u00fccre ba\u015fvurusu.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> H\u00fccre ba\u015fvurusu ge\u00e7erli bir ba\u015fvuru de\u011filse #DE\u011eER! de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/li><li> Bir e-tablodaki t\u00fcm form\u00fclleri g\u00f6r\u00fcnt\u00fclemek i\u00e7in Ctrl + ~ k\u0131sayol tu\u015funu da kullanabilirsiniz.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131da farkl\u0131 arg\u00fcmanlar kulland\u0131k: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37082\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-isformula-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-isformula-i\u015flevi-\u00f6rnek-1\" width=\"438\" height=\"339\"><\/figure><\/div><ul><li> Basit bir toplama hesaplamas\u0131 ve DO\u011eRU de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/li><li> Ge\u00e7ici bir i\u015flev ve TRUE de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/li><li> Dikkat etmeniz gereken bir nokta da ISFORMULA&#8217;n\u0131n bir form\u00fcl\u00fcn sonucuyla de\u011fil, h\u00fccredeki form\u00fclle ilgili oldu\u011fudur. Form\u00fcl sonucu bo\u015f veya hatal\u0131 olsa bile TRUE de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/li><li> H\u00fccrede form\u00fcl d\u0131\u015f\u0131nda bir de\u011fer varsa YANLI\u015e de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/li><\/ul><h2 class=\"wp-block-heading\"> 8. ISLOGICAL i\u015flevi<\/h2><p> <strong>ISLOGICAL i\u015flevi, sa\u011flanan de\u011fer (veya ba\u015fvurulan h\u00fccredeki de\u011fer) mant\u0131ksal bir de\u011ferse TRUE de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/strong> Mant\u0131ksal bir de\u011fere sahip, DO\u011eRU veya YANLI\u015e anlam\u0131na gelir. Bu, e\u011fer de\u011fer DO\u011eRU veya YANLI\u015e ise DO\u011eRU, aksi halde YANLI\u015e de\u011ferini d\u00f6nd\u00fcrd\u00fc\u011f\u00fc anlam\u0131na gelir.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>ISLOGICAL (de\u011fer)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>de\u011fer:<\/strong> de\u011ferlendirmek istedi\u011finiz de\u011fer.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> H\u00fccre ba\u015fvurusu ge\u00e7erli bir ba\u015fvuru de\u011filse #DE\u011eER! de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131da farkl\u0131 arg\u00fcmanlar kulland\u0131k: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37084\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-islogique-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-islojik-i\u015flev-\u00f6rnek-1\" width=\"493\" height=\"499\"><\/figure><\/div><ul><li> <strong>\u0130LK<\/strong> h\u00fccreye basit bir DO\u011eRU de\u011feri girdik ve <strong>\u0130K\u0130NC\u0130<\/strong> h\u00fccreye DO\u011eRU fonksiyonunu kulland\u0131k. Her iki de\u011fer de mant\u0131ksal de\u011ferler oldu\u011fundan her iki de\u011fer i\u00e7in de TRUE d\u00f6nd\u00fcrd\u00fc.<\/li><li> <strong>\u00dc\u00c7\u00dcNC\u00dc<\/strong> ve <strong>D\u00d6RD\u00dcNC\u00dc<\/strong> h\u00fccrelerde s\u0131ras\u0131yla YANLI\u015e de\u011ferini ve YANLI\u015e fonksiyonunu kulland\u0131k ve her iki de\u011fer i\u00e7in de ayn\u0131 sonu\u00e7 elde edildi.<\/li><li> <strong>BE\u015e\u0130NC\u0130<\/strong> ve <strong>ALTINCI&#8217;da<\/strong> TRUE ve FALSE mant\u0131ksal de\u011ferleri de 1 ve 0 say\u0131sal de\u011ferlerine sahiptir ancak ISLOGICAL bu dijital mant\u0131ksal de\u011ferleri i\u015flemeyecektir.<\/li><li> <strong>YED\u0130<\/strong> ve <strong>SEK\u0130Z\u0130NC\u0130&#8217;de<\/strong> de\u011ferlendirme yapmak i\u00e7in metin de\u011ferlerini kulland\u0131k ve FALSE de\u011ferini d\u00f6nd\u00fcrd\u00fc.<\/li><li> <strong>NINTH&#8217;de<\/strong> bo\u015f bir h\u00fccre kulland\u0131k, FALSE de\u011ferini d\u00f6nd\u00fcrd\u00fc ve <strong>ONUNCU&#8217;da<\/strong> de\u011fer bir hata i\u00e7eriyorsa #YOK de\u011ferini d\u00f6nd\u00fcrd\u00fc.<\/li><\/ul><h2 class=\"wp-block-heading\"> 9. ISNA i\u015flevi<\/h2><p> <strong>Sa\u011flanan de\u011fer (veya ba\u015fvurulan h\u00fccredeki de\u011fer) bir #YOK hatas\u0131 ise ISNA i\u015flevi DO\u011eRU de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/strong> Basit bir ifadeyle, yaln\u0131zca #YOK&#8217;u dikkate al\u0131r ve her \u015fey i\u00e7in DO\u011eRU ve YANLI\u015e de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>ISNA(de\u011fer)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>de\u011fer:<\/strong> H\u00fccre referans\u0131 veya test etmek istedi\u011finiz bir de\u011fer.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> Yaln\u0131zca #N\/A dikkate al\u0131n\u0131r, di\u011fer hata de\u011ferleri g\u00f6z ard\u0131 edilir.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte farkl\u0131 hata de\u011ferlerini kontrol etmek i\u00e7in ISNA&#8217;y\u0131 kulland\u0131k ve yaln\u0131zca #N\/A hata de\u011feri durumunda TRUE elde ettik. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37086\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-nest-pas-une-fonction-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-isna-i\u015flevi-\u00f6rnek-1\" width=\"325\" height=\"442\"><\/figure><\/div><p> A\u015fa\u011f\u0131daki \u00f6rnekte, kullan\u0131c\u0131ya anlaml\u0131 bir mesaj iletmek i\u00e7in ISNA ile birlikte IF ve D\u00dc\u015eEYARA&#8217;y\u0131 kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37087\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-nest-pas-une-fonction-exemple-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-isna-fonksiyon-\u00f6rnek-2\" width=\"611\" height=\"459\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 10. MET\u0130N OLMAYAN i\u015flevi<\/h2><p> <strong>ISNONTEXT i\u015flevi, sa\u011flanan de\u011fer (veya ba\u015fvurulan h\u00fccredeki de\u011fer) metin olmayan bir de\u011ferse TRUE de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/strong> Metinsel olmayan anlamlarla, say\u0131, tarih, sembol vb. anlam\u0131na gelir.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>ISNONTEXT(de\u011fer)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>de\u011fer:<\/strong> test etmek istedi\u011finiz bir h\u00fccre veya de\u011fer.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> Bir say\u0131 \u00e7ift t\u0131rnak i\u00e7ine al\u0131nm\u0131\u015fsa metin olarak kabul edilir ve form\u00fcl YANLI\u015e de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte h\u00fccreye metin d\u0131\u015f\u0131 bir de\u011fer girdi\u011finde kullan\u0131c\u0131ya mesaj g\u00f6ndermek i\u00e7in IF ile birlikte kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37089\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-nest-pas-un-exemple-de-fonction-textuelle-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-isnontext-i\u015flev-\u00f6rnek-1\" width=\"528\" height=\"305\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 11. ISNUMBER i\u015flevi<\/h2><p> <strong>Sa\u011flanan de\u011fer (veya ba\u015fvurulan h\u00fccredeki de\u011fer) bir say\u0131ysa ISNUM i\u015flevi TRUE de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/strong> Basit bir ifadeyle, yaln\u0131zca say\u0131sal de\u011feri dikkate al\u0131r ve gerisini g\u00f6z ard\u0131 eder.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>ESTNUM(de\u011fer)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>de\u011fer:<\/strong> kontrol etmek istedi\u011finiz say\u0131sal bir de\u011fer.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> \u00c7ift t\u0131rnak i\u00e7indeki say\u0131lar metin olarak de\u011ferlendirilecektir.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte, kullan\u0131c\u0131 F1 h\u00fccresine say\u0131sal olmayan bir de\u011fer girdi\u011finde uyar\u0131 mesaj\u0131 g\u00f6ndermek i\u00e7in IF ile birlikte ISNUMBER&#8217;\u0131 kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37091\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-isnumber-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-isnumber-fonksiyon-\u00f6rnek-1\" width=\"613\" height=\"299\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 12. ISODD i\u015flevi<\/h2><p> <strong>Sa\u011flanan de\u011fer (veya ba\u015fvurulan h\u00fccredeki de\u011fer) bir TEK say\u0131 ise ISODD i\u015flevi DO\u011eRU de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/strong> Basit bir ifadeyle, e\u011fer de\u011fer 2&#8217;ye b\u00f6l\u00fcnebilen bir say\u0131 ise DO\u011eRU, aksi durumda YANLI\u015e de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>ISODD(de\u011fer)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>de\u011fer:<\/strong> tek olup olmad\u0131\u011f\u0131n\u0131 test etmek istedi\u011finiz say\u0131.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> De\u011fer bir say\u0131 de\u011filse #DE\u011eER hatas\u0131 d\u00f6nd\u00fcr\u00fcl\u00fcr.<\/li><li> Bir say\u0131 \u00e7ift t\u0131rnak i\u00e7ine al\u0131nm\u0131\u015fsa, bu say\u0131y\u0131 metin olarak de\u011ferlendirecek ve YANLI\u015e de\u011ferini d\u00f6nd\u00fcrecektir.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte, h\u00fccrede tek say\u0131 d\u0131\u015f\u0131nda bir say\u0131 varsa kullan\u0131c\u0131ya uyar\u0131 mesaj\u0131 g\u00f6ndermek i\u00e7in IF ile ISODD&#8217;yi kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37093\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-isodd-excel-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-isodd-fonksiyonu-\u00f6rnek-1\" width=\"581\" height=\"252\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 13. ISREF i\u015flevi<\/h2><p> <strong>ISREF i\u015flevi, ba\u015fvurulan de\u011fer ge\u00e7erli bir ba\u015fvuruysa DO\u011eRU&#8217;yu, aksi halde YANLI\u015e&#8217;\u0131 d\u00f6nd\u00fcr\u00fcr.<\/strong> Basit bir ifadeyle, bir metin de\u011ferinin ge\u00e7erli bir referans olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in ISREF&#8217;i kullanabilirsiniz.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>ISREF(de\u011fer)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>de\u011fer:<\/strong> ge\u00e7erli bir referans bulmak istedi\u011finiz de\u011fer.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> Ge\u00e7erli bir referans adresi \u00e7ift t\u0131rnak i\u00e7ine al\u0131nm\u0131\u015fsa, ISREF bu referans\u0131 test edemeyecek ve bu referans ge\u00e7erli olsa bile FALSE de\u011ferini d\u00f6nd\u00fcrecektir.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte meyve ge\u00e7erli bir adland\u0131r\u0131lm\u0131\u015f aral\u0131kt\u0131r ancak \u00e7ift t\u0131rnak kulland\u0131\u011f\u0131n\u0131zda ISREF bu referans\u0131 test edemez. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37095\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-isref-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-isref-fonksiyonu-\u00f6rnek-1\" width=\"524\" height=\"345\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 14.ISTEXT i\u015flevi<\/h2><p> <strong>ISTEXT i\u015flevi, sa\u011flanan de\u011fer (veya ba\u015fvurulan h\u00fccredeki de\u011fer) metin ise TRUE de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/strong> Basit bir ifadeyle, yaln\u0131zca metni dikkate al\u0131r ve di\u011fer t\u00fcm de\u011fer t\u00fcrlerini g\u00f6z ard\u0131 eder.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>ISTEXT(de\u011fer)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>de\u011fer:<\/strong> test etmek istedi\u011finiz h\u00fccrenin referans\u0131 veya de\u011feri.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> \u00c7ift t\u0131rnak i\u00e7ine al\u0131nan herhangi bir say\u0131 metin olarak de\u011ferlendirilecektir.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte, kullan\u0131c\u0131n\u0131n ge\u00e7ersiz bir ad (metin d\u0131\u015f\u0131nda) girmesi durumunda bir uyar\u0131 mesaj\u0131 iletmek \u00fczere bir i\u00e7 i\u00e7e ge\u00e7me form\u00fcl\u00fc olu\u015fturmak i\u00e7in ISTEXT&#8217;i IF ile birlikte kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37097\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-istext-excel-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-istext-i\u015flev-\u00f6rnek-1\" width=\"676\" height=\"219\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 15. \u0130\u015flevN<\/h2><p> <strong>N i\u015flevi bir Boolean&#8217;\u0131 say\u0131ya d\u00f6n\u00fc\u015ft\u00fcr\u00fcr.<\/strong> Basit bir ifadeyle DO\u011eRU&#8217;yu 1&#8217;e ve YANLI\u015e&#8217;\u0131 2&#8217;ye d\u00f6n\u00fc\u015ft\u00fcr\u00fcr. Bu say\u0131lar Boolean de\u011ferlerinin ger\u00e7ek de\u011feridir.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>N(de\u011fer)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>de\u011fer:<\/strong> say\u0131ya d\u00f6n\u00fc\u015ft\u00fcrmek istedi\u011finiz bir boole<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> Ger\u00e7ek hayatta N&#8217;nin ayr\u0131 bir i\u015flev olarak hi\u00e7bir faydas\u0131 yoktur, \u00e7\u00fcnk\u00fc Excel gerekirse Boolean&#8217;lar\u0131 otomatik olarak say\u0131lara d\u00f6n\u00fc\u015ft\u00fcrebilir.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte, bir form\u00fcle yorum eklemek i\u00e7in N 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-37205\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-n-fonction-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-n-i\u015flevi-\u00f6rnek-1\" width=\"548\" height=\"418\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 16. Yok i\u015flevi<\/h2><p> <strong>NA i\u015flevi #N\/A de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/strong> Basit bir ifadeyle, NA i\u015flevi sonu\u00e7ta #N\/A hata de\u011ferini d\u00f6nd\u00fcr\u00fcr. NA i\u015flevinin en iyi kullan\u0131m\u0131, bir h\u00fccrede bo\u015f ve eksik bilgi oldu\u011funda hata almakt\u0131r.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>Yok(de\u011fer)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> NA&#8217;da hi\u00e7bir tart\u0131\u015fma yoktur.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> #YOK hatas\u0131 d\u00f6nd\u00fcrmek i\u00e7in NA&#8217;y\u0131 i\u015flevlerle birlikte kullanabilirsiniz.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte, NA i\u015flevini A1 h\u00fccresine ekledik ve bu yaln\u0131zca #YOK sonucunu 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-37207\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-na-fonction-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-na-i\u015flev-\u00f6rnek-1\" width=\"392\" height=\"240\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 17. SAYFA i\u015flevi<\/h2><p> <strong>SHEET i\u015flevi, kullan\u0131lan referans\u0131n sayfa numaras\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/strong> Basit bir ifadeyle SHEET i\u015flevi, i\u015flevde bahsetti\u011finiz aral\u0131\u011f\u0131n \u00e7al\u0131\u015fma sayfas\u0131 numaras\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>SAYFA(de\u011fer)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>[de\u011fer]:<\/strong> sayfan\u0131n ad\u0131 veya sayfadaki herhangi bir h\u00fccreye yap\u0131lan ba\u015fvuru<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> T\u00fcm sayfa t\u00fcrlerini (grafik sayfas\u0131, \u00e7al\u0131\u015fma sayfas\u0131 veya makro sayfas\u0131) i\u00e7erecektir.<\/li><li> G\u00f6r\u00fcn\u00fcr, gizli veya \u00e7ok gizli olsalar bile foliolara referans verebilirsiniz.<\/li><li> Fonksiyonda herhangi bir de\u011fer belirtmezseniz size fonksiyonu uygulad\u0131\u011f\u0131n\u0131z sayfan\u0131n sayfa numaras\u0131n\u0131 verecektir.<\/li><li> Ge\u00e7ersiz bir sayfa ad\u0131 belirtirseniz #YOK sonucunu d\u00f6nd\u00fcr\u00fcr.<\/li><li> Ge\u00e7ersiz bir sayfa referans\u0131 belirtirseniz #REF! sonucunu d\u00f6nd\u00fcr\u00fcr.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte sayfa numaras\u0131n\u0131 almak i\u00e7in farkl\u0131 girdiler kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37320\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-feuille-excel-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-sayfa-fonksiyonu-\u00f6rnek-1\" width=\"495\" height=\"290\"><\/figure><\/div><p> Ge\u00e7ersiz bir sayfa ad\u0131m\u0131z ve ge\u00e7ersiz bir sayfa referans\u0131m\u0131z oldu\u011funda, SHEET i\u015flevi bir hata d\u00f6nd\u00fcrd\u00fc.<\/p><h2 class=\"wp-block-heading\"> 18. YAPRAKLAR i\u015flevi<\/h2><p> <strong>SAYFALAR i\u015flevi, ba\u015fvurulan aral\u0131ktaki \u00e7al\u0131\u015fma sayfalar\u0131n\u0131n say\u0131s\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/strong> Basit\u00e7e s\u00f6ylemek gerekirse, SAYFALAR i\u015fleviyle, referans verdi\u011finiz aral\u0131ktaki sayfa say\u0131s\u0131n\u0131 sayabilirsiniz.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>SAYFALAR (referans)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>referans:<\/strong> sayfa say\u0131s\u0131n\u0131 saymak istedi\u011finiz referans.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> T\u00fcm sayfa t\u00fcrlerini (grafik sayfas\u0131, \u00e7al\u0131\u015fma sayfas\u0131 veya makro sayfas\u0131) i\u00e7erecektir.<\/li><li> Foliolara g\u00f6r\u00fcn\u00fcr, gizli veya \u00e7ok gizli olsalar bile ba\u015fvurabilirsiniz.<\/li><li> \u0130\u015flevde herhangi bir de\u011fer belirtmezseniz, size \u00e7al\u0131\u015fma kitab\u0131ndaki toplam sayfa say\u0131s\u0131n\u0131 verecektir.<\/li><li> Ge\u00e7ersiz bir referans belirtirseniz #REF! sonucunu d\u00f6nd\u00fcr\u00fcr.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte, be\u015f sayfadan A1 h\u00fccresinin toplam\u0131n\u0131 almak i\u00e7in <a href=\"https:\/\/exceladvisor.org\/tr\/referans-3d\/\">3 boyutlu h\u00fccre referans\u0131n\u0131<\/a> , sayfa say\u0131s\u0131n\u0131 bulmak i\u00e7in de ayn\u0131 referans\u0131 kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37322\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/feuilles-excel-exemple-de-fonction-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-sayfa-i\u015flevi-\u00f6rnek-1\" width=\"592\" height=\"332\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 19. T\u0130P i\u015flevi<\/h2><p> <strong>TYPE i\u015flevi, sa\u011flanan de\u011ferin t\u00fcr\u00fcn\u00fc temsil eden bir say\u0131 d\u00f6nd\u00fcr\u00fcr.<\/strong> Basit bir ifadeyle TYPE i\u015flevi, sa\u011flanan de\u011ferin t\u00fcr\u00fcn\u00fc temsil eden belirli bir say\u0131y\u0131 d\u00f6nd\u00fcr\u00fcr.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>T\u00dcR(de\u011fer)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>de\u011fer<\/strong> \u2013 T\u00fcr\u00fcn\u00fc test etmek istedi\u011finiz h\u00fccreye veya de\u011fere ba\u015fvuru.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> Form\u00fcl i\u00e7eren bir h\u00fccrenin de\u011ferini test etti\u011finizde, h\u00fccre o form\u00fcl\u00fcn d\u00f6nd\u00fcrd\u00fc\u011f\u00fc de\u011feri de test eder.<\/li><li> Bo\u015f bir h\u00fccreye ba\u015fvurursan\u0131z buna g\u00f6re 1 say\u0131s\u0131n\u0131 d\u00f6nd\u00fcrecektir.<\/li><li> Tarih i\u00e7eren bir h\u00fccreye ba\u015fvurursan\u0131z, tarihin say\u0131 de\u011feri oldu\u011fundan sonu\u00e7 olarak 1 de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki form\u00fclde IF ile birlikte TYPE&#8217;\u0131 kulland\u0131k. <\/p><pre class=\"wp-block-preformatted\"> =IF(TYPE(F3)&lt;&gt;1,\u201dEnter Valid Quantity\u201d,E3*F3) <\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36239\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-type-excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-tip-i\u015flev-\u00f6rne\u011fi\" width=\"531\" height=\"387\"><\/figure><\/div><p> Bu form\u00fclde TYPE, de\u011ferin t\u00fcr\u00fcn\u00fc temsil eden bir say\u0131 d\u00f6nd\u00fcr\u00fcr ve ard\u0131ndan IF&#8217;de bir ko\u015ful vard\u0131r. Bu say\u0131n\u0131n 1&#8217;e e\u015fit olmamas\u0131, verilen de\u011ferin bir say\u0131 olmad\u0131\u011f\u0131n\u0131 ve IF&#8217;nin &#8220;Ge\u00e7erli bir de\u011fer giriniz&#8221; mesaj\u0131n\u0131 d\u00f6nd\u00fcrd\u00fc\u011f\u00fcn\u00fc g\u00f6sterir. Ve e\u011fer oradaysa, miktar\u0131 fiyatla \u00e7arpar.<\/p><h2 class=\"wp-block-heading\"> <strong>20. T\u0130P HATA i\u015flevi<\/strong><\/h2><p> <strong>ERROR.TYPE i\u015flevi, h\u00fccredeki hatan\u0131n t\u00fcr\u00fcn\u00fc temsil eden bir say\u0131 d\u00f6nd\u00fcr\u00fcr.<\/strong> Excel&#8217;de her hata t\u00fcr\u00fc i\u00e7in belirli bir say\u0131 vard\u0131r ve herhangi bir hata yoksa #N\/A de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>HATA.T\u0130P\u0130 (hata_val)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>error_val:<\/strong> Hata i\u00e7in de\u011ferlendirmek istedi\u011finiz de\u011fer.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> Hatalar\u0131 test etmek i\u00e7in bunu di\u011fer i\u015flevlerle birlikte kullanabilirsiniz.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>\u00d6rnek<\/strong><\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte, bir hata olu\u015ftu\u011funda ilgili mesaj\u0131 g\u00f6r\u00fcnt\u00fclemek i\u00e7in D\u00dc\u015eEYARA ile birlikte ERROR.TYPE&#8217;\u0131 kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36917\" title=\"excel-hata-i\u015flevi-\u00f6rnek-1\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-derreur-excel-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-error-function-example-1\" width=\"669\" height=\"348\"><\/figure><\/div><p> Kullan\u0131c\u0131ya alakal\u0131 bir mesaj iletmek i\u00e7in bu y\u00f6ntemi kullanabilirsiniz.<\/p>","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-2109","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 bilgi i\u015flevleri nas\u0131l kullan\u0131l\u0131r?<\/title>\n<meta name=\"description\" content=\"Excel&#039;de de\u011fer tan\u0131kl\u0131\u011f\u0131 elde etmenize ve i\u00e7g\u00f6r\u00fcler elde etmenize yard\u0131mc\u0131 olabilecek bilgi i\u015flevleri vard\u0131r.\" \/>\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-bilgi-fonksiyonlari\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de bilgi i\u015flevleri nas\u0131l kullan\u0131l\u0131r?\" \/>\n<meta property=\"og:description\" content=\"Excel&#039;de de\u011fer tan\u0131kl\u0131\u011f\u0131 elde etmenize ve i\u00e7g\u00f6r\u00fcler elde etmenize yard\u0131mc\u0131 olabilecek bilgi i\u015flevleri vard\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/excel-bilgi-fonksiyonlari\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:00:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-cellule-excel-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-bilgi-fonksiyonlari\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/excel-bilgi-fonksiyonlari\/\",\"name\":\"Excel&#39;de bilgi i\u015flevleri nas\u0131l kullan\u0131l\u0131r?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-bilgi-fonksiyonlari\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-bilgi-fonksiyonlari\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-cellule-excel-1.png\",\"datePublished\":\"2023-10-15T13:57:11+00:00\",\"dateModified\":\"2023-12-10T06:00:23+00:00\",\"description\":\"Excel&#39;de de\u011fer tan\u0131kl\u0131\u011f\u0131 elde etmenize ve i\u00e7g\u00f6r\u00fcler elde etmenize yard\u0131mc\u0131 olabilecek bilgi i\u015flevleri vard\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-bilgi-fonksiyonlari\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/excel-bilgi-fonksiyonlari\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-bilgi-fonksiyonlari\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-cellule-excel-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-cellule-excel-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-bilgi-fonksiyonlari\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de bilgi i\u015flevleri nas\u0131l kullan\u0131l\u0131r?\"}]},{\"@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 bilgi i\u015flevleri nas\u0131l kullan\u0131l\u0131r?","description":"Excel&#39;de de\u011fer tan\u0131kl\u0131\u011f\u0131 elde etmenize ve i\u00e7g\u00f6r\u00fcler elde etmenize yard\u0131mc\u0131 olabilecek bilgi i\u015flevleri vard\u0131r.","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-bilgi-fonksiyonlari\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de bilgi i\u015flevleri nas\u0131l kullan\u0131l\u0131r?","og_description":"Excel&#39;de de\u011fer tan\u0131kl\u0131\u011f\u0131 elde etmenize ve i\u00e7g\u00f6r\u00fcler elde etmenize yard\u0131mc\u0131 olabilecek bilgi i\u015flevleri vard\u0131r.","og_url":"https:\/\/exceladvisor.org\/tr\/excel-bilgi-fonksiyonlari\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:00:23+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-cellule-excel-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-bilgi-fonksiyonlari\/","url":"https:\/\/exceladvisor.org\/tr\/excel-bilgi-fonksiyonlari\/","name":"Excel&#39;de bilgi i\u015flevleri nas\u0131l kullan\u0131l\u0131r?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/excel-bilgi-fonksiyonlari\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/excel-bilgi-fonksiyonlari\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-cellule-excel-1.png","datePublished":"2023-10-15T13:57:11+00:00","dateModified":"2023-12-10T06:00:23+00:00","description":"Excel&#39;de de\u011fer tan\u0131kl\u0131\u011f\u0131 elde etmenize ve i\u00e7g\u00f6r\u00fcler elde etmenize yard\u0131mc\u0131 olabilecek bilgi i\u015flevleri vard\u0131r.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/excel-bilgi-fonksiyonlari\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/excel-bilgi-fonksiyonlari\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/excel-bilgi-fonksiyonlari\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-cellule-excel-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-cellule-excel-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/excel-bilgi-fonksiyonlari\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de bilgi i\u015flevleri nas\u0131l kullan\u0131l\u0131r?"}]},{"@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\/2109","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=2109"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2109\/revisions"}],"predecessor-version":[{"id":2402,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2109\/revisions\/2402"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=2109"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}