Returns the logarithmic value of the number passed to the function. If no base is mentioned then calculates logarithm to the base 10.
= LOG(value)
= LOG(value, base)
|
value |
A number whose log value is to be calculated. The number can be specified as an integer (e.g., 37), a decimal value (e.g., 37.48), as a string, or as the value of a variable (e.g, UnitPrice). |
|
base (optional) |
A number which is the base of the logarithm. The number can be specified as an integer (e.g., 37), a decimal value (e.g., 37.48), as a string, or as the value of a variable (e.g, UnitPrice). |
Decimal number.
In the case of an error, the function displays an error message: “LOG(value): Error message” (or) “LOG(value, base): Error message”
The function can be used in combination with other functions.
|
Example |
Returns |
|
= LOG(3) |
0.4771 |
|
= LOG(-2) |
An error message. |
|
= LOG(“$1”, 2) |
0 |
|
= LOG(10, 2) |
3.3219 |
|
= LOG(UnitPrice, 3) |
The log value of the UnitPrice to the base 3 |
|
= LOG(“abcd”, 5) |
Displays message “LOG(abcd, 5): Input string was not in a correct format.” |
|
= POWER(LOG(UnitPrice), 2) |
The square of the logarithm value of UnitPrice |
|
= MAX(LOG(UnitPrice,3), 12) |
The maximum among the logarithm value of UnitPrice to the base 3 and the number 12. |