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
.value
must be positive. -
base
- (optional) The base to use for calculation of the logarithm. If base is not provided, LOG returns the logarithm ofX
with 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 |