How to Create Column Data Based on Another Column - dummies

How to Create Column Data Based on Another Column

By Jeff McCalla, Steve Ouellette

When you’re working in the Lists & Spreadsheet application on the TI-Nspire, you can create column data based on another column. Assume that you’re interested in finding the sum of the dice for each trial. You can use the header row to accomplish this task.

Just move to the formula cell for column C, type =a[]+b[], and press [ENTER]. The first screen shows the results of this action.

When referencing a column in the formula row, you must include an empty set of brackets, accessed by pressing [CTRL][ ( ] after the column letter.

Perhaps you chose to name the first three columns first_die, second_die, and total, respectively. Rather than use a letter reference for a column, you can reference these list names. After naming the first two columns, follow these steps:

  1. Move the cursor to the formula cell for column C and press the [=] key.

    Notice that total:= automatically appears in the header row.

  2. Press [VAR], highlight first_die, and press [ENTER].

  3. Press [+].

  4. Press [VAR], highlight second_die, and press [ENTER].

    See the second screen.

  5. Press [ENTER] to complete the command.

    See the third screen.


If you are following along, your screen may differ from the screen shown. That’s okay. Remember, these are random integers, and it’s to be expected that they will differ each time.