# LN Function in Excel

How to Use the LN Function in Microsoft Excel

### Part 1: Introduce

๐ Definition
The LN function in Microsoft Excel returns the natural logarithm of a number. Natural logarithms are based on the constant e (approximately equal to 2.71828182845904).

๐ Purpose
The Purpose of the LN function is to compute the natural logarithm of a given positive real number.

๐ Syntax & Arguments

syntax
`LN(number) `
• Number (Required): The positive actual number for which you want the natural logarithm.

๐ Explain the Arguments in the function

• Number: This is the positive actual number whose natural logarithm you wish to determine.

๐ Return value
The LN function returns the natural logarithm of the specified number.

๐ Remarks
The LN function is the inverse of the EXP function in Excel.

### Part 2: Examples

Example 1: Finding the Natural Logarithm of a Business Revenue

• Purpose of illustration: To determine the natural logarithm of a company’s monthly revenue.
• Data sheet and formulas:
ABC
1Monthly Revenue (\$)FormulaResult
250000`=LN(A2)`10.819778
• Explanation: The natural logarithm of the monthly revenue (\$50,000) is approximately 10.82.

Example 2: Calculating the Natural Logarithm of Product Sales

• Purpose of illustration: To compute the natural logarithm of the number of products sold.
• Data sheet and formulas:
ABC
1Products SoldFormulaResult
21500`=LN(A2)`7.313220
• Explanation: The natural logarithm of the number of products sold (1,500) is approximately 7.31.

Example 3: Natural Logarithm of Client Sign-ups

• Purpose of example: To determine the natural logarithm of client sign-ups in a month.
• Data sheet and formulas:
ABC
1Client Sign-upsFormulaResult
2300`=LN(A2)`5.703782
• Explanation: The natural logarithm of the number of client sign-ups (300) is approximately 5.70.

Example 4: Natural Logarithm of Website Visits

• Purpose of example: To compute the natural logarithm of the number of website visits.
• Data sheet and formulas:
ABC
1Website VisitsFormulaResult
210000`=LN(A2)`9.210340
• Explanation: The natural logarithm of the number of website visits (10,000) is approximately 9.21.

Example 5: Natural Logarithm of Social Media Followers

• Purpose of illustration: To determine the natural logarithm of the number of social media followers.
• Data sheet and formulas:
ABC
1FollowersFormulaResult
25000`=LN(A2)`8.517193
• Explanation: The natural logarithm of social media followers (5,000) is approximately 8.52.

Example 6: Using LN with IF for Website Visits

• Purpose of example: To compute the natural logarithm of website visits only if they exceed a certain threshold.
• Data sheet and formulas:
ABCD
1ThresholdWebsite VisitsFormulaResult
250006000`=IF(B2>A2, LN(B2), "Below Threshold")`8.699514
• Explanation: The formula checks if the website visits (6,000) exceed the threshold (5,000). Since it does, it returns the natural logarithm of the holidays, approximately 8.70.

Example 7: Using LN with SUM for Monthly Sales

• Purpose of example: To compute the natural logarithm of the sum of monthly sales.
• Data sheet and formulas:
ABCD
1Jan SalesFeb SalesFormulaResult
230004000`=LN(SUM(A2:B2))`8.517193
• Explanation: The formula sums up the sales of January and February (total 7,000) and then computes its natural logarithm of approximately 8.52.

Example 8: Using LN with VLOOKUP for Product Prices

• Purpose of example: To find the natural logarithm of the price of a specific product using VLOOKUP.
• Data sheet and formulas:
ABCD
1ProductPriceFormulaResult
2Apple1.2`=LN(VLOOKUP("Apple", A2:B2, 2, FALSE))`0.182322
• Explanation: The formula looks up the price of “Apple” and then computes its natural logarithm, approximately 0.18.

Example 9: Using LN with AVERAGE for Weekly Hours Worked

• Purpose of illustration: To compute the natural logarithm of the average hours worked in a week.
• Data sheet and formulas:
ABCD
1Mon HoursTue HoursFormulaResult
289`=LN(AVERAGE(A2:B2))`2.197225
• Explanation: The formula averages the hours worked on Monday and Tuesday (8.5 hours) and then computes its natural logarithm, approximately 2.20.

Example 10: Using LN with MAX for Monthly Temperatures

• Purpose of example: To compute the natural logarithm of the highest temperature in a month.
• Data sheet and formulas:
ABCD
11st Week Temp2nd Week TempFormulaResult
22528`=LN(MAX(A2:B2))`3.332205
• Explanation: The formula finds the maximum temperature between the two weeks (28ยฐC) and computes its natural logarithm of approximately 3.33.

Example 11: Using LN with MIN for Monthly Discounts

• Purpose of example: To compute the natural logarithm of the minor monthly Discount offered.
• Data sheet and formulas:
ABCD
11st Discount2nd DiscountFormulaResult
21510`=LN(MIN(A2:B2))`2.302585
• Explanation: The formula finds the minimum Discount between the two offers (10%) and computes its natural logarithm of approximately 2.30.

Example 12: Using LN with COUNT for Number of Transactions

• Purpose of example: To compute the natural logarithm of the number of daily transactions.
• Data sheet and formulas:
ABCD
1Transaction 1Transaction 2FormulaResult
2120150`=LN(COUNT(A2:B2))`0.693147
• Explanation: The formula counts the number of transactions (2) and computes its natural logarithm, approximately 0.69.

### Part 3: Tips and tricks

1. ๐ Remember that the LN function requires a positive actual number as its argument.
2. ๐ The LN function can benefit financial and scientific calculations requiring natural logarithms.
3. ๐ If you’re looking to compute the logarithm with a base other than ‘e’, consider using the LOG function in Excel.
4. ๐ Always ensure that the number provided to the LN function is positive to avoid errors.