In the Formula dialog box, enter the expression.

  1. In Expression, build the formula by doing any of the following:
    • From Functions, select a function, then click Insert Function. For more information, go to Functions for formulas.
    • Double-click a variable to insert it.
    • Click an operator to insert it. For more information, go to Operators for formulas.
  2. Click OK.

Column names

Enclose column names in single quotation marks (for example, 'pipe diameter'). You can also enter column IDs (for example, C1).

Missing values

Denote missing numbers with the missing value symbol * enclosed in single quotation marks ('*').

By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy