# 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