Using JMP > Formula Functions Reference > Numeric Functions
Publication date: 08/13/2020

Numeric Functions

You can create a formula that contains arithmetic operators that are commonly used in formulas. See Numeric Functions in the Scripting Guide for more information about syntax.

Abs

Returns a positive number of the same magnitude as the value of its argument. For example, |5| and |–5| both result in 5.

Ceiling

Returns the smallest integer greater than or equal to its argument. For example, Ceiling(2.3) results in 3, while Ceiling(–2.3) results in –2.

Floor

Returns the largest integer less than or equal to its argument. For example, Floor(2.7) results in 2, but Floor(–0.5) results in –1.

Integrate

Integrates an expression with respect to a scalar value, using the adaptive quadrature method from Gander and Gautschi (2000). For example, Integrate( Exp( -x ), x, 0, . ) results in 0.99999999986846.

Modulo

Returns the remainder when the second argument is divided into the first. For example, Modulo(6, 5) results in 1.

Round

Rounds the first argument to the number of decimal places given by the second argument. For example, Round(3.554, 2) rounds to 3.55 and Round(3.555, 2) rounds to 3.56.