Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelLOG Function in Excel

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

Share:

### You May Also Like

#### SKEW.P Function in Excel

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...

#### SKEW Function in Excel

In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...

#### RANK.EQ Function in Excel

In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
• Excel
• November 23, 2021