{"id":1700,"date":"2023-11-10T18:13:57","date_gmt":"2023-11-10T18:13:57","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/maksimum-ise\/"},"modified":"2023-12-10T06:01:36","modified_gmt":"2023-12-10T06:01:36","slug":"maksimum-ise","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/maksimum-ise\/","title":{"rendered":"Excel&#39;de max if nas\u0131l kullan\u0131l\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-3871663375\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Excel&#8217;de, varsay\u0131lan MAX i\u015flevini yaln\u0131zca bir ko\u015fulla kullanamay\u0131z (Microsoft Office 365 kullanmad\u0131\u011f\u0131n\u0131z s\u00fcrece).<\/p><p> Ancak sorun \u015fu ki, belirli bir ko\u015fulu kullanarak bir aral\u0131\u011f\u0131n maksimum de\u011ferini elde etmek istiyorsan\u0131z MAX IF form\u00fcl\u00fcne ihtiyac\u0131n\u0131z vard\u0131r.<\/p><p> Peki ama\u00e7 ne?<\/p><p> Belirli kriterleri kullanarak bir aral\u0131\u011f\u0131n maksimum de\u011ferini elde etmenize yard\u0131mc\u0131 olabilecek bir form\u00fcl olu\u015fturmak i\u00e7in MAX ve IF&#8217;yi birle\u015ftirebilirsiniz.<\/p><p> K\u0131saca: MAXIF, kriterleri kullanarak bir aral\u0131\u011f\u0131n maksimum de\u011ferini bulmak i\u00e7in kullanabilece\u011finiz bir dizi form\u00fcl\u00fcd\u00fcr. Ancak i\u015fin ilgin\u00e7 yan\u0131 \u015fu: Bu makalede sizinle MAXIF form\u00fcl\u00fcn\u00fc kullanman\u0131n farkl\u0131 yollar\u0131n\u0131 payla\u015faca\u011f\u0131m.<\/p><h2 id=\"tab-con-1\" class=\"wp-block-heading\"> MAX IF form\u00fcl\u00fcn\u00fc uygulay\u0131n<\/h2><p> Ayl\u0131k, haftal\u0131k ve tarih ba\u015f\u0131na sat\u0131\u015f miktar\u0131n\u0131n bulundu\u011fu a\u015fa\u011f\u0131daki verilere bir \u00f6rnek verelim. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/donnees-de-quantite-de-ventes-a-utiliser-max-si-formule-min-1.png\" sizes=\"\" srcset=\"\" alt=\"max if form\u00fcl\u00fc kullan\u0131lacak sat\u0131\u015f miktar\u0131 verileri\"><\/figure><\/div><p> \u015eimdi bu verilerden belirli bir ay i\u00e7in maksimum sat\u0131\u015f miktar\u0131n\u0131 elde etmeniz gerekiyor. \u00d6rne\u011fin \u201cJan\u201d ve bunun i\u00e7in form\u00fcl \u015f\u00f6yle olacakt\u0131r:<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=MAX(IF(A2:A367=\"Jan\",D2:D367))<\/code><\/pre><p> Ve ctrl+shift+enter tu\u015flar\u0131n\u0131 kullanarak dizi form\u00fcl\u00fc olarak girmeniz gerekiyor. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">{=MAX(IF(A2:A367=\"Jan\",D2:D367))}<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/max-si-formule-appliquee-min-1.png\" sizes=\"\" srcset=\"\" alt=\"form\u00fcl uyguland\u0131\u011f\u0131nda maksimum\"><\/figure><\/div><p> Girdi\u011finizde 07-Ocak-2016 Ocak ay\u0131n\u0131n en y\u00fcksek sat\u0131\u015f de\u011feri olan 200 de\u011ferini d\u00f6nd\u00fcrecektir.<\/p><h3 class=\"wp-block-heading\"> Bu nas\u0131l \u00e7al\u0131\u015f\u0131r<\/h3><p id=\"tab-con-2\"> Max&#8217;in nas\u0131l \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 anlamak i\u00e7in onu \u00fc\u00e7 par\u00e7aya b\u00f6lmeniz gerekir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comprendre-max-si-la-formule-dans-excel-1.png\" sizes=\"\" srcset=\"\" alt=\"excel'de max i-form\u00fcl\u00fcn\u00fc anlay\u0131n\"><\/figure><\/div><p> L\u00fctfen <strong><span style=\"color: #000000;\">bunu bir dizi form\u00fcl\u00fc olarak girdi\u011finize<\/span><\/strong> dikkat edin.<\/p><p> <span style=\"color: #000000;\">\u0130lk olarak<\/span> , ay s\u00fctununun tamam\u0131n\u0131 kriterlerle e\u015fle\u015ftirmek i\u00e7in IF i\u015flevinde bir mant\u0131k testi olu\u015fturdunuz. Ve e\u015fle\u015fme de\u011ferlerinin DO\u011eRU, di\u011ferlerinin ise YANLI\u015e oldu\u011fu bir dizi d\u00f6nd\u00fcrd\u00fc. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/premier-tableau-avec-max-si-formule-avec-tableau-min-1.png\" sizes=\"\" srcset=\"\" alt=\"max ile ilk dizi if form\u00fcl\u00fc ile dizi\"><\/figure><\/div><p> <span style=\"color: #000000;\">\u0130kinci olarak<\/span> IF fonksiyonunda TRUE de\u011ferleri i\u00e7in sat\u0131\u015f miktar\u0131 s\u00fctununu belirttiniz ve bu nedenle sat\u0131\u015f miktar\u0131n\u0131 yaln\u0131zca TRUE olarak d\u00f6nd\u00fcrd\u00fc. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/deuxieme-tableau-de-max-si-formule-avec-tableau-min-1.png\" sizes=\"\" srcset=\"\" alt=\"dizili form\u00fcl if form\u00fcl\u00fcnde ikinci max dizisi\"><\/figure><\/div><p> <span style=\"color: #000000;\">\u00dc\u00e7\u00fcnc\u00fcs\u00fc<\/span> , MAX i\u015flevi bu dizideki en y\u00fcksek say\u0131y\u0131 d\u00f6nd\u00fcr\u00fcr; bu say\u0131, Ocak ay\u0131 i\u00e7in en y\u00fcksek sat\u0131\u015f miktar\u0131na kar\u015f\u0131l\u0131k gelir. T\u0131pk\u0131 buradaki bu form\u00fcl hilesi gibi, okuman\u0131z ve \u00f6\u011frenmeniz gereken di\u011ferlerinden baz\u0131lar\u0131n\u0131 listeledim.<\/p><ol><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sumif-sumifler-veya-mantik\/\">Excel&#8217;de SUMIFOR<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kosullu-siralama-toplami-carpim-siralamasi-eger\/\">Excel&#8217;de RANKIF<\/a><\/li><\/ol><h2 id=\"tab-con-3\" class=\"wp-block-heading\"> MAX IF birden fazla kriterle<\/h2><p> Eminim bu noktada max if&#8217;de birden fazla ko\u015fulu nas\u0131l kullanabilece\u011fimizi d\u00fc\u015f\u00fcn\u00fcyorsunuzdur. Ve bu ak\u0131ll\u0131ca bir d\u00fc\u015f\u00fcnce.<\/p><p> Ger\u00e7ek veri d\u00fcnyas\u0131nda en y\u00fcksek de\u011feri elde etmek i\u00e7in birden fazla kriter kullanmam\u0131z gerekebilir. \u00d6nceki \u00f6rnekle devam edelim.<\/p><p> Diyelim ki Ocak ay\u0131n\u0131n en y\u00fcksek sat\u0131\u015f de\u011feri yerine Ocak ay\u0131n\u0131n 2. haftas\u0131nda en y\u00fcksek sat\u0131\u015flar\u0131 alman\u0131z gerekiyor.<\/p><p> Yani burada iki farkl\u0131 ko\u015ful var; ay Ocak ve hafta 2. Ve form\u00fcl \u015f\u00f6yle olacak:<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=MAX(IF(A2:A367=F5,IF(B2:B367=G5,D2:D367),))<\/code><\/pre><p> Ve bunu tablo olarak girdi\u011finizde: <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">{=MAX(IF(A2:A367=F5,IF(B2:B367=G5,D2:D367),))}<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/plusieurs-criteres-avec-max-si-formule-min-1.png\" sizes=\"\" srcset=\"\" alt=\"max if form\u00fcl\u00fcyle birden fazla kriter\"><\/figure><\/div><h3 id=\"tab-con-4\" class=\"wp-block-heading\"> Bu nas\u0131l \u00e7al\u0131\u015f\u0131r<\/h3><p> Burada birden fazla mant\u0131\u011f\u0131 test etmek i\u00e7in i\u00e7 i\u00e7e IF&#8217;yi kulland\u0131k. Biri ayl\u0131k, ikincisi haftal\u0131k.<\/p><p> Bu nedenle, yaln\u0131zca ay\u0131n Ocak ve haftan\u0131n 2. oldu\u011fu durumlarda sat\u0131\u015f miktar\u0131n\u0131n bulundu\u011fu bir tablo d\u00f6nd\u00fcr\u00fcr. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/criteres-multiples-avec-max-si-formule-premier-tableau-min-1.png\" sizes=\"\" srcset=\"\" alt=\"max if form\u00fcl\u00fcn\u00fcn ilk tablosu ile \u00e7e\u015fitli kriterler\"><\/figure><\/div><p> Ve sonunda max bu dizinin maksimum de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/p><h2 id=\"tab-con-5\" class=\"wp-block-heading\"> MAX IF tablosuz<\/h2><p> Tablolar g\u00fc\u00e7l\u00fcd\u00fcr ancak herkes onlar\u0131 kullanmak istemez. Ve max if&#8217;te bir dizi kullanmama se\u00e7ene\u011finiz vard\u0131r.<\/p><p> Yani bunun i\u00e7in, ger\u00e7ek dizi form\u00fcl\u00fcn\u00fc uygulamadan bir diziyi kullanman\u0131za yard\u0131mc\u0131 olabilece\u011finden SUMproduct i\u015flevini kullanabilirsiniz. Ve form\u00fcl \u015f\u00f6yle olacak:<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMPRODUCT(MAX((A2:A367=\"Jan\")*D2:D367))<\/code><\/pre><p> Yani bu form\u00fcl\u00fc ekledi\u011finizde ctrl+shift+enter tu\u015flar\u0131na basman\u0131za gerek kalm\u0131yor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/max-si-formule-sans-tableaux-utilisant-sumproduct-min-1.png\" sizes=\"\" srcset=\"\" alt=\"sumproduct kullanan diziler olmadan max if form\u00fcl\u00fc\"><\/figure><\/div><h3 id=\"tab-con-6\" class=\"wp-block-heading\"> Bu nas\u0131l \u00e7al\u0131\u015f\u0131r<\/h3><p> Yine bu form\u00fcl\u00fc anlamak i\u00e7in \u00fc\u00e7 farkl\u0131 par\u00e7aya ay\u0131rmam\u0131z gerekiyor. \u0130lk b\u00f6l\u00fcmde ay s\u00fctununu kriterlerle kar\u015f\u0131la\u015ft\u0131rd\u0131n\u0131z ve kriterlerin e\u015fle\u015fti\u011fi yerde TRUE, aksi halde YANLI\u015e olan bir dizi d\u00f6nd\u00fcrd\u00fc. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comparer-mois-max-si-formule-avec-sumproduct-min-1.png\" sizes=\"\" srcset=\"\" alt=\"maksimum ay\u0131 if form\u00fcl\u00fcn\u00fc toplam \u00fcr\u00fcnle kar\u015f\u0131la\u015ft\u0131r\u0131n\"><\/figure><\/div><p> Daha sonra bu tabloyu, DO\u011eRU yerine sat\u0131\u015f miktar\u0131n\u0131n bulundu\u011fu bir tablo d\u00f6nd\u00fcren sat\u0131\u015f miktar\u0131 s\u00fctunuyla \u00e7arpars\u0131n\u0131z. Sonu\u00e7ta MAX i\u015flevi, bu dizideki en y\u00fcksek sat\u0131\u015f miktar\u0131n\u0131za kar\u015f\u0131l\u0131k gelen en y\u00fcksek de\u011feri d\u00f6nd\u00fcrd\u00fc.<\/p><p> T\u00fcm bu form\u00fcl, sumproduct&#8217;\u0131n ana rol\u00fc, ger\u00e7ek bir dizi form\u00fcl\u00fc girmeden bir dizi kullanman\u0131za olanak sa\u011flamakt\u0131r.<\/p><h2 class=\"wp-block-heading\"> \u00c7\u00f6z\u00fcm<\/h2><p> Kriterlere g\u00f6re maksimum de\u011feri elde etmek s\u0131kl\u0131kla yapmam\u0131z gereken \u015feydir. Ve bu max if form\u00fcl\u00fc tekni\u011fini kullanarak bunu zahmetsizce yapabilirsiniz.<\/p><p> Yukar\u0131da \u00f6\u011frendi\u011finiz y\u00f6ntemlerin hepsinin duruma g\u00f6re farkl\u0131 uygulamalar\u0131 vard\u0131r. Umar\u0131m bu form\u00fcl ipucu Excel&#8217;de daha iyi olman\u0131za yard\u0131mc\u0131 olur. Ama \u015fimdi bana bir \u015feyi s\u00f6yle.<\/p><p> Hangisini ger\u00e7ekten seviyorsunuz, tabloyu mu yoksa tablosuz mu?<\/p><p> L\u00fctfen g\u00f6r\u00fc\u015flerinizi yorum k\u0131sm\u0131nda benimle payla\u015f\u0131n. Sizden haber almay\u0131 \u00e7ok isterim ve l\u00fctfen bu g\u00f6nderiyi arkada\u015flar\u0131n\u0131zla payla\u015fmay\u0131 unutmay\u0131n, eminim onlar da bunu takdir edeceklerdir. <\/p><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Excel dosyas\u0131n\u0131 al\u0131n<\/h2><p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/max-si-3.xlsx\" rel=\"nofollow\">\u0130ndirmek<\/a><\/p><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/tr\/formuller\/\">Excel form\u00fcllerinin listesi<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> \u0130lgili form\u00fcller <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/varyasyon-katsayisi\/\">Excel&#8217;de varyasyon katsay\u0131s\u0131n\u0131 (CV) hesaplay\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/rapor\/\">Excel&#8217;de oran\u0131 h\u0131zla hesaplay\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/en-dusuk-deger\/\">Say\u0131 listesinden en d\u00fc\u015f\u00fck de\u011feri bulun (N)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/en-kucuk-deger-2\/\">Bir h\u00fccre aral\u0131\u011f\u0131ndaki en k\u00fc\u00e7\u00fck de\u011feri bulun (en k\u00fc\u00e7\u00fck say\u0131)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ninci-kok-2\/\">N&#8217;inci k\u00f6k\u00fc hesapla<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/div><\/div><\/div><\/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-1700","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 MAX IF nas\u0131l kullan\u0131l\u0131r? [Tam k\u0131lavuz 2023]<\/title>\n<meta name=\"description\" content=\"Excel&#039;de bunun i\u00e7in \u00f6zel bir i\u015flev yoktur. Ancak MAX ve IF&#039;yi birle\u015ftirip bir form\u00fcl olu\u015fturabilirsiniz.\" \/>\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\/maksimum-ise\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de MAX IF nas\u0131l kullan\u0131l\u0131r? [Tam k\u0131lavuz 2023]\" \/>\n<meta property=\"og:description\" content=\"Excel&#039;de bunun i\u00e7in \u00f6zel bir i\u015flev yoktur. Ancak MAX ve IF&#039;yi birle\u015ftirip bir form\u00fcl olu\u015fturabilirsiniz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/maksimum-ise\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:01:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/donnees-de-quantite-de-ventes-a-utiliser-max-si-formule-min-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=\"5 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/maksimum-ise\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/maksimum-ise\/\",\"name\":\"Excel&#39;de MAX IF nas\u0131l kullan\u0131l\u0131r? [Tam k\u0131lavuz 2023]\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/maksimum-ise\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/maksimum-ise\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/donnees-de-quantite-de-ventes-a-utiliser-max-si-formule-min-1.png\",\"datePublished\":\"2023-11-10T18:13:57+00:00\",\"dateModified\":\"2023-12-10T06:01:36+00:00\",\"description\":\"Excel&#39;de bunun i\u00e7in \u00f6zel bir i\u015flev yoktur. Ancak MAX ve IF&#39;yi birle\u015ftirip bir form\u00fcl olu\u015fturabilirsiniz.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/maksimum-ise\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/maksimum-ise\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/maksimum-ise\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/donnees-de-quantite-de-ventes-a-utiliser-max-si-formule-min-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/donnees-de-quantite-de-ventes-a-utiliser-max-si-formule-min-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/maksimum-ise\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de max if 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 MAX IF nas\u0131l kullan\u0131l\u0131r? [Tam k\u0131lavuz 2023]","description":"Excel&#39;de bunun i\u00e7in \u00f6zel bir i\u015flev yoktur. Ancak MAX ve IF&#39;yi birle\u015ftirip bir form\u00fcl olu\u015fturabilirsiniz.","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\/maksimum-ise\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de MAX IF nas\u0131l kullan\u0131l\u0131r? [Tam k\u0131lavuz 2023]","og_description":"Excel&#39;de bunun i\u00e7in \u00f6zel bir i\u015flev yoktur. Ancak MAX ve IF&#39;yi birle\u015ftirip bir form\u00fcl olu\u015fturabilirsiniz.","og_url":"https:\/\/exceladvisor.org\/tr\/maksimum-ise\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:01:36+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/donnees-de-quantite-de-ventes-a-utiliser-max-si-formule-min-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"5 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/maksimum-ise\/","url":"https:\/\/exceladvisor.org\/tr\/maksimum-ise\/","name":"Excel&#39;de MAX IF nas\u0131l kullan\u0131l\u0131r? [Tam k\u0131lavuz 2023]","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/maksimum-ise\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/maksimum-ise\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/donnees-de-quantite-de-ventes-a-utiliser-max-si-formule-min-1.png","datePublished":"2023-11-10T18:13:57+00:00","dateModified":"2023-12-10T06:01:36+00:00","description":"Excel&#39;de bunun i\u00e7in \u00f6zel bir i\u015flev yoktur. Ancak MAX ve IF&#39;yi birle\u015ftirip bir form\u00fcl olu\u015fturabilirsiniz.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/maksimum-ise\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/maksimum-ise\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/maksimum-ise\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/donnees-de-quantite-de-ventes-a-utiliser-max-si-formule-min-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/donnees-de-quantite-de-ventes-a-utiliser-max-si-formule-min-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/maksimum-ise\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de max if 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\/1700","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=1700"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1700\/revisions"}],"predecessor-version":[{"id":2543,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1700\/revisions\/2543"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1700"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}