LOG10 macro
The LOG10
macro
is available only in HCL®
Campaign.
Syntax
LOG10(data)
Parameters
data
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 HCL
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.
Examples
TEMP = LOG10(100) Creates
a new column named |
TEMP = LOG10(V1) Creates
a new column named |
TEMP = LOG10(V1:V3) Creates
three new columns named |
TEMP = LOG10(V1[10:20])
Creates a new column named |
TEMP = LOG10(V1[1:5]:V2)
Creates two new columns named |
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 |