Site Tools


Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
en:process_steps:if_lists [2020/02/23 02:15]
tiger
en:process_steps:if_lists [2020/05/16 23:56]
tiger
Line 27: Line 27:
 </​code>​ </​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>​ <​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)   [$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>​ </​code>​
   ​   ​