Returns the logarithm of a number with respect to a base.
Sample usage
LOG(128,2)
Syntax
LOG(value [, base])
Parameters
-
value
- 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 of a number, base e (Euler's number).
Examples
Formula | Input | Output |
LOG(My field, 2) |
128 | 7 |
LOG(My field, 10) |
128 | 2.10720997 |
LOG(My field) |
128 | 4.852030264 |