Formulas are the backbone of the NExS spreadsheet, defining relationships between the values in other cells. For example, formulas can be used to sum a column of numbers, compute an average, determine a minimum or maximum value, or round the results of a calculation.
Whereas constant entries remain the same until you change them, cells defined by formulas are automatically changed to reflect changes in referenced cells - even where there are complex interdependencies among cells.
Once entered in a cell, formulas are hidden behind the scenes, performing their work in the background and displaying only the result of their calculation. To view the formula in a cell, move the cell cursor to the cell. NExS displays the formula in the Edit Line. You can edit the formula or values in cells by selecting the Edit Cell option from the Edit menu or by positioning into the cell contents in the Edit Line with the mouse.