EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Maths Function in Excel LN Excel Function
Secondary Sidebar
Excel Functions
  • Maths Function in Excel
    • Calculating Investment Return In Excel
    • Sumif Function Examples
    • MROUND in Excel
    • SUM Cells in Excel
    • MMULT in Excel
    • MINVERSE in Excel
    • Trunc in Excel
    • SUMIF with Text
    • COS Function in Excel
    • RANDBETWEEN in Excel
    • Excel SUMIF with OR
    • Excel DEGREES Function
    • Calculations in Excel
    • Sumif Between Two Dates
    • Calculate Income Tax in Excel
    • PRODUCT Function in Excel
    • How to Sum Multiple Rows in Excel
    • Matrix in Excel
    • ROUND Formula in Excel
    • How to SUM in Excel
    • SUMPRODUCT Formula in Excel
    • Excel Running Total
    • Excel Rounding
    • Excel Exponents
    • Excel SIN Function
    • Excel Square Root Function
    • Excel ROUNDUP Function
    • ROUND Excel Function
    • Excel ROUNDDOWN Function
    • ODD Excel Function
    • SUMPRODUCT Function in Excel
    • AGGREGATE Function in Excel
    • ABS Function in Excel
    • Excel TAN Function
    • COMBIN Function in Excel
    • CEILING Function in Excel
    • INT Excel Function
    • SUBTOTAL Function in Excel
    • LN Function in Excel
    • Excel RAND Function
    • TANH Function in Excel
    • SUMIF Function in Excel
    • SUM Function in Excel
    • POWER Function in Excel
    • EVEN Function in Excel
    • LOG Function in Excel
    • FLOOR Excel Function
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • Online EXCEL ADVANCED Certification
  • Excel for HR Training

LN Excel Function

By Jeevan A YJeevan A Y

LN Function in Excel

LN Function in Excel (Table of Contents)

  • LN in Excel
  • LN Formula in Excel
  • How to use LN Function in Excel?

LN in Excel

LN function in excel is the mathematical trigonometry function used to calculate the natural logarithm of a number. Where LN denotes the logarithm statement, and as per the syntax, we just need to put any number of who logarithm value we need to find. LN value of 1 is 0, and the LN value of e is 1, so each value coming after these will have an LN value more than 0 if any number is used. We can also choose any exponential or raise to power value in the syntax.

In simple terms, logarithm means, “How many of one number do we multiply to get another number?”

Example: How many 5s we need to multiply to get 125?

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

Answer: 5 * 5 * 5 = 125. We need to multiply the number 5 three times to get the number 125. Therefore, the logarithm is 3.

In a mathematical way, we can write it as the below one.

Log5 (125) =3

LN Formula

The logarithm of 125 with a base number of 5 is 3.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,813 ratings)

A relationship between Logarithms & Exponents

LN Formula excel

Here exponent says how many times you need to multiply the base value.

Now, the logarithm equation becomes as the below.

5? =625

Therefore logarithm answers the question, “What exponent do we need for one number to become another”.

It is a built-in function in excel that returns the natural logarithm of a given number.

Natural Logarithm: Base “e.”

e is an Euler’s Number that is equal to 2.718282. This is called a “natural logarithm”.

LN Formula in Excel

Below is the LN Formula in Excel.

LN Formula in Excel

Explanation of LN Function in Excel:

The LN function in excel has one argument, i.e. number.

  • Number: The number that you give to get the natural logarithm number.

The natural logarithm of a number is the opposite of the EXPONENTIAL function. The below example illustrates the same.

Therefore, the exponential number of number 1 is 2.718282, and the natural logarithm number of 2.718282 is 1.

How to Use LN Function in Excel?

LN function in Excel is very simple and easy to use. Let understand the working of LN function in Excel by some LN Formula example.

You can download this LN Function Excel Template here – LN Function Excel Template

There is no day-to-day example to explain the LN function in Excel with live examples. In this article, I will brief you about how this works and error types one by one.

Example #1

You cannot supply any negative numbers to the LN function. If you supply the negative number to this function, it will throw the error as #NUM. Any number that is equal to or less than the zero LN function cannot return the value against it.

Example1-1

By applying the formula in cell C2.

LN Example1-2

So the result will be:

LN Example1-3

Similarly, it is applied to other cells in that column to get the desired output.

LN Example1-4

Example #2

You cannot supply number zero too to the LN function. If you supply the number zero to this function, it will throw the error as #NUM. Similar to the negative number LN function requires the number to be greater than zero; otherwise, we will get a number error.

 Example 2-1

By applying the formula in cell C2.

LN Example 2-2

So the result will be:

LN Example 2-3

Similarly, it is applied to other cells in that column to get the desired output.

LN Example 2-4

Example #3

You cannot supply anything other than a rational number to the LN function. If given so, it will give the error as #VALUE! We cannot supply any operators, symbols, etc. Anything other than a positive number, it will give the error as #VALUE!

Example 3-1

By applying the formula in cell C2.

LN Example 3-2

So the result will be:

LN Example 3-3

Similarly, it is applied to other cells in that column to get the desired output.

Value Error Example 3-4

Example #4

The value we need to give to the LN function starts with anything greater than zero. Any number that is greater than zero it will give the natural logarithm number. In order to make LN work, we need to give a number that is greater than zero.

Example 4-1

By applying the formula in cell C2.

LN Example 4-2

So the result will be:

LN Example 4-3

Similarly, it is applied to other cells in that column to get the desired output.

LN Example 4-4

Example #5

Natural logarithm number works exactly the opposite of exponential function. This function is the inverse of the EXP function in excel where =EXP (1) is equal to 2.718282 and =LN (2.718282) is equal to 1.

Example 5-1

By applying the formula

LN Example 5-2

The output will be :

LN Example 5-3

Things to Remember

  • LN requires only positive numbers. The supplied number cannot be zero or negative.
  • To get to know how LN works first, you need to learn the basics of logarithms and refer to logbooks.
  • The supplied values should be a positive number and cannot supply any of the operators and symbol values. So it cannot be a non-numeric value.
  • The natural logarithm is related to the EXP function. In EXP, we get the value if a base number is raised to an exponential number, and in logarithm, we need to know the exponential number to get the desired number.

Recommended Articles

This has been a guide to LN in Excel. Here we discuss the LN Formula in Excel and How to use the LN Function in Excel, along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. XIRR in Excel
  2. NOT Function in Excel
  3. IPMT in Excel
  4. Transposein in Excel
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel for HR Training (8 Courses, 10+ Projects)4.9
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download LN Function Excel Template

EDUCBA

Download LN Function Excel Template

EDUCBA

डाउनलोड LN Function Excel Template

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. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more