You can create a column of values based on the contents of another column or on any of several types of sequential data.

	Column formula based on a variable
	Column formula based on another column
	Column formula that generates a sequence

 

1.

Tap the column formula cell (the second cell from the top) of the column where you want to use a formula.

2.

Type the expression for the formula after the = and tap ENTER.

Note: Use brackets ([]) after any column letter you include in the formula.

 

1.

Tap the column formula cell (the second cell from the top) of the column.

2.

Tap Tools  and go to Data > Random > Integer to insert the randint() function.

3.

The app inserts the randint() function in the formula cell.

4.

Type 1,6,20, and then tap ENTER.

Note: The numbers given are for illustrative purposes only, and will generate a column of 20 random integers in the range, 1 through 6.

 

1.

Tap any cell in the column in which you want to generate the sequence.

2.

Tap Tools  and go to Data > Generate Sequence.

3.

Type the Formula that will be applied to the column values.

4.

Type any starting numbers required by the sequence in the Initial Terms field and separate them with commas.

5.

Type a starting value for the independent variable (n0), a maximum number of values to be generated (nMax), and the step value (nStep).

Note: Type a maximum value for the sequence in the Ceiling Value field, if desired.

6.

Tap OK.