Logarithms are the inverse of the exponential function. It is a mathematical expression used to find the power a base must raise to yield a given number. LOG in Excel is categorized as a Math/Trigonometry function. Generally, the Excel LOG10 function calculates the base 10 logarithms of a given number.

Let’s see the **Excel LOG10 Function** with its basic syntax, description, and examples. Get an official version of** MS Excel** from the following link:

https://www.microsoft.com/en-in/microsoft-365/excel

## Description of LOG10 Function

- It is one of the built-in functions in Microsoft Excel.
- This function
**returns the base10 logarithm of a given number**. - For example,
**LOG10(10)**returns the value**1**.

## Syntax

- Here, you will see the syntax of the LOG10 function.
- To apply this function on your spreadsheet, you have to
**select a cell**and**enter the formula**in the following format. - Once you enter the formula, just
**click**on the**Enter**button to get the result.

**=LOG10(number)**

**Parameter Description**

**Number**– The positive number, that you want to find the**base 10**logarithm value.

**Note:**

1) If you give non-numeric values such as letters and special characters to the argument, it will return **#VALUE! Error**.

2) You cannot use negative integers as an argument, it will return **#NUM! Error** value.

## Examples

Let’s see some examples to understand how** LOG10 Function** works. Here, we have shown some numbers and their equivalent LOG10 value.

- Initially, you have to open your Excel workbook on your PC and launch a worksheet that has data.
- For example, we have given the
**input numbers**in**Column B**, and we will get the base 10 logarithm values using the LOG10 function.

- Then, you have to
**enter the formula**in the cell as shown below to get the result.

- After entering the formula, you need to
**click**the**Enter**button to get the output, as shown below. You can drag down the cell to fill the remaining cells.

## Input that Causes Error

By seeing the below-given example, you will understand the input that causes errors in the spreadsheet.

- If you give any non-numeric values such as letters and special characters to the argument, it will return
**#VALUE!**Error. - If you use any type of negative integer as an argument, it will return
**#NUM!**Error value.

Thus, you can learn how to use the **LOG10 Function in Excel **with the help of the above examples.

## Summary

I hope this article helped you understand the usage of the **Excel LOG10 Function **with its syntax, description, and clear-cut examples. Drop your **feedback** in the comment section. To learn more about Excel functions, then visit our webpage Aawexcel.com.

**Video Tutorial**

Use the following video to know how to apply the Excel LOG10 function in the worksheet.

**Read Also:**

- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?

Hi there, I’m **Sridhar** – an Excel enthusiast with over **10 years** of experience working with software. I’m passionate about using Excel to solve complex problems and streamline business processes. Over the years, I have helped businesses of all sizes to improve their **operations and save time and money**.

Aside from working with Excel, I also enjoy writing and sharing my knowledge with others. You’ll often find me contributing to the AAW Excel blog, where I provide tips, tricks, and tutorials that are easy to understand for readers of all skill levels.