Using functions in formulas

When you insert a function into a formula, the abbreviation of that function appears in the formula text area. Parentheses after the abbreviation mean that you need to provide one or more values for calculating the function. A separator (shown as a comma in the Help Topics) appears between multiple values. Example

Depending on the function, these values can be numbers, constants, variables, formulas, or other functions. For details, click on a function in the list below.

• absolute value

• arc cosine

• arc sine

• arc tangent

• average

• cosine

• duration

• hyperbolic cosine

• hyperbolic sine

• hyperbolic tangent

• if/then logic

• job size

• maximum

• minimum

• modulus

• power

• quantity

• round

• round to nearest

• sine

• square root

• summation

• tangent

• truncate