LOG10 macro

The LOG10 macro is available only in IBM® Campaign.

The numerical values to compute the base10 logarithm 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.

Description

LOG10 calculates the base-10 logarithm of the values in the specified data range. It returns one new column for each input column, each containing the base10 logarithm of numbers in the corresponding input column.

All values in the specified data range must be greater than zero. Otherwise, a blank cell is returned for each invalid input.

Examples

TEMP = LOG10(100)

Creates a new column named TEMP containing the value two.

TEMP = LOG10(V1)

Creates a new column named TEMP, where each value is the base10 log of the contents of column V1.

TEMP = LOG10(V1:V3)

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

TEMP = LOG10(V1[10:20])

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

TEMP = LOG10(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 base-10 logs of the corresponding rows of column V1, and the values in column VX are the base-10 logs of the corresponding rows 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
POW	Exponential power