Using Formulas

To assign formulas to a column, go to the Property Page, select Column Format and change the Formula property.

 

A formula is an expression stored in a column that performs operations in order to insert values into that column. Formulas can perform mathematical operations, such as addition and multiplication, or they can compare column values or join values by referring to other columns either in the same DataSheet or in another sheet of the working DataBook. For example, if you record the length (L) in one column and width (W) in another column, you can use the formula W * L to automatically calculate the area (A) and store the product in a third column.

 

Assigning formulas can save you time and simplify the process of manually updating the data calculations that you frequently repeat. For example, by assigning a formula to a column, you can:

Calculate sums, differences, products, and quotients between columns (e.g. find total sales)

Convert from one unit to another (e.g., Fahrenheit to Celsius)

Perform data transformations to satisfy statistical assumptions

 

You can assign formulas only to an entire column, not to rows, individual cells, or parts of columns.

 

 

Updating calculations

If you assign a formula to a column and then add or change data values that a formula depends on, you can have the calculated values update automatically by giving TRUE value to AutoCalculation property (the default setting) of the DataSheet (see Property Page).

 

 

Editing data

If you assign a formula to a column, the data become dependent on data in other columns. For this reason, you may not be able to directly manipulate and edit data in a column with an assigned formula. If you were to change the value of a calculated cell without changing the corresponding formula, you must use the equal sign (=) to assign the desired value.

 

 

Formula Overview

Overview

Referencing

Operators

Error Values