Enter Cell Formulas

JMP Support 800.450.0135 (US)

Documentation Feedback
Your feedback is important to us. us any comments about our documentation.

Using JMP • Enter and Edit Data • Enter Data • Enter Cell Formulas

•

Enter Cell Formulas

In numeric columns, you can enter cell expressions 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 type the expression. See Table 3.1.

3.

Press the ENTER key.

Table 3.1 Examples of Expressions in Table Cells
Example expression	Cell value
=sqrt(2)	1.41
=456+890	1346
=height+weight	Sums the values of cells in columns height and weight located in the same row as the cell that you entered the expression.
=height[1]	Displays the value found in row 1 of the height column

•

Help created on 7/12/2018