Calculations

Performs a calculation between columns and stores the result in the selected column. This calculation is only performed when the dialog is executed. The result is not updated when one of the columns form the calculation is changed!

Order of operations

This Calculator works according the BODMAS rule

1. B:
   Brackets ()
2. O:
   Order Exponentiation and Root extraction
3. DM:
   Division and Multiplication (left-to-right)
4. AS:
   Addition + and Subtraction - (left-to-right)
   

The operations are done in order of the list. Operations on the same level are executed in order of the formula.

Example 1

Example 2

This will Add the result in column G.

Data file

DOE mode

In case of the DOE mode is active an simpler dialog is displayed.

Example

This will Add the value from each populated row in A with B and stores the result in Column C.

Links

• https://en.wikipedia.org/wiki/Order_of_operations
• https://www.mathsisfun.com/operation-order-bodmas.html