Other Content

Table Of Contents
320 Lists&Spreadsheet Application
Lists&Spreadsheet inserts the leading equal sign (=) for the formula. If the
column is a named list, Lists&Spreadsheet inserts listname:= followed by
the cursor.
2. Type the expression for the formula after the = and press Enter Use
brackets ([]) after any column letter you include in the formula. For
example, type =a[]^2 to create a column of values in which each cell is
the square of the corresponding cell of column A.
Lists&Spreadsheet shows the formula in the formula cell and fills the
column with the results.
Generating a Column of Random Numbers
This example generates a column of 20 random integers in the range 1
through 6.
1. Click the column formula cell (the second cell from the top) of the column.
Lists&Spreadsheet inserts the leading equal sign (=) for the formula. If the
column is a named list, Lists&Spreadsheet inserts listname:= followed by
the cursor.
2. After the equal sign, type RandInt(1,6,20).
Note: You can also use the Catalog or click Data > Random > Integer to
insert the RandInt() function.
3. Press Enter to generate the numbers.