Supported math functions in estimating formulas
About math functions
- The following functions have similar spellings and cannot be referenced together in the same formula:
- log and log10
- sqr and sqrt
- sin and asin
- cos and acos
- tan and atan
-
Variable codes must be unique and must not contain text that matches a math function. Otherwise, an error is generated. For example, a variable named FloorWidth does not work because it contains text that matches the FLOOR function.
| Function | Comments |
|---|---|
| min | min(value 1, value 2) |
| max | max(value 1, value 2) |
| exp | Exponential |
| log | Logarithmic |
| log10 | Logarithmic base 10 |
| abs | Absolute value |
| sqr | Square |
| sqrt | Square root |
| sin | sin(degrees) |
| cos | cos(degrees) |
| tan | tan(degrees) |
| asin | asin(degrees) |
| acos | acos(degrees) |
| atan | atan(degrees) |
| round | Rounds to the nearest whole number. For example, 3.2 becomes 3 and 3.7 becomes 4. |
| floor | Rounds down to the nearest lower whole number. For example, 3.7 becomes 3. |
| ceiling | Rounds up to the next higher whole number. For example, 3.2 becomes 4. |