next up previous contents index
Next: 6.2.5 Cell Referencing in Up: 6.2 NExS Formulas Previous: 6.2.3 Formula Operators

6.2.4 Referencing Other Cells in Formulas

   

The real power of NExS lies in its ability to calculate relationships among different cells in the spreadsheet. NExS provides several ways within a formula to reference other cells. You can:

To reference a cell by address:

Type the row and column coordinates of the cell in the formula. For example, to reference Row 5 in Column D, type D5.

OR

While entering a formula, move the mouse pointer to the cell to be referenced and click once. In input mode, NExS inserts the cell reference after the last character entered. In edit mode, NExS inserts the cell reference at the cursor location in the Edit Line.

To reference a contiguous group of cells by address:

Type the row and column coordinates of two cells in opposite corners of the block to be referenced, with two periods ( .. ) between the coordinates. For example, to reference the first five columns and the first five rows of the spreadsheet, type A1..E5.

OR

Move the mouse pointer to one corner of the block or range to be referenced. Press the left mouse button and drag the mouse to the opposite corner, then release the mouse button. In input mode, NExS inserts the cell reference after the last character typed. In edit mode, NExS inserts the cell reference at the cursor location.

To reference a cell or range by name:

Type the pre-assigned name of the cell or cell block into the formula.


To assign a name to a cell or range of cells, use the Named Range utility in the Edit menu. For more information about named ranges, refer to Chapter 5, Manipulating the Spreadsheet.


next up previous contents index
Next: 6.2.5 Cell Referencing in Up: 6.2 NExS Formulas Previous: 6.2.3 Formula Operators

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999