# LOG Function in Excel

In this post you will learn about a simple function in Excel – LOG Function, how to use it in your excel spreadsheet.

The Log function is used to get the logarithmic value of a given number with a specified base.

Syntax

`=LOG(number, base)`

The syntax has two arguments

• number – This holds the number that you want the logarithm value.
• base – Holds the base of the algorithm, default value is 10.

## How to use LOG Function in Excel?

The function converts the number into its logarithmic value, with the given base value.

Examples

• Start by entering the numbers and the base values in an excel sheet.
• In a new cell enter the syntax and highlight the the data cells to include them in the function.
• Press enter to display the logarithm answer.
• Use the fill handle to apply the function on the remaining data.
• The LOG Function syntax accepts integers and decimal numbers.
• The base value is an optional argument as it has a default value 10, the following example shows the function working with the default base value.
• When non – numeric value is used, the syntax returns #VALUE!, and for negative numbers the syntax returns #NUM!.