log(X;Y)
Returns the logarithm of the first value to the base of the second value.
Syntax
log(X;Y)Input
| Argument | Type | Description |
|---|---|---|
X |
integer or decimal | A numeric value |
Y |
integer or decimal | The base to use to compute the logarithm |
Return Value
Returns a decimal number corresponding to the logarithm of X to the base
Y, or logY(X).
If X and/or Y is N/A, the result is N/A.
Sample Usage
X |
Y |
log(X;Y) |
|---|---|---|
| 8 | 2 | 3 |
| 32 | 2 | 5 |
| 10,000 | 10 | 4 |
| 0.0625 | 4 | -2 |
| NA | 2 | 0 |
| 8.0 | NA | NA |
| NA | NA | NA |