Differences

This shows you the differences between two versions of the page.

--- en:process_steps:if_lists [2020/02/23 01:41]
tiger
+++ en:process_steps:if_lists [2020/05/16 23:56] (current)
tiger
@@ Line 17: / Line 17: @@
 <code>
   If <condition1>
-    ...Process steps...
+    ...Process steps if <condition1> is true...
     If <condition2>
-      ...Process steps...
+      ...Process steps if both conditions are true...
     Else
-      ...Process steps
+      ...Process steps if <condition1> is true but <condition2> is false
-    End IF
+    End If
+    ...Process steps if <condition1> is true...
   End If
 </code>
+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:
+<code>
+  [$wsSource!A4] > 5          'value of cell A4 on the worksheet wsSource is bigger than  5 (numeric value)
+  [#] = 2                     'the current row/column number of a Row/Column List is 2
+  [$wsSource!C#] = "Finance"  'the value of the cell in Column C and the current row number of a Row List is "Finance" (string value)
+</code>