Using JMP > Enter and Edit Your Data > Enter Data in Data Tables > Enter Cell Formulas into Data Table Columns
Publication date: 03/23/2021

Enter Cell Formulas into Data Table Columns

In numeric data table 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 (Table 4.1).

3. Press Enter.

Table 4.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

Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).