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.
How to use LOG Function in Excel?
  • Press enter to display the logarithm answer.
How to use LOG Function in Excel?
  • Use the fill handle to apply the function on the remaining data.
How to use LOG Function in Excel?
  • 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.
How to use LOG Function in Excel?
  • When non – numeric value is used, the syntax returns #VALUE!, and for negative numbers the syntax returns #NUM!.
How to use LOG Function in Excel?