Description
Log returns a Number specifying the natural logarithm of a given number.
Action
Log returns a Number specifying the natural logarithm of a given number. The natural logarithm is the logarithm to the base e, where e is approximately 2.718282.
Example
Log (1.5)
Returns 0.4055 (rounded to 4 decimals).
Comments
This function can calculate a log with any base when you employ this logic:
LogAnyBase (x,base) = log(x)/log(base)
(x represents the number for which you want to calculate the log; base represents the base you want to use.)
For example, for log base 10, you would enter this formula text:
log(x)/log(10)