Formulas support standard arithmetic operations and trigonometric functions.
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.
The valid formula abbreviations for arithmetic operations and trigonometric functions are
You can enter integers, decimals, and fractional values in formulas, using normal mathematical syntax, as shown in the examples below:
| Function syntax | Description | Examples |
|---|---|---|
| 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.