Skip to main content

Which expressions can I use in value fields in SimaPro cloud edition?

Updated today

The expressions you can use in value fields and for parameters in SimaPro cloud edition are:

  • Plus (+), minus (-), division (/), modulo (%), multiplication (*), power (^).

  • Equal (=), unequal (<>).

  • Smaller than (<), smaller than or equal to (<=), larger than (>), larger than or equal to (>=).

  • Scientific notation (2.3E-7).

  • IF statements (2 IF Parameter1 == 4 ELSE 1).

  • AND statements (2 IF(Parameter1 == 4 AND parameter2 == 2) ELSE 5).

  • OR statements (2 IF(Parameter1 == 4 OR parameter2 == 2) ELSE 5).

  • MAX and MIN functions (MAX(2;5)), (MIN(2;5)). Note! For more than 2 arguments, please adapt the function to (MAX(1;MAX(2;5))), (MIN(1;MIN(2;5)))

  • Parentheses for resolving sub-expressions (2*(4-3)).


These expressions can be used in the parameter page, or in any other value field. For more specific places it can be used see this article.
​
​Note! These expressions work as long as there is no division by zero.

Did this answer your question?