|
Define a Function |
|
-
The definition begins with the function name left of the equal sign
-
Then follows the function symbol and the list of parameter
-
The function expression is defined right of the second equal sign
-
You get the function sign with the keys Ctrl + 5
|

|
|
Excamples |
- A call of a self-defined function must be marked with the function sign, left to the function name
|

|
|
|
|
|
- The arguments can be values, variable names, another function or any expressions
|

|
|
Visibility of Function Parameters |
-
The variables, defined as formal parameter, have own scope inside the function. They are visible in the function only and not outside their function.
-
It is allowed to use the same names in the argument list and elsewhere in the worksheet
-
In addition to the parameters, all global variables defined on the worksheet can be used within a function
|
|
|
Advertisement
|