Calculate > Calculator

This utility parses and evaluates mathematical expressions. It supports addition, subtraction, multiplication, division, power, and a collection of common mathematical functions (such as sin, cos, tan, exponential, etc). Operands can be numbers or numerical data within columns, and the results can be stored in the Datasheet.

Expression Format

a and b can be numbers, column numbers, column variable names (delimited by "") or valid expressions of the format described above. function_name has to be a valid function name (described below). The parser is case-sensitive (uppercase and lowercase letters are different). Parentheses must be matched.

Operator Precedence and Associativity

Available Functions

Functions must be invoked in the form of function_name( a ), where the argument a is a valid expression.

abs
absolute value
arccos
arc cosine / cosine inverse
arcsin
arc sine / sine inverse
arctan
arc tangent / tangent inverse
ceil
ceiling (smallest integer that is not less than the argument)
cos
cosine
exp
Euler's number e raised to the power of the argument
factorial
factorial x! = x(x-1)(x-2)...1
floor
floor (largest integer that is not greater than the argument)
ln
natural logarithm
log
logarithm base 10
round
round to the closest integer, obtained by floor(a + 0.5)
sin
sine
sqrt
square root
tan
tangent

For Trigonometric Functions

Select whether the input is specified in radians or degrees. The conversions from radians to degrees and from degrees to radians are generally inexact. Thus, do not expect arccos(cos(x)) to be exactly x degrees.

Input Interface

Enter a mathematical expression directly into the expression text box, or use the provided buttons and function list to construct your input expression. The numbers 0 to 9, the decimal point ., and the constant π are available in the Numbers panel. The operators +, -, *, /, ^, &radic (square root), e^ (exponential), and parentheses are available in the Operators panel. The Functions panel contains the list of mathematical functions available. To use a function in the list, first click on the function name, then click the Select button. For trignometric functions, select radians or degrees mode using the corresponding radio buttons. Click OK to evaluate the input expression. The result is displayed the the results panel. Click Back for backspace, and Clear to clear the input box and results panel.

Store Results in Datasheet (optional)

Computed results can be stored in a column of the current Datasheet. If storing results is desired, enter the column name or variable name (e.g. C1) in the provided text box.