Difference between revisions of "CommonFormula"

Jump to: navigation, search
(New page: =conditional processing= (test) ? true-case : false-case =operators= {| {{prettytable}} !Function!!description!!Example |- |max(a,b)||return the maximum between a and b |- |min(a,b)||retu...)
 
Line 1: Line 1:
 
=conditional processing=
 
=conditional processing=
 
  (test) ? true-case : false-case
 
  (test) ? true-case : false-case
 +
 +
=conditional processing with operator OR/AND
 +
( test1 OR test2 ) ? true-case : false-case
 +
( test1 AND test2 ) ? true-case : false-case
 +
 
=operators=
 
=operators=
 
{| {{prettytable}}
 
{| {{prettytable}}

Revision as of 14:28, 8 January 2009

conditional processing

(test) ? true-case : false-case

=conditional processing with operator OR/AND

( test1 OR test2 ) ? true-case : false-case
( test1 AND test2 ) ? true-case : false-case

operators

Function description Example
max(a,b) return the maximum between a and b
min(a,b) return the minimum between a and b
abs(a) return the absolute value of a
roundCeil(a,b) return the a value round top to b roundCeil(106,5) return 110