I'm trying to get the log of a number but it looks like the Worksheet function gives one answer, and VBA another.
In VB, using Log(Range("A2"))
where A2 is 7, I get 1.94591014905531
, which is the correct answer. But, if in the worksheet, I use =Log(A2,10)
or =Log10(a2)
, I get 0.84509804
. What's going on here?
VBA's Log
function is the natural log. If you want log base ten you will have to use the logarithmic identity for converting bases. Like so: Log(x)/Log(10)
.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With