{"id":289182,"date":"2024-12-24T19:32:52","date_gmt":"2024-12-24T19:32:52","guid":{"rendered":"https:\/\/gfssite.local\/monday-comda-if-islevi-nasil-kullanilir-kosullu-bir-kilavuz\/"},"modified":"2024-12-24T20:07:23","modified_gmt":"2024-12-24T20:07:23","slug":"monday-comda-if-islevi-nasil-kullanilir-kosullu-bir-kilavuz","status":"publish","type":"post","link":"https:\/\/globalfinanceschool.com\/tr\/monday-comda-if-islevi-nasil-kullanilir-kosullu-bir-kilavuz\/","title":{"rendered":"Monday.com’da IF i\u015flevi nas\u0131l kullan\u0131l\u0131r: ko\u015fullu bir k\u0131lavuz"},"content":{"rendered":"
\n

Bir Form\u00fcl S\u00fctunu\u2019nu ilk kez kullanmaya ba\u015flamakla ilgileniyorsan\u0131z veya bir Form\u00fcl S\u00fctunu konusunda uzman olma yolunda ilerliyorsan\u0131z, IF i\u015flevi muhtemelen gidilecek yer olacakt\u0131r. IF i\u015flevinin neredeyse sonsuz kullan\u0131\u015fl\u0131 yetenekleri nedeniyle, bunun bir form\u00fcl s\u00fctununda en yayg\u0131n kullan\u0131lan i\u015flev olmas\u0131 \u015fa\u015f\u0131rt\u0131c\u0131 de\u011fildir! <\/span><\/p>\n

\"image_14__2_.png\"<\/p>\n

Bu makalede \u00f6ncelikle IF fonksiyonunun temellerini \u00f6\u011frenece\u011fiz ve ard\u0131ndan ona eklenebilecek ek varyasyonlar\u0131 ve ko\u015fullar\u0131 inceleyece\u011fiz. IF i\u015flevinin neyle ilgili oldu\u011funu, nas\u0131l \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 ve kullan\u0131m \u00f6rneklerini \u00f6\u011frenmek i\u00e7in okumaya devam edin. <\/span><\/span><\/p>\n\n

IF fonksiyonunu anlama<\/span><\/strong><\/span><\/h1>\n

Form\u00fcl d\u00fcnyas\u0131nda yeniyseniz \u201cIF i\u015flevi nedir?\u201d sorusunu \u00e7\u00f6zmeye \u00e7al\u0131\u015f\u0131yor olabilirsiniz. Temel olarak IF i\u015flevi, ko\u015fullu bir ifade olu\u015fturmak i\u00e7in kullan\u0131lan bir form\u00fcl t\u00fcr\u00fcd\u00fcr ve belirtilen ko\u015fulun kar\u015f\u0131lan\u0131p kar\u015f\u0131lanmad\u0131\u011f\u0131na ba\u011fl\u0131 olarak bir de\u011fer d\u00f6nd\u00fcr\u00fcr veya g\u00f6r\u00fcnt\u00fcler.<\/span><\/p>\n

En basit haliyle bir E\u011eER i\u015flevi form\u00fcl\u00fc \u015fu \u015fekilde olu\u015fturulur:<\/span><\/p>\n

    \n
  1. \u0130lk olarak, ko\u015ful (\u00f6rne\u011fin:IF(<\/strong>{Status}=\"Done\"<\/code> )<\/span><\/li>\n
  2. Daha sonra, ko\u015ful kar\u015f\u0131lan\u0131rsa<\/strong> d\u00f6nd\u00fcr\u00fclen de\u011fer (\u00f6rn.:\"YAY!\"<\/code> ). <\/span><\/li>\n
  3. Son olarak, ko\u015ful kar\u015f\u0131lanmad\u0131\u011f\u0131nda<\/strong> d\u00f6nd\u00fcr\u00fclen de\u011fer (\u00f6rn.:\"\u05dc\u05d0 \u05e2\u05d3\u05d9\u05d9\u05df...\")<\/strong><\/code> )<\/span><\/li>\n<\/ol>\n

    Bunlar tek bir form\u00fclde birle\u015ftirildi\u011finde \u015f\u00f6yle g\u00f6r\u00fcnecektir:<\/span><\/p>\n

    \n
    \"\"<\/span><\/div>\n
    form\u00fcl: <\/strong> IF(<\/strong>{Status}=\"Done\",\"YAY!\",\"Not yet...\")<\/strong><\/code> <\/span><\/div>\n<\/div>\n

    Hadi par\u00e7alayal\u0131m!<\/strong> <\/span><\/p>\n

    Yukar\u0131da g\u00f6sterilen \u00f6rnekte form\u00fcl, durum \u201cBitti\u201d olarak ayarlan\u0131rsa<\/strong> \u201cYAY!\u201d de\u011ferini d\u00f6nd\u00fcrece\u011fini s\u00f6yl\u00fcyor. \u00d6te yandan, durum \u201cBitti\u201d olarak tan\u0131mlanmam\u0131\u015fsa<\/strong> \u201cHen\u00fcz de\u011fil\u2026\u201d de\u011feri d\u00f6nd\u00fcr\u00fclecektir. Dolay\u0131s\u0131yla bu form\u00fcl\u00fcn sonucu, durumun \u201cBitti\u201d etiketini ta\u015f\u0131y\u0131p ta\u015f\u0131mad\u0131\u011f\u0131na ba\u011fl\u0131d\u0131r. <\/span><\/p>\n\n

    Tahtaya konuldu\u011funda b\u00f6yle g\u00f6r\u00fcnecek! \u2b07\ufe0f <\/span><\/p>\n

    \"image_1__31_.png\"<\/span><\/p>\n

    \n
    \"\"<\/span><\/div>\n
    Not:<\/strong> IF ifadesini ve form\u00fcldeki di\u011fer ifadeleri a\u00e7mak ve kapatmak i\u00e7in parantez kullanmak \u00f6nemlidir. Bu makale boyunca sunulan herhangi bir form\u00fcl \u00f6rne\u011finde bu durum renkli parantezler kullan\u0131larak belirtilecektir. <\/span><\/div>\n<\/div>\n

    IF i\u015flevini kullanman\u0131n basit bir \u00f6rne\u011fi<\/strong><\/span><\/h1>\n

    Art\u0131k IF fonksiyonunun ne<\/em> oldu\u011funu ve en temel haliyle nas\u0131l olu\u015fturuldu\u011funu<\/em> anlad\u0131\u011f\u0131m\u0131za g\u00f6re, IF fonksiyonunun ger\u00e7ek hayattaki bir \u00f6rnekte nas\u0131l kullan\u0131labilece\u011fini g\u00f6rmek i\u00e7in b\u00fct\u00e7e izleme \u00f6rnek olay\u0131na bakal\u0131m! <\/span><\/p>\n

    \"Grup_34.png\"<\/span><\/p>\n

    Yukar\u0131daki pano bir kurulu\u015fun b\u00fct\u00e7esini takip etmek i\u00e7in kullan\u0131l\u0131r. Form\u00fcl S\u00fctunu sayesinde harcanan ger\u00e7ek tutar\u0131n belirlenen b\u00fct\u00e7eyle nas\u0131l kar\u015f\u0131la\u015ft\u0131r\u0131ld\u0131\u011f\u0131n\u0131 bir bak\u0131\u015fta g\u00f6rebiliriz. Burada a\u015fa\u011f\u0131daki form\u00fcl kullan\u0131l\u0131r: <\/span><\/p>\n

    \n
    \"\"<\/span><\/div>\n
    form\u00fcl: <\/strong> IF({Budgeted}<{Actual Spending},\"Over Budget\",\"Under Budget\")<\/code> <\/span><\/div>\n<\/div>\n

    Bu i\u015flev uyguland\u0131\u011f\u0131nda form\u00fcl s\u00fctununda \u201cB\u00fct\u00e7e\u201d de\u011feri \u201cGer\u00e7ek Giderler\u201d de\u011ferinden<\/strong> k\u00fc\u00e7\u00fckse<\/strong> okunacakt\u0131r. \u201cB\u00fct\u00e7e\u201d de\u011feri ger\u00e7ekten \u201cGer\u00e7ek Giderler\u201d de\u011ferinden k\u00fc\u00e7\u00fckse, \u201cB\u00fct\u00e7e A\u015f\u0131m\u0131\u201d metni g\u00f6r\u00fcnecektir. Aksi takdirde, bu ko\u015ful kar\u015f\u0131lanmazsa ve \u201cB\u00fct\u00e7e\u201d de\u011feri \u201cGer\u00e7ek Giderler\u201d den b\u00fcy\u00fckse<\/strong> , bunun yerine \u201cB\u00fct\u00e7enin Alt\u0131nda\u201d metni g\u00f6r\u00fcnt\u00fclenecektir. <\/span><\/p>\n\n

    IF i\u015fleviyle AND\/OR ko\u015fullar\u0131n\u0131 kullanma<\/span><\/strong><\/span><\/h1>\n

    IF i\u015flevini kullan\u0131rken ek ko\u015fullar\u0131n belirtilmesi gerekebilir. Ama\u00e7 daha uzun ve daha karma\u015f\u0131k hesaplamalar yapmak oldu\u011funda bu \u00f6zellikle \u00f6nemli olacakt\u0131r! Bu nedenle AND veya OR gibi ek mant\u0131ksal i\u015flevler IF i\u015fleviyle birle\u015ftirilebilir. <\/span><\/p>\n

    \"image_14__3_.png\"<\/p>\n

    Yukar\u0131da g\u00f6sterildi\u011fi gibi, bir IF form\u00fcl\u00fcne ek bir ko\u015ful veya i\u015flev eklendi\u011finde, ek ifade (\u00f6r.AND({Total Sales}>350000,{Deals}>12)<\/code> ) ilk IF ifadesinin i\u00e7ine eklenecektir. Nas\u0131l \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 g\u00f6rmek i\u00e7in a\u015fa\u011f\u0131da ba\u015fka bir AND ko\u015fulu \u00f6rne\u011fine ve ard\u0131ndan bir OR ko\u015fulu \u00f6rne\u011fine bakal\u0131m! <\/span><\/p>\n\n

    VE ko\u015fullar<\/strong><\/span><\/h1>\n

    VE i\u015flevi, bir de\u011feri g\u00f6r\u00fcnt\u00fclemek amac\u0131yla birden fazla ko\u015fulu test etmenize olanak sa\u011flamak i\u00e7in bir E\u011eER form\u00fcl\u00fc i\u00e7inde kullan\u0131labilir. Bunu kullan\u0131rken, bir de\u011ferin g\u00f6r\u00fcnt\u00fclenmesi i\u00e7in t\u00fcm<\/em> ayar ko\u015fullar\u0131n\u0131n kar\u015f\u0131lanmas\u0131 gerekir. Bu ko\u015fullardan yaln\u0131zca birinin kar\u015f\u0131lanmas\u0131 veya hi\u00e7birinin kar\u015f\u0131lanmamas\u0131 durumunda kar\u015f\u0131lanmayan ko\u015fullar i\u00e7in form\u00fclde tan\u0131mlanan de\u011fer g\u00f6r\u00fcnt\u00fclenecektir. <\/span><\/p>\n

    2.500$\u2019l\u0131k bir bonus al\u0131p almayaca\u011f\u0131n\u0131z\u0131 belirlemek i\u00e7in IF ve AND i\u015flevlerinin nas\u0131l birle\u015ftirilebilece\u011finin bir \u00f6rne\u011fini g\u00f6rmek i\u00e7in a\u015fa\u011f\u0131daki sat\u0131\u015f lideri y\u00f6netim kuruluna bir g\u00f6z atal\u0131m:<\/span><\/p>\n

    \"Group_34__1_.png\"<\/p>\n

    Bu panoya, bir sat\u0131\u015f temsilcisinin almaya hak kazanabilece\u011fi 2.500 ABD Dolar\u0131 tutar\u0131ndaki bonus tutar\u0131n\u0131 g\u00f6stermek i\u00e7in \u201cBonus De\u011feri\u201d adl\u0131 bir form\u00fcl s\u00fctunu ekledik. Bir sat\u0131\u015f temsilcisinin 2.500 ABD Dolar\u0131 tutar\u0131ndaki bonusa hak kazanabilmesi i\u00e7in, anla\u015fma boyutunun 350.000 ABD Dolar\u0131n\u0131n \u00fczerinde olmas\u0131 ve \u00f6deme \u00f6\u011fesinin<\/em><\/strong> \u201c\u00d6dendi\u201d olarak i\u015faretlenmesi gerekir. A\u015fa\u011f\u0131daki form\u00fcl tam da bunu yapmam\u0131za izin verebilir: <\/span><\/p>\n

    \n
    \"\"<\/span><\/div>\n
    form\u00fcl: <\/strong>IF(AND({Deal size}>350000,{Payment}=\"Paid\"),\"$2500\",\"$0\")<\/code> <\/span><\/div>\n<\/div>\n

    \n<\/p>

    Yukar\u0131daki form\u00fcl \u00f6rne\u011fi \u015fu \u015fekilde \u00e7al\u0131\u015facakt\u0131r: <\/span><\/p>\n