log function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I need to calculate a log of a number in Access,
easy enough in excel but I'm getting a different answer in access,

my [tvc] number is 60
in excel the log is showing as 1.778* =log(60)
but in access log([tvc]) is giving me 4.09.

help please.
 
The access Log function returns the natural log; Unless you specify
otherwise, Excel Log function returns the log base 10. If you want the
natural log in Excel use the LN function.

To get the base 10 log in Access, you need a formula such as the following.
Natural Log of your number divided by the Natural Log of the base

Log(60)/Log(10) --> 1.77815125038364
 
thanks very much.

John Spencer said:
The access Log function returns the natural log; Unless you specify
otherwise, Excel Log function returns the log base 10. If you want the
natural log in Excel use the LN function.

To get the base 10 log in Access, you need a formula such as the following.
Natural Log of your number divided by the Natural Log of the base

Log(60)/Log(10) --> 1.77815125038364



robbie said:
Hi
I need to calculate a log of a number in Access,
easy enough in excel but I'm getting a different answer in access,

my [tvc] number is 60
in excel the log is showing as 1.778* =log(60)
but in access log([tvc]) is giving me 4.09.

help please.
Click to expand...
Click to expand...
 
Back
Top