How To Use Log In Excel

LOG Function in Excel (Table of Contents)

LOG in Excel
LOG Formula in Excel
How to utilize the LOG Function in Excel?

LOG in Excel

The LOG function is a worksheet function categorized nether the Math/Trigonometry office.

As per Mathematics, the logarithm is defined as an inverse function to exponentiation or logarithm of a positive real number 10 with respect to base of operations b. i.e. b^x=y

E.Chiliad. log₂ 16 = 4, since ii⁴ = 2 ×ii × 2 × 2 = sixteen

Hither, the logarithm (with respect to base 2) of 16 is 4.

The LOG function in Excel is piece of cake to use & very simple; it is the nigh widely used role in statistics, finance & business analytics, or domains.

The LOG function is also used to plot a graph for information representation & it is used with other tools for regression analysis.

The LOG role performs the inverse performance to that of a Ability function.

LOG function in excel calculates the logarithm of a given number to a supplied base of operations or returns the natural logarithm of a number.

E.G. 1000 = 10 × 10 × x = 10³, the "logarithm to base 10" of 1000 is 3, i.e. logarithm counts repeated multiplication of the same gene. The logarithm of a given number x is the exponent to a fixed number, the base b, must exist raised, produce that number x.

i.e. If a^x = b Then Log_a(b) = ten.

LOG Formula in Excel

Below is the LOG Formula in Excel :

Explanation of LOG Part in Excel

LOG formula in Excel consists of two things Number & Base.

Number = Information technology is a positive existent number that you want to calculate the logarithm in excel.

Note: It should exist a numeric value that must always be greater than null.

Base = Information technology is a base to which the logarithm should be calculated, or It is an optional argument that specifies or indicates the base of operations to which the logarithm should be calculated.

Note: If no base is listed, the base is assumed to be x.

How to Use the LOG Function in Excel?

The LOG function in Excel is very unproblematic and easy to use. Let understand the working of LOG part in Excel past some LOG Formula instance.

You can download this LOG Function Excel Template here – LOG Role Excel Template

Example #1 – With Base Argument

In the below-mentioned instance, let's calculate the logarithm in excel of 47, with a base value of 10.

Follow these steps to calculate the LOG in Excel:

Select the output prison cell where we need to find out log value, i.east. D8 in this case.

Click the part button (fx) under the formula toolbar; a popup will appear; double-click on the LOG function nether the select office.

A dialog box appears where arguments (Number & Base) for log function needs to be filled.

Here the number is 47 & the base statement is x.

Excel calculates the logarithm value and displays the answer 1.6720979 in the output jail cell.

Example #two – Without Base of operations Statement

In the below-mentioned example, let's calculate the logarithm of 100, without base of operations value.

Follow these steps to calculate the LOG in Excel:

Select the output cell where we need to find out log value, i.e. D13 in this example.

Click the function button (fx) under the formula toolbar; a popup will announced; double-click on the LOG function under the select part.

A dialog box appears where arguments (Number & Base) for log function needs to be filled.

Here the number is 100 & In this log role example, the Log office by default takes the base of operations value as 10 if the second statement (Base) is not passed in the log function.

Excel calculates the logarithm value and displays the answer 2 in the output cell. i.due east. 100 = 10 × ten = 10ⁱⁱ, the "logarithm to base 10" of 100 is two i.e. logarithm counts repeated multiplication of the aforementioned factor. Therefore, it returns the output value or a issue every bit 2.

Example #3 – With Decimal Value Equally Base Argument

In the below-mentioned instance, allow'southward calculate the logarithm of 6, with the decimal value 0.5 as the base argument.

Follow these steps to calculate the LOG in Excel:

Select the output cell where we demand to find out log value, i.e. D17 in this example.

Click the function button (fx) under the formula toolbar; a popup volition announced; double-click on the LOG function under the select function.

A dialog box appears where arguments (Number & Base) for log role needs to exist filled.

Here the number is 6 & the base statement is 0.5.

Excel calculates the logarithm value and displays the respond -two.584963 in the output cell. i.e. 0.5^-ii = 6; Therefore, Log_0.v(six) = -2.584963

Example #4 –When Base Argument is Negative Value or Zip

In the below-mentioned example, let's calculate the logarithm in excel of 47, with base argument "0" Goose egg or Negative value (-10).

Follow these steps to summate the LOG in Excel:

Select the output prison cell where nosotros demand to observe out log value, i.east. K8 in this example.

Click the function push (fx) under the formula toolbar; a popup will appear; double-click on the LOG function under the select function.

A dialog box appears where arguments (Number & Base) for log role needs to exist filled.

Here the number is 47 & the base argument is -1.

or 0.

Let's calculate the logarithm in excel value and brandish the reply #NUM! error in the output cell.

Example #5 – When Base Argument is Non-Numeric Or Text Value

In the below-mentioned case, let's calculate the logarithm of 47, where the base argument is a text string, i.e. "EXCEL".

Follow these steps to calculate the LOG in Excel:

Select the output cell where we demand to find out log value, i.e. K16 in this example.

Click the function button (fx) under the formula toolbar; a popup will appear; double-click on the LOG function nether the select function.

A dialog box appears where arguments (Number & Base of operations) for log function needs to be filled.

Here the number is 47 & the base argument is TEXT string, i.e. EXCEL.

Excel calculates the logarithm value and displays the answer #VALUE! error in the output cell.

Things to call back about the LOG Function in Excel

Number argument in LOG Function: Information technology should always exist a positive existent number that you want to calculate the logarithm in excel.
It should be a numeric value & must always be greater than zip.
If no base is listed in a Base argument, the base of operations is e'er assumed to exist ten.