Using Formulas

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

• • Addition— +

  • Subtraction— -

  • Multiplication—*

  • Division—/

  • Exponentiation—^: x^y, x raised to the power of y

  • Logarithm—log

  • Square root—sqrt: sqrt(16)

  • Sine—sin

  • Cosine—cos

  • Tangent—tan

  • Arcsine—asin

  • Arccosine—acos

  • Arctangent—atan

  • 10 raised to an x power—exp(x)

  • Absolute Value—abs

  • Pi—pi (3.141493...)

You can enter integers, decimals, and fractional values in formulas, using normal mathematical syntax, as shown in the examples below:

• • Length = Height + Width + sqrt(Height*Width)

  • Length = Wall 1 (11000mm)+ Wall 2 (15000mm)

  • Area = Length (500mm) * Width (300mm)

  • Area = pi() * Radius ^ 2

  • Volume = Length (500mm) * Width (300mm) * Height (800 mm)

  • Width = 100m * cos(angle)

  • x = 2*abs(a) + abs(b/2)

  • ArrayNum = Length/Spacing

You can use the round function for values in formulas.