Flow Of Control family
| Miscellaneous category | Home |
Functions that involve dictating which value is used for subsequent calculations.
| Component | What the name means |
|---|---|
| Switch | Switch (Select Case) |
| SwitchR | Switch with Ranges |
| SwitchT | Switch (Select Case) for Text |
| SwitchRT | Switch (Select Case) for Text Ranges |
| IfElse | If...ElseIf...Else |
| IfElseR | If...ElseIf...Else with Ranges |
| IfElseT | If...ElseIf...Else for Text |
| IfElseRT | If...ElseIf...Else with Ranges for text |
| GoalSeek | Set up the parameters for an embedded GoalSeek to be carried out by CalculateFull |
| Def | Get the value or its Default value |
| SwitchX | Extended Switch for returning any data type, including ranges |
This family adds a few functions to the commonly use IF and other logical functions, drawn from conventional programming constructs, principally 'If...else' and 'Switch'.
Three suffixes are used in this family:
- 'R' suffix means that ranges are used as inputs, instead of individual cells.
- 'T' means the function is designed for text inputs and outputs, rather than numerical.
- 'RT' is a combination of the above, ie using text ranges.