# 18 - Course macros and Excel VBA - IF Then Else скачать в хорошем качестве

# 18 - Course macros and Excel VBA - IF Then Else

18 - Course macros and Excel VBA - IF Then Else In the eighteenth class we use the structure ... DO WHILE LOOP to create a sum but with the aid of a supplementary function, the IF function. With the IF statement can apply criteria our cells and leave to the code to decide whether to use it or not in formulas. In this lesson we will somatatória positive values ​​and negative values ​​separately using the IF function in conjunction with the DO WHILE. Topics covered in class: Repeating Structures  - How to use criteria in repeating structures  - IF Function     - Creating a sum for positive numbers     - Creating a sum for negative numbers Function IF .. THEN ... ELSE ... END IF I hope you enjoy the content. If you like to share with your co-workers and friends! ************************************************ complete course of Advanced Excel Online. Go! http://curseduca.com/136-microsoft-ex... ************************************************ Access spreadsheets: www.sigaonerd.com Article on variables http://support.microsoft.com/kb/84314... OTHER COURSE CLASSES - Microsoft Excel Lesson 1 - Introduction to Course and description of what is a macro    • #01 - Macros Excel VBA - Aprenda a programar   Lesson 2 - First macro: configure automatically page    • #02 - Macros e Excel VBA - Aprenda a progr...   Class 3 - Types of macros: Relative or Absolute    • #03 - Curso de Macros e Excel VBA - Referê...   Lesson 4 - Associating macros buttons    • #04 - Curso de Macros e Excel VBA - Botões...   Lesson 5 - Macro Security    • #05 - Curso de Macros e Excel VBA - Segurança   Lesson 6 - Registration Client - Model 1    • #06 - Macros e Excel VBA - Curso Grátis e ...   Lesson 7 - Registration Client - Version 2    • #07 - Macros e Excel VBA - Cadastro de Cli...   Lesson 8 - Combo Box - Form Control    • #08 - Macros e Excel VBA - Caixa de Combin...   Lesson 9 - Checkbox and Radio Button - Form Control    • #09 - Macros e Excel VBA - Caixa de Seleçã...   Lesson 10 - List Box and Spin Button - Form Control    • #10 - Macros e Excel VBA - Controle de For...   L11 - Start of VBA programming activities    • #11 - Macros e Excel VBA - Começando a pro...   Lesson 12 - Events (Activate, Calculate), comment code, RANGE instruction and Verification Immediate    • #12 - Macros e Excel VBA - Eventos e Instr...   Lesson 13 - Variables in VBA    • #13 - Macros e Excel VBA - Tipos e Uso de ...   Lesson 14 - Variables in Visual Basic for Applications (continued)    • #14 - Macros e VBA - Excel - Tipos de Vari...   Class 15 - Repetition structure - DO WHILE ... LOOP    • #15 - Macros e Excel VBA - Do While - Loop   Lesson 16 - Repetition structure - DO WHILE ... LOOP (reverse)    • #16 - Curso de Macros e Excel VBA - Do Whi...   Lesson 17 - Repetition structure - DO UNTIL ... LOOP    • #17 - Curso de Macros e Excel VBA - Do Unt...   Youtube channel confirmation link    / @alessandrotrovato   Follow us on Facebook or Twitter   / sigaonerdpontocom     / aletrovato   Excel is a Microsoft Office program