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