# LOG

LOG(number [,base])

Returns the logarithm of a number to any base.

 number The number you want the logarithm of. base (Optional) The base of the logarithm.

 REMARKS
 * If "number" < 0, then #NUM! is returned.* If "number" is not an integer, it is truncated.* If "base" is left blank, then 10 is used.* If any of the arguments are not numeric, then #VALUE! is returned.* You can use the LOG10 function to return the logarithm of a number to the base 10.* You can use the LN function to return the natural logarithm of a number (to the base e).* There is no equivalent VBA function.* There is a VBA function called LOG but this is the equivalent of Excel's LN function.* The natural logarithm is the logarithm to the base e. The constant e is approximately 2.718282.* There is a VBA function with the same name VBA.LOG but it does something completely different.* For the Microsoft documentation refer to support.microsoft.com* For the Google documentation refer to support.google.com

 A 1 =LOG(12) = 1.08 2 =LOG(10) = 1 3 =LOG(10.9) = 1.04 4 =LOG(8,2) = 3 5 =LOG(16,2) = 4 6 =LOG(86,2.7182818) = 4.454 7 =LOG(-16,2) = #NUM! 8 =LOG("some text") = #VALUE! 9 =LOG(12,"some text") = #VALUE!