This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. Natural logarithm number works exactly the opposite of exponential function. In order to make LN work, we need to give a number that is greater than zero. Any number that is greater than zero it will give the natural logarithm number. The value we need to give to the LN function starts with anything greater than zero. We cannot supply any operators, symbols, etc. You cannot supply anything other than a rational number to LN function. Similar to the negative number LN function requires the number to be greater than zero, otherwise, we will get number error. If you supply the number zero to this function, it will throw the error, as NUM. You cannot supply number zero too to the LN function. Any number that is equal to or less than zero LN function cannot return the value against it. If you supply the negative number to this function, it will throw the error as NUM.

You cannot supply any negative numbers to the LN function. In this article, I will brief you about how this works and error types one by one. There is no day-to-day example to explain the LN function in Excel with live examples. LN function in Excel is very simple and easy to use. Therefore, the exponential number of number 1 is 2.

Returns the inverse matrix, MINVERSE Functionīelow example illustrates the same. We need to multiply the number 5 three times to get the number Therefore, the logarithm is 3. We can also choose any exponential or raise to power value in the syntax. LN value of 1 is 0 and the LN value of e is 1, so for each value coming after these will be having the LN value more than 0 if any number is used.

Where LN denotes the logarithm statement and as per the syntax we just need to put any number who logarithm value we need to find. LN function in excel is the mathematical trigonometry function that is used for calculating the natural logarithm of a number.

Inverse of log10 in excel