İf Formula 7 And More Online Excel and Excel Macro (VBA) Courses Copy Macro 'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php 12 adet eğer formülünü araya + işlecini koyarak 2 ye bölmektir. Formül B1 hücresine yazılmış ve A1 hücresindeki veriyi kontrol etmektedir. =EĞER(A1="OCAK";OCAK!A1;EĞER(A1="ŞUBAT";ŞUBAT!A1;EĞER(A1="MART";MART!A1;EĞER(A1="NİSAN";NİSAN!A1;EĞER(A1="MAYIS";MAYIS!A1;EĞER(A1="HAZİRAN";HAZİRAN!A1))))))+EĞER(A1="TEMMUZ";TEMMUZ!A1;EĞER(A1="AĞUSTOS";AĞUSTOS!A1;EĞER(A1="EYLÜL";EYLÜL!A1;EĞER(A1="EKİM";EKİM!A1;EĞER(A1="KASIM";KASIM!A1;EĞER(A1="ARALIK";ARALIK!A1)))))) Report problem with this macro This macro does not work. There's an error in the code. Other You can write your comments about the error in the box below. Report error ALL MACROS Youtube Channel The following macros may be useful for you. Similar Results NoMacro Name 1 if formula 7 and more 2 right mouse on active sheet / page menu 3 excel operators hk 4 fonts in word 5 excel fonts 2 6 calculator on / off 7 Increase the value within the cell by looking at the number value or assign its formula by number value 8 excel fonts 9 Copy and paste with macro 10 write the days of this month to the right write the day to the child cell and color the weekends 11 inserts months as sheet / pages Specifies days in detail 12 double-click on active cell to add subtotal 13 Advanced VLOOKUP Formula: Returns the expression of the value passed the second or third time if the searched value is passed more than once. 14 time format in active sheet / page and target cells 15 date format in active sheet / page and target cells 16 a1e force to enter date with vba 17 Undo cells with 0 18 adding two lines and removing total 19 gives the address and type of formula if the active cell contains a formula 20 Track and Report User Changes in an Excel worksheet or workbook