I need to perform a complex calculation within RevG using logarithms. I performed the calculation in Excel and am now trying to emulate within RevG. The problem is that logarithms within RevG give different results to Excel. I note that the RevG manual refers to them as natural logs and this I believe differs from 'normal' logs. For example, LN(3000)=8.0064 whereas LOG of 3000 in Excel=3.477121255. I need to emulate the latter. Is there another function which I can use, or any way of manipulating a natural log to meet my requirements.
] LN(3000)=8.0064 whereas LOG of 3000 in Excel=3.477121255. <
If I remember my trigonometry you can simply divide the natural log by 2.303. To get more precise use 2.3025851 which is the ln of 10 on my calculator (punch in 10 on your calculator and hit the 'LN' key).
Hope this helps
Lauren Floyd
A natural log (ln) is a special kind of log function.
x=a^y then y=log(a)X for a log
x=e^y then y=log(e)X for a ln (where e ~ 2.71828…)
So if you ever want to convert from one to another:
log(X)=M*ln(X), where M=.4342944819so for your example… ln(X)=8.0064, M=.4342…, X=3000
log(3000)=(.4342944819)(8.0064)=3.47712