How to Use the LOG Function in Excel: Usabilities, Examples, and Writing Steps - Compute Expert

How to Use the LOG Function in Excel: Usabilities, Examples, and Writing Steps


Home >> Excel Tutorials from Compute Expert >> Excel Formulas List >> How to Use the LOG Function in Excel: Usabilities, Examples, and Writing Steps





In this tutorial, you will learn how to use the LOG function in excel completely.

When working with numbers in excel, we might sometimes need to calculate the logarithm of our number using a certain base. If we know how to use the LOG function in excel, then we can get our number logarithm easily.

Want to know more about LOG and master the way to use this function in excel? Read this tutorial until its last part!

Disclaimer: This post may contain affiliate links from which we earn commission from qualifying purchases/actions at no additional cost for you. Learn more







What is the LOG Function in Excel?

LOG is an excel function that helps you to calculate the logarithm of a number in excel fast and easily.



LOG Usability

You can use LOG to get the logarithm of a number.



LOG Result

The LOG result is a number that represents the logarithm of a number you input into it.



Excel Version from Which We Can Start Using LOG

We can start using LOG in excel since excel 2003.



The Way to Write It and Its Input

Here is the general writing form of LOG in excel.

= LOG ( number , [ base ] )


And here is a bit explanation of the inputs you need to give when you use LOG in excel.
  • number = the number you want to find the logarithm of
  • [base] = optional. The base for your logarithm calculation. If you omit this, then LOG will calculate the logarithm of your number on the base of 10





Example of Its Usage and Input

Here is a usage and result example of LOG in excel.

How to Use the LOG Function in Excel: Usabilities, Examples, and Writing Steps - Screenshot of the LOG Implementation Example

In the example, you can see how LOG can help us to get the logarithm of our number. Just input the number we want to get the logarithm of and the logarithm base if needed and press Enter. You will immediately get your logarithm result by doing that!



Writing Steps

Need guidance when you write your LOG formula in excel? Our LOG writing steps below are ready to help you with that!

  1. Type an equal sign ( = ) in the cell where you want to put the logarithm of your number

    How to Use the LOG Function in Excel: Usabilities, Examples, and Writing Steps - Screenshot of Step 1

  2. Type LOG (can be with large and small letters) and an open bracket sign after =

    How to Use the LOG Function in Excel: Usabilities, Examples, and Writing Steps - Screenshot of Step 2

  3. Input the number you want to get the logarithm of

    How to Use the LOG Function in Excel: Usabilities, Examples, and Writing Steps - Screenshot of Step 3

  4. Optional: Type a comma sign. Then, input the base you want for your logarithm calculation. If you don’t give any base input here, LOG will calculate the logarithm of your number on the base of 10

    How to Use the LOG Function in Excel: Usabilities, Examples, and Writing Steps - Screenshot of Step 4

  5. Type a close bracket sign

    How to Use the LOG Function in Excel: Usabilities, Examples, and Writing Steps - Screenshot of Step 5

  6. Press Enter
  7. Done!

    How to Use the LOG Function in Excel: Usabilities, Examples, and Writing Steps - Screenshot of Step 7






Exercise

After you have learned how to use LOG in excel, now let’s practice your understanding!

Download the exercise file below and answer all the questions! Download the answer key file if you have done the exercise and want to check your answers!

Link to the exercise file:
Download here

Instructions

Use LOG to answer all the questions below! Give your answer for each question in the appropriate gray-colored cell!
  1. Find the logarithm of the number in the no.1 row with the logarithm base of 10!
  2. Find the logarithm of the number in the no.2 row with the logarithm base of 2.5!
  3. Find the natural logarithm of the number in the no.3 row! (Hint: the natural logarithm is a logarithm with the base of an e constant or Euler’s number. You can use the EXP(1) formula writing to get that number for you in excel!)

Link to the answer key file:
Download here



Additional Note

You can only input a positive number to LOG. Other kinds of input will make LOG gives you an error.



Related tutorials you should learn:



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!





Learn Excel Dashboard Course

Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!




Follow our tutorial content also on


Excel Calculation

Sum in Excel

Subtraction in Excel

Multiplication in Excel

Division in Excel

Average in Excel



Excel Formula

VLOOKUP Function in Excel

IF Function in Excel

SUM Function in Excel

COUNTIFS Function in Excel

SUMIFS Function in Excel



Excel Tips and Trick

How to Print in Excel

Convert Number to Text in Excel

Excel Worksheet Definition

Excel Range Definition

Excel Shortcuts



Excel Products & Services Recommendation

Best Laptops for Excel

Best Tablets for Excel

Best Keyboards for Excel

Best Mouse for Excel

Best Monitors for Excel



Excel Consultation

Recommended Work Tools

About Us

Contact Us

Privacy Policy

Affiliate Disclosure

Terms & Condition



© 2022 Compute Expert