LN
Description
LN
is a row function that returns the natural logarithm of a number. The natural logarithm is the logarithm to the base e
, where e
(Euler's number) is a mathematical constant approximately equal to 2.718281828. The natural logarithm of a number x
is the power to which the constant e
must be raised in order to equal x
.Syntax
LN
(positive_number
)Return Value
Returns the exponent to which base
e
must be raised to obtain the input value, where e
denotes the constant number 2.718281828. Returns one value per row of type DOUBLE
. For example,
LN(7.389)
is 2, because e
to the power of 2 is approximately 7.389. Input Parameters
- positive_number
- Required. A field or expression that returns a number greater than 0. Inputs can be of typeINTEGER,LONG,DOUBLE.
Examples
Return the natural logarithm of base number
e
, which is approximately 2.718281828
:LN(2.718281828) returns
1
LN(3.0000) returns
1.098612
LN(300.0000) returns
5.703782