In numeric data table columns, you can enter cell expressions that are preceded by an equal sign (=). JMP evaluates the expression and stores the new number as the cell’s value. Unlike column formulas, a cell expression is not stored. Cell expressions can contain operators, constants, and global and column variables.
To enter an expression
1. Click the cell where you want to enter the expression.
2. Type an equal sign (=), and then enter the expression (Table 4.1).
3. Press Enter.
|
Example Expression |
Cell Value |
|---|---|
|
=sqrt(2) |
1.41 |
|
=456+890 |
1346 |
|
=height+weight |
Sums the values of cells in columns height and weight that are located in the same row as the cell where you entered the expression. |
|
=height[1] |
Displays the value that is found in row 1 of the height column. |