LN function
This topic describes the formula syntax and usage of the LN function in the Data Quality Execute Formula transform.
Description
Returns the natural logarithm of a number. Natural logarithms are based on the constant e (2.71828182845904).
Syntax
LN(number)The LN function syntax has the following argument:
numberRequired. The positive real number for the natural logarithm.
Notes
- LN is the inverse of the EXP function.
- The argument
number ≤ 0returns the #NUM! error value 6. The natural logarithm is only defined for positive values.
Example
Formula:
LN([Value])| Value | Description | Result |
|---|---|---|
86 |
Natural logarithm of 86. | 4.4543473 |
2.7182818 |
Natural logarithm of e. | 1 |
20.0855369231877 |
Natural logarithm of 20.0855369231877 (e raised to the power of 3). | 3 |