EXP macro

The EXP macro is available only in HCL® Campaign.

Syntax

EXP(data)

Parameters

data

The numerical values used as an exponent to the natural number, e. 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 HCL product.

Description

EXP raises the natural number, e, by each of the values in the specified data range (that is, calculates ). The constant e equals 2.7182818. EXP returns one new column for each input column, each containing the result for each value x in the corresponding input column(s). EXP is the inverse of the LN macro function.

Note: If the value x is too large or too small, an overflow error is returned. This occurs if exceeds the maximum or minimum 32-bit floating-point value.

Examples

TEMP = EXP(2)

Creates a new column named TEMP containing the value 7.39.

TEMP = EXP(V1)

Creates a new column named TEMP, where each value is result of raising e to the contents of column V1.

TEMP = EXP(V1:V3)

Creates three new columns named TEMP, VX, and VY. The values in the TEMP column are the results of raising e to the column V1, the values of the VX column are the results of raising e to the contents of column V2, and the values of the VY column are the results of raising e to the contents of column V3.

TEMP = EXP(V1[10:20])

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

TEMP = EXP(V1[1:5]:V2)

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 results of raising e to the corresponding row values of column V1, and the values in column VX are the results of raising e to the corresponding row values of column V2.

Related functions

Function Description
LN or LOG Computes the natural log of the contents of the specified data range
LOG2 Computes the log base2 of the contents of the specified data range
LOG10 Computes the log base10 of the contents of the specified data range
POW Exponential power