Creating Formulas in Worksheets

You can create formulas in worksheet cells. Formulas are stored until deleted from the cell.

  To create formulas within cells:

  1. On the worksheet, click a cell.

  2. Enter a formula.

    Begin with an equal sign and proceed with the formula. For example:

    =SUM(B5:B18)

    To reference a cell in your calculation, click that cell following a mathematical operator.

    For more information, read the Formula One help.

    Caution!

    If you use @na in a formula, do enter it in quotes—“na”. The string “na” is handled as an variable, and returns zero instead of executing @na.