Why is the Log (number, base) function missing in Excel VBA?

Answer 1

There is no Log(number, base) function in Excel VBA for three reasons:

1. Log(number, base) = Log(number)/Log(base), where "Log" on the right-hand side of this expression is the VBA Log function.
2. The designers of VBA assumed you know that Log(number, base) = Log(number)/Log(base).
3. The designers of VBA did not want to create the function Log(number, base) knowing that Log(number, base) = Log(number)/Log(base) is true and can be used instead of Log(number, base).

Answer 2

Probably because it requires some type of math library.

But mine works!!!

I threw a command button on the document and wrote this code:

Private Sub CommandButton1_Click()

MsgBox (Log(100) / Log(10))

End Sub

Keep in mind this is the NATURAL LOG base e = 2.713......

The message box shows a result of 2.

Per the change of base formula, for base 10 log, you

divide by Ln(10)

cheers!