Column Formulas

Calculating using other columns

As an example, let's say you had two data columns (column A and column B) and wanted a third column to show the sum of A and B

Hover your mouse over third column's type (It's currently 'Unknown')

Now, click on 'convert to formula column'. A window will pop up.

We want to add columns A and B, so type 'col(A) + col(B)' in the text box. Next, click on OK.

Filling in columns automatically using 'row'

The first example showed you how to calculate using column data. You can also access the row number of a column. If, for example, you wanted a column with data like this:

You could fill it in automatically with a formula of 'row * 10':

Formula Syntax

Column formulas use the same syntax as curve-fit formulas, except that instead of curve fit variables, you reference columns and rows. Here are some examples

What	Example	Explanation
Absolute column reference	col(A)	References the data in column A
Relative column reference	col(-2)	Second column to the left
	col(+3)	Third column to the right
Row offsets	col(A,-3)	Column A, three rows up
	col(-2,+3)	Two columns to the left, three rows down
Row Data	row	Fills each row with the row number
	row * 10	Fills each row with 10 times the row number

For information on operators, operator precedence and functions, see curve-fit formulas.

Converting back to a data column

You can convert a formula column back to a data column. If you do this, the column will be filled in with the current formula column values, but it will now be editable.

Hover your mouse above the column's type

Click on 'Convert to data column'