Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
en:process_steps:if_lists [2020/01/07 17:22] andraz created |
en:process_steps:if_lists [2020/05/16 23:56] (current) tiger |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== If / Lists Group [] ====== | + | ====== If - Else - End If ====== |
| + | |||
| + | The three process steps **If**, **Else** and **End If** together allow you to perform certain process steps if a condition is true (steps between **If** and **Else**) or false (between **Else** and **End If**): | ||
| + | |||
| + | < | ||
| + | If < | ||
| + | ...Process steps if < | ||
| + | Else | ||
| + | ...Process steps if < | ||
| + | End If | ||
| + | </ | ||
| + | |||
| + | **Else** is optional - in this case, all steps between **If** and **End If** are executed only if the condition is true. | ||
| + | |||
| + | You can nest **If**s: | ||
| + | |||
| + | < | ||
| + | If < | ||
| + | ...Process steps if < | ||
| + | If < | ||
| + | ...Process steps if both conditions are true... | ||
| + | Else | ||
| + | ...Process steps if < | ||
| + | End If | ||
| + | ...Process steps if < | ||
| + | End If | ||
| + | </ | ||
| + | |||
| + | You can use any condition that you would use with the MS Excel IF function (referencing cells and ranges according to the Djeeni formula syntax). Some examples: | ||
| + | |||
| + | < | ||
| + | [$wsSource!A4] > 5 'value of cell A4 on the worksheet wsSource is bigger than 5 (numeric value) | ||
| + | [#] = 2 ' | ||
| + | [$wsSource!C# | ||
| + | </ | ||
| + | | ||