CommonFormula

Revision as of 14:28, 8 January 2009 by Jcheng (Talk | contribs)

Jump to: navigation, search

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