The LOG function returns the logarithm of a number using a specified base. Both arguments are number values.
LOG(pos-num, base)
pos-num: A number on which to base the logarithm. pos-num must be greater than 0.
base: An optional number specifying the base of the logarithm. base must be greater than 0. If base is 1, a division by zero will result and the function will return an error. If base is omitted, it is assumed to be 10.
Examples |
|---|
=LOG(8, 2) returns 3. =LOG(100, 10) and =LOG(100) both return 2. =LOG(5.0625, 1.5) returns 4. |