Excel 2000 VBA math functions

[Philipj]

While I have been a programmer for quite a while, I am a novice to Excel VBA and VB in general.

I need to use both log to the base 10 [Log ... mathematics notation] and the natural log [Ln]. Excel has Ln, LOG10, and LOG(n,b). Unfortunately, I only find Log in the VBA math library. Even weider the VBA Log function appears to actually be the natural log rather than common log.

Can someone explain if what I have seen is strange or standard. Are there Log10, Log(n,b) and Ln function in a VBA library?

[WorkHorse]

The Log that you see is the standard VB Log function. To use the Excel worksheet functions, you must use Application.WorksheetFunction. Example:

'Uses Excel worksheet function.
MsgBox Application.WorksheetFunction.Log(86)
 
'Uses VB Log function.
MsgBox Log(86)

[Philipj]

Thanks for the assist. I had not found the application method.

[RAEsquivelC]

On an Excel spreadsheet, I entered:

=LOG(10) and got 1
=LOG(100) and got 2
=LN(10) and got 2.302585

So, both base 10 and natural logarithms are available in my Excel 97.

[RAEsquivelC]

I have no idea how my name got on the previous reply, which was made PRIOR to my intent, by some other person! I thought I had posted something like:

To get the base 10 logarithm of a number, since it is equal to the natural logarithm of the number, divided by the natural logarithmod 10, use this, for y = log10(x):

y = ln(x)/ln(10) which, in BASIC, QuickBASIC, VB and VBA is:

y = log(x)/log(10)