Differences

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

--- en:process_steps:if_lists [2020/02/23 02:15]
tiger
+++ en:process_steps:if_lists [2020/05/16 23:56] (current)
tiger
@@ Line 27: / Line 27: @@
 </code>
-You can use any condition that you would use with the MS Excel IF formula (referencing cells and ranges according to the Djeeni formula syntax). Some examples:
+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          'cell A4 on the worksheet wsSource contains 5 (numeric value)
+  [$wsSource!A4] > 5          'value of cell A4 on the worksheet wsSource is bigger than  5 (numeric value)
-  [#] = 2                     'the current row number of a Row List is 2
+  [#] = 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>