INTEGRAL

The numerical values to compute the integral of. This can be a constant value, a column, a cell range, or an expression evaluating to any of the above. For the format definition of data, see the "Macro Function Parameters" section in the chapter in this guide for your IBM® product.

multiplier

A value to multiply each value in data by. This can be a constant value or an expression evaluating to a constant.

Description

INTEGRAL calculates the integral of the values in a time-series. Each value is the sum of all previous values in time. If a value is provided for multiplier, each value is multiplied by the specified value. INTEGRAL returns one new column for each input column, each containing integral of the values in the corresponding input column.

Examples

TEMP = INTEGRAL(5)

Creates a new column named TEMP containing the value 5.

TEMP = INTEGRAL(COLUMN(1,2,3))

Creates a new column named TEMP containing the values 1, 3, and 6.

TEMP = INTEGRAL(COLUMN(1,2,3), 2)

Creates a new column named TEMP containing the values 2, 6, and 12.

TEMP = INTEGRAL(V1)

Creates a new column named TEMP, where each value is the sum of all previous cells in column V1.

TEMP = INTEGRAL(V1, 10)

Creates a new column named TEMP, where each value is the sum of all previous cells in column V1 times 10.

TEMP = INTEGRAL(V1:V3)

Creates three new columns named TEMP, VX, and VY. The values in the TEMP column are the integrals of column V1, the values of the VX column are the integrals of column V2, and the values of the VY column are the integrals of column V3.

TEMP = INTEGRAL(V1:V3)

Creates a new column named TEMP, where the first 11 cells contain the integrals of the corresponding values in rows 10-20 of column V1. The other cells in TEMP are empty.

TEMP = INTEGRAL(V1:V3)

Creates two new columns named TEMP and VX, each with values in rows 1-5 (the other cells are empty). The values in column TEMP are the integrals of the corresponding row values of column V1, and the values in column VX are the integrals of the corresponding row values of column V2.

Related Functions

Function	Description
DTEMP = INTEGRAL(V1:V3)	Computes the derivative of the values in the specified data range
SUM or TOTAL	Computes the sum of a range of cells