# 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])

**Numbe**r: 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.

*OK.*

*A ***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.

A **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.*

*A ***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**10* from the drop-down menu.

A **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.