Formulas support the following arithmetic operations: addition, subtraction, multiplication, division, exponentiation, logarithms, and square roots. Formulas also support the following trigonometric functions: sine, cosine, tangent, arcsine, arccosine, and arctangent.
|round(x)||The round function returns a value rounded to the nearest whole number. It doesn't take into consideration rounding direction.|| |
round(3.1) = 3
round(3.5) = 4
round(-3.7) = -4
|roundup(x)||The roundup function returns a value to the largest integral value greater than or equal to x.|| |
roundup(3) = 3
roundup(3.1) = 4
roundup(-3.7) = -3
|rounddown(x)||The rounddown function returns a value to the smallest integral value less than or equal to x.|| |
rounddown(3) = 3
rounddown(3.7) = 3
rounddown(-3.7) = -4
Parameter names in formulas are case sensitive. For example, if a parameter name begins with a capital letter, such as Width, you must enter it in the formula with an initial capital letter. If you enter it in a formula using lower-case letters instead, for example, width * 2, the software will not recognize the formula.