There are two ways to refer to other cells in Formulas, “Absolute” and “Relative” references
Excel allows you to enter ‘Logical’ operators in cells.
These are listed below
IF( formula1, formula2, formula3 )
AND( formula1, formula 2 )
OR( formula1, formula 2 )
There are a few preliminary steps that must be taken before you can start writing VBA macros.
For you must add the “Developer” option to the Excel main menu. This option is not turned on by default.
Most macros will have at least one parameter. This is the list of names after the word ‘Function’ and the name of the function.
VBA expressions follow the natural path that is familiar from mathematical expressions
Once your calculations get a little more complex you will need to use “local variables”.
These are values that are defined only within a single function