# How to Use Excel LOG10 Function?

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