Returns the logarithm of a number with respect to a base.
Sample usage
LOG(128,2)
Syntax
LOG(X, [ base)
Parameters
-
X- The value for which to calculate the logarithm givenbase.valuemust be positive. -
base- (optional) The base to use for calculation of the logarithm. If base is not provided, LOG returns the logarithm ofXwith base e (Euler's number).
Examples
| Example formula | Input | Output |
|---|---|---|
LOG(My field, 2) |
128 | 7 |
LOG(My field, 10) |
128 | 2.10720997 |
LOG(My field) |
128 | 4.852030264 |