Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Logarithm is different using VBA and Excel function

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?

like image 723
BruceWayne Avatar asked Jul 24 '15 19:07

BruceWayne


1 Answers

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).

like image 70
Michael S Priz Avatar answered Oct 14 '22 03:10

Michael S Priz