How To Do Negative Log On Calculator
For diverse numeric calculations, we need to find the natural logarithm of numbers. In this article, I volition show you 4 applied examples to calculate natural logarithm in Excel.
Download Practice Workbook
Hither, you tin can download and practice from our practice workbook for costless.
What Is Natural Logarithm?
A natural logarithm is the logarithm of a number to the base of operations of eastward. eastward is a abiding number which is approximately 2.7128. It is a transcendental and irrational number. It is usually expressed as lnx or log eastward 10. Keep in mind, that you tin observe a natural logarithm of positive numbers only.
Introduction to the LN Function
The LN function is an Excel role that returns the natural logarithm of a number in Excel. It has mainly one statement only. That is- number. And so, if you put a number within the LN function, it would give you the natural logarithm of that number. Simply, remember, do not put zero or negative numbers in the argument. This will show you the #NUM! error. Moreover, do not put a not-numeric value in the statement of the function. It will show the #VALUE! error.
Read More: How to Calculate Log in Excel (six Effective Methods)
4 Useful Examples to Calculate Natural Logarithm in Excel
Here, we have 4 types of numbers in our dataset. Each type is tried and explained in an individual sheet.
Go through the 4 useful applications of calculating the natural logarithm in Excel beneath. 👇
1. Calculate Natural Logarithm of a Positive Integer Number
If you want to calculate the natural logarithm of a positive integer number in Excel, go through the steps below. 👇
📌 Steps:
- First, click on the cell where you desire to put the natural logarithm event.
- After, put an equal sign (=) and write LN. As a event, the LN role will be active. Now, refer to the B5 cell as you want to notice the natural logarithm of this cell. So, the formula volition wait similar this.
- Next, place your cursor at the lesser right corner of the result cell. Now, drag the fill up handle below to copy the formula to all the cells below.
Thus, you tin can detect the natural logarithm of all the positive integers. And, the effect looks like this. 👇
Read More: How to Log Transform Data in Excel (4 Easy Methods)
two. Calculate Natural Logarithm of a Partial Number
Besides, you tin can also find the natural logarithm of fraction numbers. Go through the steps below to accomplish this. 👇
📌 Steps:
- Kickoff, click on the cell where you want to put the natural logarithm result.
- Afterward, put an equal sign (=) and write LN. As a event, the LN role will be active. Now, refer to the B5 cell as y'all desire to find the natural logarithm of this prison cell. And then, the formula will wait like this.
- Next, place your cursor at the lesser right corner of the outcome prison cell. Now, elevate the fill handle beneath to copy the formula to all the cells beneath.
Thus, yous can discover the natural logarithm of all the fraction numbers. And, the consequence looks like this. 👇
Read More: How to Calculate Antilog in Excel (With iii Examples)
3. Summate Natural Logarithm of a Negative Number
Now, you tin not find a natural logarithm of a negative number. This will show you the #NUM! Mistake. Follow the steps below to exam this. 👇
📌 Steps:
- First, click on the prison cell where you lot want to put the natural logarithm outcome.
- Subsequently, put an equal sign (=) and write LN. As a result, the LN function will be active. Now, refer to the B5 cell equally you lot desire to observe the natural logarithm of this cell.
- Next, place your cursor at the bottom right corner of the result cell. At present, drag the fill handle below to re-create the formula to all the cells below.
Thus, you tin can meet the natural logarithm of all the negative numbers. And, the event looks like this. 👇
Read More: How to Practice Inverse Log in Excel (3 Simple Methods)
4. Summate Natural Logarithm of Zero
Just like the negative number, you tin can not find the natural logarithm of zeros besides. This will also evidence you the #NUM! error. Follow the steps below to examination this. 👇
📌 Steps:
- First, click on the cell where you lot desire to put the natural logarithm result.
- Afterward, put an equal sign (=) and write LN. As a effect, the LN part will be active. Now, refer to the B5 cell as you want to find the natural logarithm of this cell.
- Next, place your cursor at the bottom right corner of the event cell. Now, drag the fill handle below to copy the formula to all the cells below.
Thus, you can see the natural logarithm of zeros. And, the result looks like this. 👇
Read More than: How to Make a Mileage Log in Excel (ii Handy Methods)
Quick Notes
- LN part is the inverse of the EXP function.
- The LN part returns you the natural logarithm of a number. Similarly, the LOG function returns a logarithm of a number to any base. Moreover, the LOG10 function returns the logarithm of a number to the base of operations 10.
Conclusion
Then, in this article, I accept shown you iv ideal examples to calculate natural logarithm in Excel. Follow these examples to reach your desired result. I promise you discover this commodity helpful and informative. If you lot take whatever further queries or recommendations, please feel free to contact me. And, visit ExcelDemy for many more than articles like this. Thank you!
Related Articles
- Plot Log Scale in Excel (2 Piece of cake Methods)
- How to Plot Log Log Graph in Excel (ii Suitable Examples)
- Excel Logarithmic Scale Start at 0 (A Detailed Analysis)
- How to Calculate Logarithmic Growth in Excel (ii Easy Methods)
Source: https://www.exceldemy.com/calculate-natural-logarithm-in-excel/
0 Response to "How To Do Negative Log On Calculator"
Post a Comment