FORMULA LANGUAGE

Performing arithmetic operations
Example

The * / + - operators multiply, divide, add, and subtract. Multiplication and division have precedence over addition and subtraction; otherwise, evaluation is left to right. Parentheses can be used to change the order of evaluation. The following are the arithmetic @functions.

FunctionDescription
@Abs(number)Calculates the absolute (unsigned) value of a number.
@ACos(cosine)Calculates the arc (inverse) cosine of a cosine.
@ASin(sine)Calculates the arc (inverse) sine of a sine.
@ATan(tangent)Calculates the arc (inverse) tangent of a tangent.
@ATan2(x; y)Calculates the arc (inverse) tangent using the tangent y/x of an angle.
@Cos(angle)Calculates the cosine of an angle (in radians).
@Exp(number)Calculates e raised to the power of a number.
@FloatEq(number ; number ; range)Compares two numbers for equality within a confidence range.
@Integer(number)Truncates a number to an integer.
@Integer(numlist)Truncates the elements of a number list to integers.
@Log(number)Calculates the common (base 10) logarithm of a number.
@Ln(number)Calculates the natural (base e) logarithm of a number.
@Max(number ; number)Calculates the larger of two numbers.
@Max(numlist ; numlist)In a pairwise list operation, calculates the larger of two numbers.
@Max(numlist)Calculates the largest number in a list.
@Min(number ; number)Calculates the smaller of two numbers.
@Min(numlist ; numlist)In a pairwise list operation, calculates the smaller of two numbers.
@Min(numlist)Calculates the smallest number in a list.
@Modulo(number ; number)Calculates the remainder of a number divided by a second number.
@Modulo(numlist ; numlist)In a pairwise list operation, calculates the remainder of a number divided by a second number.
@PiCalculates the value of Pi.
@Power(base ; exp)Calculates the value of a base raised to the power of an exponent.
@RandomReturns a random number in the range 0 to 1, inclusive.
@Round(number)Rounds a number to the nearest integer.
@Round(number ; factor)Rounds a number to the nearest specified factor.
@Round(numlist)Rounds each number in a list to the nearest integer.
@Round(numlist ; factor)Rounds each number in a list to the nearest specified factor.
@Sign (number)Returns 1 for a positive number, -1 for a negative number, and 0 for zero.
@Sin(angle)Calculates the sine of an angle (in radians).
@Sqrt (number)Calculates the square root of a number.
@Sum(num; num; ...)Calculates the sum of numbers and number lists.
@Tan(angle)Calculates the tangent of an angle (in radians).

Example
See Also