This function returns the logarithm base Y of a number X.
Syntax
LOG(number,base)
Arguments
This function has these arguments:
| Argument | Description |
|---|---|
| number | Number for which to find a logarithm. This must be a positive real number |
| base | [Optional] Base of the logarithm; if omitted, the calculation uses 10 as the base (See LOG10.) |
Data Types
Accepts numeric data for both arguments. Returns numeric data.
Examples
LOG(B3,C5)
LOG(R1C2,R4C4)
LOG(255,16) gives the result 1.9985883592
Version Available
This function is available in product version 1.0 or later.
See Also
LN | LOG10 | Math and Trigonometry Functions