{"id":2152,"date":"2023-09-28T18:49:51","date_gmt":"2023-09-28T18:49:51","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/eger-2\/"},"modified":"2023-12-10T06:07:44","modified_gmt":"2023-12-10T06:07:44","slug":"eger-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/eger-2\/","title":{"rendered":"Vba&#39;da if ifadesi else ile nas\u0131l kullan\u0131l\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-1574114942\"><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>\u0130leri d\u00fczey bir VBA kullan\u0131c\u0131s\u0131 olmak istiyorsan\u0131z IF ifadesi \u015fartt\u0131r. Ve IF kelimesini zaten bildi\u011finize ve bunu bir elektronik tablo i\u015flevi olarak s\u0131kl\u0131kla kulland\u0131\u011f\u0131n\u0131za inan\u0131yorum.<\/p><p> VBA&#8217;da IF ayn\u0131 \u015fekilde \u00e7al\u0131\u015f\u0131r. Temel fikri, bir ko\u015ful DO\u011eRU oldu\u011funda bir g\u00f6revi ger\u00e7ekle\u015ftirmek, aksi halde hi\u00e7bir \u015fey yapmamak veya ba\u015fka bir \u015fey yapmakt\u0131r. Karma\u015f\u0131k ko\u015fullarda oldu\u011fu kadar basit de yazabilirsiniz.<\/p><p> Anla\u015f\u0131lmas\u0131 a\u00e7\u0131s\u0131ndan \u00fc\u00e7 farkl\u0131 b\u00f6l\u00fcme ay\u0131rd\u0131m.<\/p><ul><li> Test edilmesi sa\u011fland\u0131.<\/li><li> Ko\u015ful DO\u011eRU ise ger\u00e7ekle\u015ftirilecek g\u00f6rev.<\/li><li> Ko\u015ful YANLI\u015e ise ger\u00e7ekle\u015ftirilecek g\u00f6rev.<\/li><\/ul><p> Ger\u00e7ek hayatta b\u00f6yle g\u00f6r\u00fcn\u00fcyor: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/en-utilisant-le-code-dinstruction-VBA-IF-dans-Excel.png\" sizes=\"\" srcset=\"\" alt=\"Excel'de VBA IF deyimi kodunu kullanma\"><\/figure><\/div><p> Yukar\u0131daki \u00f6rnekte ya\u011fmur bir durumdur. E\u011fer bu ko\u015ful DO\u011eRU ise \u00e7ocuk \u015femsiyesini a\u00e7acak, e\u011fer ko\u015ful YANLI\u015e ise \u015fapkas\u0131n\u0131 takacakt\u0131r. Ko\u015fullar g\u00fcnl\u00fck ya\u015fam\u0131m\u0131z\u0131n her yerinde mevcuttur. Ama \u015fimdi kodlama d\u00fcnyam\u0131za geri d\u00f6nelim ve onu ke\u015ffedelim.<\/p><h2 id=\"tab-con-1\" class=\"wp-block-heading\"> S\u00f6zdizimi: VBA IF<\/h2><p> VBA&#8217;da \u00fc\u00e7 farkl\u0131 t\u00fcrde IF ifadesi vard\u0131r.<\/p><h3 id=\"tab-con-2\" class=\"wp-block-heading\"> 1. E\u011eER-O halde<\/h3><p> IF THEN, IF ifadesinin en basit \u015feklidir. Tek yapmam\u0131z gereken kontrol edilecek bir ko\u015ful belirtmek ve bu ko\u015ful DO\u011eRU ise bir g\u00f6revi ger\u00e7ekle\u015ftirecektir. Ancak bu ko\u015ful YANLI\u015e ise hi\u00e7bir \u015fey yapmaz ve an\u0131nda \u00e7izgiyi atlar.<\/p><h4 class=\"wp-block-heading\"> S\u00f6zdizimi<\/h4><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">IF condition Then statement[s]<\/code><\/pre><p> Yukar\u0131daki s\u00f6zdiziminde, de\u011ferlendirilecek bir ko\u015fulu ve bu ko\u015fulun DO\u011eRU olmas\u0131 durumunda ger\u00e7ekle\u015ftirilecek bir g\u00f6revi belirtmemiz gerekir.<\/p><h4 class=\"wp-block-heading\"> \u00d6rnek <\/h4><p class=\"has-text-align-center\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/vba-if-instruction-utilisant-if-then-macro-code-1.gif\" sizes=\"auto, \" srcset=\"\" alt=\"vba if ifadesi if ard\u0131ndan makro kodunu kullanarak\" width=\"228\" height=\"172\" data-attachment-id=\"7995\"><\/p><p> Yukar\u0131daki \u00f6rnekte A1 h\u00fccresinin 10 de\u011ferini i\u00e7erip i\u00e7ermedi\u011fini kontrol ettik ve e\u011fer i\u00e7eriyorsa ifadede \u201cH\u00fccre A1&#8217;in de\u011feri 10\u201d mesaj\u0131n\u0131 i\u00e7eren bir mesaj kutusu g\u00f6r\u00fcnt\u00fclenecektir.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub CheckValue() If Range(\"A1\").Value = 10 Then MsgBox (\"Cell A1 has value 10\") End Sub<\/code><\/pre><h3 id=\"tab-con-3\" class=\"wp-block-heading\"> 2. IF-sonra-else<\/h3><p> Bir ko\u015ful DO\u011eRU ise belirli bir g\u00f6revi, YANLI\u015e ise farkl\u0131 bir g\u00f6revi ger\u00e7ekle\u015ftirmek istedi\u011finizde IF-Then-Else ifadesini kullanabilirsiniz.<\/p><h4 class=\"wp-block-heading\"> S\u00f6zdizimi<\/h4><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">IF Condition Then Statement[s] Else Statement[s] End If<\/code><\/pre><p> Yukar\u0131daki s\u00f6z dizimi ile bir ko\u015fulun sonucuna ba\u011fl\u0131 olarak farkl\u0131 g\u00f6revleri ger\u00e7ekle\u015ftirebiliriz. E\u011fer ko\u015ful DO\u011eRU ise \u201cThe Then\u201d den sonra belirtti\u011finiz ifadeyi, e\u011fer ko\u015ful YANLI\u015e ise \u201cElse\u201d den sonra belirtti\u011finiz ifadeyi \u00e7al\u0131\u015ft\u0131racakt\u0131r.<\/p><h4 class=\"wp-block-heading\"> \u00d6rnek <\/h4><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub CheckValue() If Range(\"A1\").Value = \"10\" Then MsgBox (\"Cell A1 has value 10\") Else MsgBox (\"Cell A1 has a value other than 10\") End Sub<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/vba-if-instruction-utilisant-le-code-de-macro-if-then-else-1.gif\" sizes=\"\" srcset=\"\" alt=\"vba if ifadesi if Then else makro kodunu kullanarak\"><\/figure><\/div><p> Yukar\u0131daki \u00f6rnekte A1 h\u00fccresindeki de\u011feri kontrol etmek i\u00e7in IF-Then-Else ifadesini kulland\u0131m.<\/p><p> A1 h\u00fccresi 10 de\u011ferine sahipse, &#8220;A1 h\u00fccresinin de\u011feri 10&#8217;dur&#8221; mesaj kutusu, A1 h\u00fccresinde ba\u015fka bir de\u011fer varsa &#8220;A1 h\u00fccresinin de\u011feri 10&#8217;dan farkl\u0131&#8221; mesaj kutusu g\u00f6r\u00fcnt\u00fclenir. 10\u201d. Yani burada durum sonucuna g\u00f6re farkl\u0131 g\u00f6revleri ger\u00e7ekle\u015ftirebiliyoruz.<\/p><h3 id=\"tab-con-4\" class=\"wp-block-heading\"> 3. IF-Sonra-Elseif-Else<\/h3><p> Bu, geli\u015fmi\u015f durum ifadeleri yazman\u0131za yard\u0131mc\u0131 olacak en kullan\u0131\u015fl\u0131 ve \u00f6nemli IF t\u00fcr\u00fcd\u00fcr. Bu tipte ilk ko\u015fulu de\u011ferlendirdikten sonra ikinci ko\u015fulu belirleyebilirsiniz.<\/p><h4 class=\"wp-block-heading\"> S\u00f6zdizimi<\/h4><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">IF Condition Then Statement[s] Elseif Condition Then Statement[s] Else Statement[s] End If<\/code><\/pre><p> Yukar\u0131daki s\u00f6zdiziminde elimizde:<\/p><ol><li> De\u011ferlendirmek \u015fart\u0131yla.<\/li><li> Bu ko\u015fulun TURE olmas\u0131 durumunda y\u00fcr\u00fct\u00fclecek talimat.<\/li><li> Bu ko\u015ful YANLI\u015e ise de\u011ferlendirmemiz gereken ikinci ko\u015ful vard\u0131r.<\/li><li> Ve e\u011fer ikinci ko\u015ful DO\u011eRU ise, bir beyanda bulunmam\u0131z gerekiyor.<\/li><li> Ancak birinci ve ikinci ko\u015fullar\u0131n her ikisi de YANLI\u015e ise \u201cElse\u201dden sonra bahsetti\u011finiz ifadeyi verecektir.<\/li><\/ol><p> Ve en iyi yan\u0131, kodunuzda istedi\u011finiz say\u0131da \u201cElseif\u201d kullanabilmenizdir. Bu, beyan\u0131n\u0131zda istedi\u011finiz say\u0131da ko\u015fulu belirtebilece\u011finiz anlam\u0131na gelir.<\/p><h4 class=\"wp-block-heading\"> \u00d6rnek <\/h4><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/vba-if-instruction-utilisant-if-then-elseif-elseif-macro-code-1.gif\" sizes=\"\" srcset=\"\" alt=\"vba if ifadesi if ard\u0131ndan elseif elseif makro kodunu kullanarak\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub check_grade() If Range(\"A2\").Value = \"A\" Then MsgBox \"Very Good\" Else If Range(\"A2\").Value = \"B\" Then MsgBox \"Good\" ElseIf Range(\"A2\").Value = \"C\" Then MsgBox \"Average\" ElseIf Range(\"A2\").Value = \"D\" Then MsgBox \"Poor\" ElseIf Range(\"A2\").Value = \"E\" Then MsgBox \"Very Poor\" Else MsgBox \"Enter Correct Grade\" End Sub<\/code><\/pre><p> Yukar\u0131daki \u00f6rnekte \u00f6ncelikle A2 h\u00fccresinde &#8220;A&#8221; de\u011feri olup olmad\u0131\u011f\u0131n\u0131 kontrol edecek ve e\u011fer h\u00fccre &#8220;A&#8221; derecesine sahipse ifade &#8220;\u00c7ok \u0130yi&#8221; mesaj\u0131n\u0131 d\u00f6nd\u00fcrecek bir makro yazd\u0131k.<\/p><p> Bu komut ilk \u00f6nce A2 h\u00fccresini \u201cA\u201d de\u011feri a\u00e7\u0131s\u0131ndan kontrol edecek ve h\u00fccrenin derecelendirmesi \u201cA\u201d ise talimat \u201c\u00c7ok \u0130yi\u201d mesaj\u0131n\u0131 d\u00f6nd\u00fcrecektir.<\/p><p> Ve e\u011fer ilk ko\u015ful YANLI\u015e ise, ikinci ko\u015fulu de\u011ferlendirecek ve h\u00fccrenin derecesi &#8220;B&#8221; ise &#8220;\u0130yi&#8221; mesaj\u0131n\u0131 d\u00f6nd\u00fcrecektir.<\/p><p> Ve e\u011fer ikinci ko\u015ful yanl\u0131\u015fsa \u00fc\u00e7\u00fcnc\u00fc ko\u015fula ge\u00e7ilecektir ve bu \u015fekilde devam edecektir. Sonu\u00e7ta be\u015f ko\u015fulun t\u00fcm\u00fc yanl\u0131\u015fsa geri kalanlardan sonra yazd\u0131\u011f\u0131m kodu \u00e7al\u0131\u015ft\u0131racakt\u0131r.<\/p><h2 id=\"tab-con-5\" class=\"wp-block-heading\"> VBA&#8217;da IF \u0130fadesi Yazman\u0131n S\u0131rr\u0131<\/h2><p> Art\u0131k t\u00fcm IS t\u00fcrlerini biliyorsunuz ve ger\u00e7ekle\u015ftirmeniz gereken g\u00f6reve ba\u011fl\u0131 olarak birini de se\u00e7ebilirsiniz. Sana bir s\u0131r vereyim.<\/p><h3 id=\"tab-con-6\" class=\"wp-block-heading\"> Tek Sat\u0131rl\u0131 IF \u0130fadesi ve Blok IF \u0130fadesi<\/h3><p> Bir IF ifadesini iki farkl\u0131 \u015fekilde yazabilirsiniz ve her ikisinin de avantajlar\u0131 ve dezavantajlar\u0131 vard\u0131r. Bakmak.<\/p><h4 class=\"wp-block-heading\"> 1. Tek sat\u0131rl\u0131k a\u00e7\u0131klama<\/h4><p> IF-Then ifadesini kullan\u0131rsan\u0131z, tek sat\u0131rl\u0131k ifade m\u00fckemmeldir. Line ifadesini kullanman\u0131n temeli, t\u00fcm kodunuzu tek bir sat\u0131ra yazmakt\u0131r.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">If A1 = 10 Then Msgbox(\"Cell A1 has value 10\")<\/code><\/pre><p> Yukar\u0131daki a\u00e7\u0131klamada A1 h\u00fccresinin 10 de\u011ferine sahip olup olmad\u0131\u011f\u0131n\u0131 de\u011ferlendirmek i\u00e7in bir IF ifadesi yazd\u0131k, ard\u0131ndan bir mesaj kutusu g\u00f6r\u00fcnt\u00fcleyecektir. Tek sat\u0131rl\u0131k bir ifade kullanman\u0131n en iyi yolu, basit kod yazman\u0131z gerekti\u011fi zamand\u0131r. Karma\u015f\u0131k ve uzun bildirimler i\u00e7in tek sat\u0131rl\u0131k kod kullanman\u0131n anla\u015f\u0131lmas\u0131 zordur.<\/p><p class=\"qt-tip\"> <strong>K\u0131sa ipucu:<\/strong> Tek sat\u0131rl\u0131k kod yazarken, ifadeyi tamamlamak i\u00e7in Endif&#8217;i kullanman\u0131za gerek yoktur.<\/p><h4 class=\"wp-block-heading\"> 2. Blok bildirimi<\/h4><p> Kodunuzu d\u00fczg\u00fcn ve anla\u015f\u0131l\u0131r bir \u015fekilde yazmak istedi\u011finizde Block ifadesi m\u00fckemmeldir. Bir blok ifadesi yazd\u0131\u011f\u0131n\u0131zda, makronuzda birden fazla sat\u0131r kullanabilirsiniz, bu da size d\u00fczenli ve temiz kod sa\u011flar.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub check_value() If Range(\u201cA1\u201d).Value = \u201c10\u201d Then MsgBox (\"Cell A1 has value 10\") Else MsgBox (\"Cell A1 has a value other than 10\") End If End Sub<\/code><\/pre><p> Yukar\u0131daki \u00f6rnekte IF-Then-Else ifadesini bloklar halinde yazd\u0131k. Ve okuman\u0131n kolay oldu\u011funu ve hatta hata ay\u0131klaman\u0131n kolay oldu\u011funu g\u00f6rebilirsiniz.<\/p><p> Karma\u015f\u0131k talimatlar yazarken (ki bu k\u0131lavuzu okuduktan sonra kesinlikle yazacaks\u0131n\u0131z), blok talimatlar\u0131 her zaman iyidir. Ayr\u0131ca, i\u00e7 i\u00e7e If ifadeleri yazarken, netlik sa\u011flamak i\u00e7in sat\u0131r\u0131n\u0131za girinti de ekleyebilirsiniz.<\/p><p class=\"qt-tip\"> <strong>H\u0131zl\u0131 \u0130pucu<\/strong> \u2013 IF-Then-Elseif-Else kulland\u0131\u011f\u0131n\u0131zda kodunuzun sonunda Else komutunu kullanarak g\u00f6z ard\u0131 edebilece\u011finiz bir istisnan\u0131z vard\u0131r. \u0130fadenizde ko\u015fullar\u0131n hi\u00e7biri DO\u011eRU olmad\u0131\u011f\u0131nda herhangi bir g\u00f6revi ger\u00e7ekle\u015ftirmeniz gerekmedi\u011finde bu \u00e7ok kullan\u0131\u015fl\u0131d\u0131r.<\/p><h2 id=\"tab-con-7\" class=\"wp-block-heading\"> 8 somut \u00f6rnek<\/h2><p> Burada takip edebilece\u011finiz baz\u0131 basit ama kullan\u0131\u015fl\u0131 \u00f6rnekleri listeledim.<\/p><h3 id=\"tab-con-8\" class=\"wp-block-heading\"> 1. \u0130\u00e7 i\u00e7e E\u011eER<\/h3><p> IF ifadesinin en iyi k\u0131sm\u0131 i\u00e7 i\u00e7e ge\u00e7mi\u015f ifadeler olu\u015fturman\u0131zd\u0131r. \u0130lk ko\u015fula ikinci bir ko\u015ful ekleyebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ecriture-imbrication-si-avec-vba-if-instruction-1.gif\" sizes=\"\" srcset=\"\" alt=\"vba if ifadesiyle i\u00e7 i\u00e7e if yazma\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub NestIF() Dim res As Long res = MsgBox(\"Do you want to save this file?\", vbYesNo, \"Save File\") If res = vbYes Then 'start of first IF statement If ActiveWorkbook.Saved &lt;&gt; True Then 'start of second IF statement. ActiveWorkbook.SaveMsgBox (\"Workbook Saved\") Else MsgBox \"This workbook is already saved\" End If 'end of second IF statement Else MsgBox \"Make Sure to save it later\" End If ' end of first IF statement End Sub<\/code><\/pre><p> Yukar\u0131daki \u00f6rnekte i\u00e7 i\u00e7e IF ifadesini kulland\u0131k. <a href=\"https:\/\/exceladvisor.org\/tr\/makro-2yi-calistir\/\">Bu makroyu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda<\/a> kar\u015f\u0131n\u0131za Tamam ve \u0130ptal se\u00e7eneklerinin bulundu\u011fu <a href=\"https:\/\/exceladvisor.org\/tr\/vba-mesaj-kutusu\/\">bir mesaj kutusu gelecektir<\/a> . Ko\u015fullu ifadenin \u00e7al\u0131\u015fmas\u0131 bundan sonra ba\u015flar.<\/p><p> \u00d6ncelikle t\u0131klad\u0131\u011f\u0131n\u0131z butonu de\u011ferlendirecektir. &#8220;Evet&#8221;i t\u0131klad\u0131ysan\u0131z e-tablonuzun kaydedilip kaydedilmedi\u011fini de\u011ferlendirmek i\u00e7in bunu i\u00e7 i\u00e7e ge\u00e7irin.<\/p><p> \u00c7al\u0131\u015fma kitab\u0131n\u0131z kaydedilmemi\u015fse kaydedecek ve size bir mesaj g\u00f6nderilecektir. Ayr\u0131ca \u00e7al\u0131\u015fma kitab\u0131 zaten kay\u0131tl\u0131ysa bununla ilgili bir mesaj g\u00f6r\u00fcnt\u00fcler.<\/p><p> Ancak butona t\u0131klarsan\u0131z ilk makronun ko\u015fulu YANLI\u015e olacak ve yaln\u0131zca kitab\u0131n\u0131z\u0131 daha sonra kaydetmeniz i\u00e7in bir mesaj alacaks\u0131n\u0131z.<\/p><p> Bu koddaki temel fikir, ikinci ko\u015fulun tamamen birinci ko\u015fula ba\u011fl\u0131 olmas\u0131d\u0131r, e\u011fer ilk ko\u015ful YANLI\u015e ise ikinci ko\u015ful de\u011ferlendirilmeyecektir.<\/p><p> <strong><a href=\"https:\/\/exceladvisor.org\/tr\/yuva-eger\/\">Yuvalanm\u0131\u015f IF<\/a><\/strong> hakk\u0131nda daha fazla bilgi edinin<\/p><h3 id=\"tab-con-9\" class=\"wp-block-heading\"> 2. IF ve GoTo ile bir d\u00f6ng\u00fc olu\u015fturun<\/h3><p> Ayr\u0131ca IF ile goto&#8217;yu kullanarak bir d\u00f6ng\u00fc olu\u015fturabilirsiniz. \u00c7o\u011fu programc\u0131 d\u00f6ng\u00fcleri bu \u015fekilde yazmaktan ka\u00e7\u0131n\u0131r \u00e7\u00fcnk\u00fc <a href=\"https:\/\/exceladvisor.org\/tr\/donguler\/\">d\u00f6ng\u00fc olu\u015fturman\u0131n daha iyi yollar\u0131<\/a> vard\u0131r. Ancak bunu nas\u0131l yapabilece\u011fimizi \u00f6\u011frenmenin hi\u00e7bir zarar\u0131 yok.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub auto_open() Alert: If InputBox(\"Enter Username\") &lt;&gt; \"Puneet\" Then GoTo Alert Else MsgBox \"Welcome\" End If End Sub<\/code><\/pre><p> Yukar\u0131daki \u00f6rnekte d\u00f6ng\u00fc olu\u015fturmak i\u00e7in bir ko\u015ful ifadesi kulland\u0131k. Makro ad\u0131 olarak auto_open&#8217;\u0131 kulland\u0131k, b\u00f6ylece birisi dosyay\u0131 her a\u00e7t\u0131\u011f\u0131nda bu makroyu \u00e7al\u0131\u015ft\u0131racakt\u0131r.<\/p><p> Kullan\u0131c\u0131n\u0131n bir kullan\u0131c\u0131 ad\u0131 girmesi gerekir ve e\u011fer bu kullan\u0131c\u0131 ad\u0131 \u201cPuneet\u201de e\u015fit de\u011filse kodu tekrarlayacak ve giri\u015f kutusunu yeniden g\u00f6sterecektir. Ve do\u011fru metni girerseniz dosyaya eri\u015febilecektir.<\/p><h3 id=\"tab-con-10\" class=\"wp-block-heading\"> 3. Bir h\u00fccrenin say\u0131 i\u00e7erip i\u00e7ermedi\u011fini kontrol edin<\/h3><p> Burada <a href=\"https:\/\/exceladvisor.org\/tr\/aktif-hucre\/\">aktif h\u00fccrenin<\/a> say\u0131sal bir de\u011fer i\u00e7erip i\u00e7ermedi\u011fini kontrol etmek i\u00e7in bir ko\u015ful kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utiliser-linstruction-vba-if-pour-verifier-le-nombre-dans-la-cellule-1.gif\" sizes=\"\" srcset=\"\" alt=\"h\u00fccredeki say\u0131y\u0131 kontrol etmek i\u00e7in vba if ifadesini kullan\u0131n\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub check_number() If IsNumeric(Range(\"B2\").Value) Then MsgBox \"Yes, active cell has a number.\" Else MsgBox \"No, active cell hasn't a number.\" End If End Sub<\/code><\/pre><p> Yukar\u0131daki \u00f6rnekte VBA&#8217;da bir h\u00fccrenin de\u011ferinin say\u0131 olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in \u00e7al\u0131\u015fma sayfas\u0131ndaki say\u0131 i\u015fleviyle ayn\u0131 olan <a href=\"https:\/\/exceladvisor.org\/tr\/sayisal\/\">isnumeric i\u015flevini<\/a> kullanarak bir ko\u015ful yazd\u0131m.<\/p><p> De\u011fer bir say\u0131 ise TRUE de\u011ferini d\u00f6nd\u00fcrecek ve &#8220;Evet, aktif h\u00fccrenin say\u0131sal de\u011feri var&#8221; mesaj\u0131 alacaks\u0131n\u0131z. De\u011fer bir say\u0131 de\u011filse, &#8220;Aktif h\u00fccrede say\u0131sal de\u011fer yok&#8221; mesaj\u0131 al\u0131rs\u0131n\u0131z.<\/p><h3 id=\"tab-con-11\" class=\"wp-block-heading\"> 4. VEYA ve VE&#8217;yi IF ile birlikte kullan\u0131n<\/h3><p> <strong><a href=\"https:\/\/exceladvisor.org\/tr\/eger-veya\/\">IF OR&#8217;u<\/a><\/strong> kullanarak iki veya daha fazla ko\u015fulu belirtebilir ve ko\u015fullar aras\u0131nda en az bir ko\u015fulun DO\u011eRU olmas\u0131 durumunda bir g\u00f6revi ger\u00e7ekle\u015ftirebilirsiniz.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub UsingOR() If Range(\"A1\") &lt; 70 Or Range(\"B1\") &lt; 70 Then MsgBox \"You Are Pass\" Else If Range(\"A1\") &lt; 40 And Range(\"B1\") &lt; 40 Then MsgBox \"You Are Pass\" Else MsgBox \"You Are Fail\" End If End If End Sub<\/code><\/pre><p> Yukar\u0131daki \u00f6rnekte 2. sat\u0131rda VEYA kullanan iki ko\u015fulumuz var. \u00d6\u011frencinin herhangi bir dersten 70 puan almas\u0131 halinde sonu\u00e7 \u201cGe\u00e7ti\u201d olacakt\u0131r. Ve 7. sat\u0131rda AND operat\u00f6r\u00fcn\u00fc kullanan iki ko\u015fulumuz var. \u00d6\u011frencinin her iki dersten de 40&#8217;\u0131n \u00fczerinde puan almas\u0131 halinde sonu\u00e7 &#8220;Ge\u00e7ti&#8221; olacakt\u0131r.<\/p><p> <strong><a href=\"https:\/\/exceladvisor.org\/tr\/eger-ve\/\">IF AND<\/a><\/strong> se\u00e7ene\u011fini kullanarak birden fazla ko\u015fulu belirtebilir ve t\u00fcm ko\u015fullar DO\u011eRU ise bir g\u00f6revi ger\u00e7ekle\u015ftirebilirsiniz.<\/p><h3 id=\"tab-con-12\" class=\"wp-block-heading\"> 5. IF ile De\u011fil&#8217;i kullan\u0131n<\/h3><p> Bir ko\u015fulda NOT&#8217;u kullanarak, DO\u011eRU&#8217;yu YANLI\u015e&#8217;a ve YANLI\u015e&#8217;\u0131 DO\u011eRU&#8217;ya de\u011fi\u015ftirebilirsiniz.<\/p><p> <a href=\"https:\/\/exceladvisor.org\/tr\/aksi-takdirde\/\"><strong>HAYIR \u0130SE VBA<\/strong><\/a><\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub IF_Not() If Range(\u201cD1\u201d) &lt;= 40 And Not Range(\u201cE1\u201d) = \u201cE\u201d Then MsgBox \"You Are Pass.\" Else MsgBox \"You Are Fail.\" End If End Sub<\/code><\/pre><p> Yukar\u0131daki \u00f6rnekte, ko\u015fulda NOT&#8217;u kulland\u0131k. Dene\u011fin puan\u0131n\u0131n bulundu\u011fu iki h\u00fccremiz var. Bir h\u00fccrede puan say\u0131larla, di\u011fer h\u00fccrede ise notlarla g\u00f6sterilir.<\/p><ul><li> Bir \u00f6\u011frencinin birinci dersten 40&#8217;\u0131n \u00fczerinde, ikinci dersten E notunun \u00fczerinde olmas\u0131 durumunda PASS&#8217;t\u0131r.<\/li><li> Bir \u00f6\u011frencinin notu birinci derste 40&#8217;\u0131n \u00fczerinde, ikinci derste E notunun \u00fczerinde ise PASS&#8217;t\u0131r.<\/li><\/ul><p> Yani bir \u00f6\u011frencinin notu 40&#8217;\u0131n \u00fczerinde ve E d\u0131\u015f\u0131nda bir not ald\u0131\u011f\u0131nda &#8220;Ge\u00e7tiniz&#8221; veya &#8220;Kald\u0131n\u0131z&#8221; mesaj\u0131 alaca\u011f\u0131z.<\/p><h3 id=\"tab-con-13\" class=\"wp-block-heading\"> 6. Onay kutulu IF beyan\u0131<\/h3><p> \u015eimdi burada bir makroyu \u00e7al\u0131\u015ft\u0131rmak i\u00e7in bir onay kutusu kullan\u0131yoruz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/en-utilisant-linstruction-vba-if-avec-case-a-cocher-1.gif\" sizes=\"auto, \" srcset=\"\" alt=\"vba if ifadesini onay kutusuyla kullanma\" width=\"683\" height=\"153\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub ship_as_bill() If Range(\"D15\") = True Then Range(\"D17:D21\") = Range(\"C17:C21\") Else If Range(\u201cD15\u201d) = False Then Range(\"D17:D21\").ClearContents Else MsgBox (\u201cError!\u201d) End If End If End Sub<\/code><\/pre><p> Yukar\u0131daki \u00f6rnekte, onay kutusu i\u015faretlendi\u011finde D17:D21 aral\u0131\u011f\u0131n\u0131n C17:C21 aral\u0131\u011f\u0131na e\u015fit olmas\u0131n\u0131 sa\u011flayacak bir ko\u015ful olu\u015fturmak i\u00e7in bir IF ifadesi kulland\u0131k. Ve e\u011fer <a href=\"https:\/\/exceladvisor.org\/tr\/onay-kutusu\/\">kutu<\/a> i\u015faretlenmezse D17:D21 aral\u0131\u011f\u0131 bo\u015f olacakt\u0131r.<\/p><p> Bu tekni\u011fi kullanarak fatura adresini teslimat adresi olarak kullanabiliriz ve ba\u015fka bir \u015feye ihtiyac\u0131m\u0131z olursa adresi manuel olarak girebiliriz.<\/p><h3 id=\"tab-con-14\" class=\"wp-block-heading\"> 7. Bir h\u00fccrenin birle\u015ftirilip birle\u015ftirilmedi\u011fini kontrol edin<\/h3><p> Burada da aktif bir h\u00fccrenin birle\u015ftirilmesi durumunda uyar\u0131 alma ko\u015fulunu yaz\u0131yoruz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/verifier-si-une-cellule-est-fusionnee-a-laide-de-linstruction-vba-if-1.gif\" sizes=\"\" srcset=\"\" alt=\"vba if ifadesi kullan\u0131larak bir h\u00fccrenin birle\u015ftirilip birle\u015ftirilmedi\u011fini kontrol edin\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub MergeCellCheck() If ActiveCell.MergeCells Then MsgBox \"Active Cell Is Merged\" Else MsgBox \"Active Cell Is Not Merged\" End If End Sub<\/code><\/pre><p> Yukar\u0131daki kodda aktif h\u00fccrenin birle\u015fip birle\u015ftirilmedi\u011fini kontrol etmek i\u00e7in <a href=\"https:\/\/exceladvisor.org\/tr\/birlestirmek\/\">birle\u015ftirilmi\u015f h\u00fccreleri<\/a> kulland\u0131k. <a href=\"https:\/\/exceladvisor.org\/tr\/aktif-hucre-1\/\">Etkin h\u00fccre<\/a> birle\u015ftirilirse ko\u015ful <a href=\"https:\/\/exceladvisor.org\/tr\/vba-mesaj-kutusu\/\">bunun i\u00e7in bir uyar\u0131<\/a> d\u00f6nd\u00fcr\u00fcr.<\/p><h3 id=\"tab-con-15\" class=\"wp-block-heading\"> 8. H\u00fccre bo\u015fsa sat\u0131r\u0131n tamam\u0131n\u0131 silin<\/h3><p> Burada bir sat\u0131r\u0131n bo\u015f olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in IF kullan\u0131yoruz. Ve e\u011fer bu sat\u0131r bo\u015fsa, ifade o sat\u0131r\u0131 siler.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub DeleteRow() If Application.CountA(ActiveCell.EntireRow) = 0 Then ActiveCell.EntireRow.Delete Else MsgBox Application.CountA(ActiveCell.EntireRow) &amp; \"Cell(s) have values in this row\" End If End Sub<\/code><\/pre><p> Yukar\u0131daki \u00f6rnekte \u00f6ncelikle de\u011feri olan h\u00fccreleri kontrol edecektir. De\u011fer i\u00e7eren h\u00fccre say\u0131s\u0131 s\u0131f\u0131rsa ko\u015ful etkin sat\u0131r\u0131 siler, aksi takdirde de\u011fer i\u00e7eren h\u00fccre say\u0131s\u0131n\u0131 belirten uyar\u0131y\u0131 d\u00f6nd\u00fcr\u00fcr.<\/p><h2 class=\"wp-block-heading\"> \u00c7\u00f6z\u00fcm<\/h2><p> Dedi\u011fim gibi bu VBA&#8217;n\u0131n en \u00f6nemli k\u0131s\u0131mlar\u0131ndan biri ve VBA&#8217;da uzmanla\u015fmak istiyorsan\u0131z mutlaka \u00f6\u011frenmelisiniz. IF deyimi ile basit kodlar\u0131n yan\u0131 s\u0131ra karma\u015f\u0131k kodlar da yazabilirsiniz. Ayr\u0131ca mant\u0131ksal operat\u00f6rleri kullanabilir ve i\u00e7 i\u00e7e ge\u00e7mi\u015f ko\u015fullar yazabilirsiniz.<\/p><p> Umar\u0131m bu k\u0131lavuz daha iyi kodlar yazman\u0131za yard\u0131mc\u0131 olur.<\/p><p> \u015eimdi bana \u015funu s\u00f6yle. S\u0131k s\u0131k VBA&#8217;da ko\u015fullar yaz\u0131yor musunuz? Ne t\u00fcr kodlar yaz\u0131yorsunuz? L\u00fctfen g\u00f6r\u00fc\u015flerinizi yorum k\u0131sm\u0131nda benimle payla\u015f\u0131n. Ve bu k\u0131lavuzu arkada\u015flar\u0131n\u0131zla payla\u015fmay\u0131 unutmay\u0131n.<\/p><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/tr\/vba\/\">VBA nedir<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> \u0130lgili e\u011fitimler <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/eger-disari-cik\/\">VBA \u00c7\u0131k\u0131\u015f\u0131 IF<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/eger-ve\/\">VBA IF ve<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/aksi-takdirde\/\">HAYIR \u0130SE VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/eger-veya\/\">VBA IF VEYA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/yuva-eger\/\">VBA i\u00e7 i\u00e7e IF<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/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-2152","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>\u25b7 VBA&#039;da IF ifadesi ELSE ile nas\u0131l kullan\u0131l\u0131r?<\/title>\n<meta name=\"description\" content=\"Ko\u015fullar her yerde. VBA kodlamas\u0131 s\u00f6z konusu oldu\u011funda ko\u015fullar en \u00f6nemli \u015feylerden biridir. E\u011fer istersen\" \/>\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\/eger-2\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 VBA&#039;da IF ifadesi ELSE ile nas\u0131l kullan\u0131l\u0131r?\" \/>\n<meta property=\"og:description\" content=\"Ko\u015fullar her yerde. VBA kodlamas\u0131 s\u00f6z konusu oldu\u011funda ko\u015fullar en \u00f6nemli \u015feylerden biridir. E\u011fer istersen\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/eger-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:07:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/en-utilisant-le-code-dinstruction-VBA-IF-dans-Excel.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=\"13 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/eger-2\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/eger-2\/\",\"name\":\"\u25b7 VBA&#39;da IF ifadesi ELSE ile nas\u0131l kullan\u0131l\u0131r?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/eger-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/eger-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/en-utilisant-le-code-dinstruction-VBA-IF-dans-Excel.png\",\"datePublished\":\"2023-09-28T18:49:51+00:00\",\"dateModified\":\"2023-12-10T06:07:44+00:00\",\"description\":\"Ko\u015fullar her yerde. VBA kodlamas\u0131 s\u00f6z konusu oldu\u011funda ko\u015fullar en \u00f6nemli \u015feylerden biridir. E\u011fer istersen\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/eger-2\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/eger-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/eger-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/en-utilisant-le-code-dinstruction-VBA-IF-dans-Excel.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/en-utilisant-le-code-dinstruction-VBA-IF-dans-Excel.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/eger-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba&#39;da if ifadesi else ile 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":"\u25b7 VBA&#39;da IF ifadesi ELSE ile nas\u0131l kullan\u0131l\u0131r?","description":"Ko\u015fullar her yerde. VBA kodlamas\u0131 s\u00f6z konusu oldu\u011funda ko\u015fullar en \u00f6nemli \u015feylerden biridir. E\u011fer istersen","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\/eger-2\/","og_locale":"tr_TR","og_type":"article","og_title":"\u25b7 VBA&#39;da IF ifadesi ELSE ile nas\u0131l kullan\u0131l\u0131r?","og_description":"Ko\u015fullar her yerde. VBA kodlamas\u0131 s\u00f6z konusu oldu\u011funda ko\u015fullar en \u00f6nemli \u015feylerden biridir. E\u011fer istersen","og_url":"https:\/\/exceladvisor.org\/tr\/eger-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:07:44+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/en-utilisant-le-code-dinstruction-VBA-IF-dans-Excel.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"13 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/eger-2\/","url":"https:\/\/exceladvisor.org\/tr\/eger-2\/","name":"\u25b7 VBA&#39;da IF ifadesi ELSE ile nas\u0131l kullan\u0131l\u0131r?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/eger-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/eger-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/en-utilisant-le-code-dinstruction-VBA-IF-dans-Excel.png","datePublished":"2023-09-28T18:49:51+00:00","dateModified":"2023-12-10T06:07:44+00:00","description":"Ko\u015fullar her yerde. VBA kodlamas\u0131 s\u00f6z konusu oldu\u011funda ko\u015fullar en \u00f6nemli \u015feylerden biridir. E\u011fer istersen","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/eger-2\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/eger-2\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/eger-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/en-utilisant-le-code-dinstruction-VBA-IF-dans-Excel.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/en-utilisant-le-code-dinstruction-VBA-IF-dans-Excel.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/eger-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Vba&#39;da if ifadesi else ile 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\/2152","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=2152"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2152\/revisions"}],"predecessor-version":[{"id":2948,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2152\/revisions\/2948"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=2152"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}