PC & Mobile

How to use the LOG and LOG10 functions in Excel

In Microsoft Excel, a operate is a predefined method that makes calculations utilizing particular values known as arguments in a selected order or Structure. In this tutorial, we are going to clarify how to use the LOG and LOG10 Functions in Excel. The LOG and the LOG10 functions are each Math and Trigonometry functions. The LOG operate returns the logarithm of a quantity to the base you specify, and the LOG10 returns the base -10 logarithm of a quantity.

Below are the formulation and syntax of each the LOG and LOG10 functions.

LOG

LOG (quantity, [base])

Number: The optimistic actual quantity for which you need the logarithm. It is required.

Base: The base of the logarithm. Optional.

LOG10

LOG10 (quantity)

Number:  The optimistic actual quantity for which you need the base-10 logarithm.

How to use the LOG operate in Excel

  • Launch Microsoft Excel.
  • Enter your knowledge or use present knowledge.
  • Type into the cell the place you need to place the consequence =LOG (A4, B4).
  • Press Enter to see the consequence. The result’s 6.
  • Now drag the fill deal with down to see the different consequence.
  • There are two different strategies to use the LOG operate.

Method one is to click on the fx button on the prime left of the Excel worksheet.

An Insert Function dialog field will seem.

Inside the dialog field, in the part Select a Category, choose Math and Trigonometry from the listing field.

In the part Select a Function, select the LOG operate from the listing.

Then click on OK.

Function Arguments dialog field will open.           

Type into the entry bins the cell that accommodates the quantity you need to calculate.

Then click on OK.

Method two is to click on the Formulas tab and click on the Math and Trigonometry button in the Function Library group.

Then choose LOG from the drop-down menu.

Function Arguments dialog field will open.

Follow the identical technique in Method 1.

Then click on OK.

How to use the LOG10 functions in Excel

  • Enter your knowledge or use present knowledge.
  • Type into the cell the place you need to place the consequence =LOG10(A4).
  • Press Enter to see the consequence. The result’s 1.653213.
  • Now drag the fill deal with down to see the different consequence.
  • There are two different strategies to use the LOG10 operate.
  • Method one is to click on the fx button on the prime left of the Excel worksheet.
  • An Insert Function dialog field will seem.

Inside the dialog field, in the part Select a Category, choose Math and Trigonometry from the listing field.

In the part Select a Function, select the LOG10 operate from the listing.

Then click on OK.

Function Arguments dialog field will open.           

Type into the entry bins the cell that accommodates the quantity you need to calculate.

Then click on OK.

Method two is to click on the Formulas tab and click on the Math and Trigonometry button in the Function Library group.

Then choose LOG10 from the drop-down menu.

Function Arguments dialog field will open.

Follow the identical technique in Method 1.

Then click on OK.

We hope you perceive how to use the LOG and LOG10 functions in Microsoft Excel.

What are the 3 varieties of logarithms?

The important varieties of logarithms are frequent logarithms, the place the base is 10; binary logarithms, the place the base is 2, and pure logarithms, the place the base is e. Logarithms in arithmetic are inverse functions to exponentiation.

What is the distinction between LOG and LOG10 in Excel?

The distinction between the LOG and LOG10 functions in Microsoft Excel is that LOG returns the logarithm of a quantity to the base you specify, and LOG10 returns the base -10 logarithm of a quantity.

What is the distinction between log and LN in Excel?

The distinction between the LOG and LN functions in Excel is that LOG returns the logarithm of a quantity to the base you specify, whereas the LN operate returns the pure logarithm of a quantity.

READ: How to use the MINVERSE and MMULT functions in Excel

How do you log a column in Excel?

In Microsoft Excel, to return the logarithm of a quantity, it is best to use the LOG operate. The Log operate is a Math and trigonometry operate in Excel. In this tutorial, now we have defined how to use the Log operate in Microsoft Excel.

READ: Top 15 Financial functions in Microsoft Excel.

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button