EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Maths Function in Excel LOG 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

LOG Excel Function

By Pradeep SPradeep S

LOG Function in Excel

LOG Function in Excel (Table of Contents)

  • LOG in Excel
  • LOG Formula in Excel
  • How to use the LOG Function in Excel?

LOG in Excel

The LOG function is a worksheet function categorized under the Math/Trigonometry function.

As per Mathematics, the logarithm is defined as an inverse function to exponentiation or logarithm of a positive real number x with respect to base b. i.e. bx=y

E.G. log2 16 = 4, since 24 = 2 ×2 × 2 × 2 = 16

Start Your Free Excel Course

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

Here, the logarithm (with respect to base 2) of 16 is 4.

The LOG function in Excel is easy to use & very simple; it is the most widely used function in statistics, finance & business analytics, or domains.

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,725 ratings)

The LOG function is also used to plot a graph for data representation & it is used with other tools for regression analysis.

The LOG function performs the inverse operation to that of a POWER function.

LOG function in excel calculates the logarithm of a given number to a supplied base or returns the natural logarithm of a number.

E.G. 1000 = 10 × 10 × 10 = 103, the “logarithm to base 10” of 1000 is 3, i.e. logarithm counts repeated multiplication of the same factor. The logarithm of a given number x is the exponent to a fixed number, the base b, must be raised, produce that number x.

i.e. If ax = b Then Loga(b) = x.

LOG Formula in Excel

Below is the LOG Formula in Excel :

LOG Formula in Excel 1

or 

LOG Formula in Excel 2

Explanation of LOG Function in Excel

LOG formula in Excel consists of two things Number & Base.

  • Number = It is a positive real number that you want to calculate the logarithm in excel.

Note: It should be a numeric value that must always be greater than zero.

  • Base = It is a base to which the logarithm should be calculated, or It is an optional argument that specifies or indicates the base to which the logarithm should be calculated.

Note: If no base is listed, the base is assumed to be 10.

How to Use the LOG Function in Excel?

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

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

Example #1 – With Base Argument

In the below-mentioned example, let’s calculate the logarithm in excel of 47, with a base value of 10.

Follow these steps to calculate the LOG in Excel:

  • Select the output cell where we need to find out log value, i.e. D8 in this example.

Example 1-1

  • Click the function button (fx) under the formula toolbar; a popup will appear; double-click on the LOG function under the select function.

LOG Example 1-2

  • A dialog box appears where arguments (Number & Base) for log function needs to be filled.

LOG Example 1-3

  • Here the number is 47 & the base argument is 10.

LOG Example 1-4

  • Excel calculates the logarithm value and displays the answer 1.6720979 in the output cell.

LOG Example 1-5

Example #2 – Without Base Argument

In the below-mentioned example, let’s calculate the logarithm of 100, without base value.

Follow these steps to calculate the LOG in Excel:

  • Select the output cell where we need to find out log value, i.e. D13 in this example.

Example 2-1

  • Click the function button (fx) under the formula toolbar; a popup will appear; double-click on the LOG function under the select function.

LOG Example 2-2

  • A dialog box appears where arguments (Number & Base) for log function needs to be filled.

LOG Example 2-3

  • Here the number is 100 & In this log function example, the Log function by default takes the base value as 10 if the second argument (Base) is not passed in the log function.

LOG Example 2-4

  • Excel calculates the logarithm value and displays the answer 2 in the output cell. i.e. 100 = 10 × 10 = 102, the “logarithm to base 10” of 100 is 2 i.e. logarithm counts repeated multiplication of the same factor. Therefore, it returns the output value or a result as 2.

LOG Example 2-5

Example #3 – With Decimal Value As Base Argument

In the below-mentioned example, let’s calculate the logarithm of 6, with the decimal value 0.5 as the base argument.

Follow these steps to calculate the LOG in Excel:

  • Select the output cell where we need to find out log value, i.e. D17 in this example.

Example 3-1

  • Click the function button (fx) under the formula toolbar; a popup will appear; double-click on the LOG function under the select function.

LOG Example 3-2

  • A dialog box appears where arguments (Number & Base) for log function needs to be filled.

LOG Example 3-3

  • Here the number is 6 & the base argument is 0.5.

LOG Example 3-4

  • Excel calculates the logarithm value and displays the answer -2.584963 in the output cell. i.e. 0.5-2 = 6; Therefore, Log0.5(6) = -2.584963

LOG Example 3-5

Example #4 – When Base Argument is Negative Value or Zero

In the below-mentioned example, let’s calculate the logarithm in excel of 47, with base argument “0” ZERO or Negative value (-10).

Follow these steps to calculate the LOG in Excel:

  • Select the output cell where we need to find out log value, i.e. K8 in this example.

Example 4-1

  • Click the function button (fx) under the formula toolbar; a popup will appear; double-click on the LOG function under the select function.

LOG Example 4-2

  • A dialog box appears where arguments (Number & Base) for log function needs to be filled.

LOG Example 4-3

  • Here the number is 47 & the base argument is -1.

LOG Example 4-4

or 0.

LOG Example 4-5

  • Let’s calculate the logarithm in excel value and display the answer #NUM! error in the output cell.

NUM Error Example 4-6

Example #5 – When Base Argument is Non-Numeric Or Text Value

In the below-mentioned example, let’s calculate the logarithm of 47, where the base argument is a text string, i.e. “EXCEL”.

Follow these steps to calculate the LOG in Excel:

  • Select the output cell where we need to find out log value, i.e. K16 in this example.

Example 5-1

  • Click the function button (fx) under the formula toolbar; a popup will appear; double-click on the LOG function under the select function.

LOG Example 5-2

  • A dialog box appears where arguments (Number & Base) for log function needs to be filled.

LOG Example 5-3

  • Here the number is 47 & the base argument is TEXT string, i.e. EXCEL.

LOG Example 5-4

  • Excel calculates the logarithm value and displays the answer #VALUE! error in the output cell.

VALUE Error Example 5-5

Things to remember about the LOG Function in Excel

  • Number argument in LOG Function: It should always be a positive real number that you want to calculate the logarithm in excel.
  • It should be a numeric value & must always be greater than zero.
  • If no base is listed in a Base argument, the base is always assumed to be 10.

LOG Function Errors

If there is an error from the Log function, it is due to one of the following:

Common Errors

 1) #VALUE! – It Occurs due to or if supplied number argument, or the supplied [base] argument is non-numeric.

VALUE Error Example 5-5

2) #NUM! – It Occurs due to or if the supplied number argument or the supplied [base] argument is the negative value or zero.

LOG Example 6-2

The output will be :

NUM Error Example 4-6

3) #DIV/0! – It Occurs if the supplied [base] argument is equal to 1.

LOG Example 6-3.1

The output will be :

LOG Example 6-3.2

Recommended Articles

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

  1. XIRR in Excel
  2. Write Formula in Excel
  3. OR Excel Function
  4. FIND Function 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
4 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 LOG Function Excel Template

EDUCBA

Download LOG Function Excel Template

EDUCBA

डाउनलोड LOG 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