Description
Returns the logarithm of the given number to the base 10.
Syntax
LOG(Number)
Arguments
Argument | Type | Dimensions | Description |
---|---|---|---|
Number (required) | Number | Any Dimensions | Number to return the logarithm to the base 10 for. |
Returns
Type | Dimensions |
---|---|
Number | Dimensions of Number |
Negative Numbers return BLANK
.
Examples
Formula | Result | Description |
---|---|---|
LOG(1) | 0 | log(1) equals 0. |
LN(100) | 2 | log(100) equals 2. |
LN(0.5) | -0.30103 | log(0.5) equals -0.30103. |
LOG(-2) | BLANK | -2 is a negative number, the function returns BLANK . |
See also
Excel: LOG