LOG10 Excel Formula

Author Zaheer    Category Formulas     Tags ,

Microsoft Excel is one of the programs in Microsoft that is frequently used by a lot of users. Mainly, the people who often use this application are those that are working in a company that deals with field works for engineering and financial matters. But even common people or students are utilizing this application as well. This is because of the capability of the program to compute several mathematical computations, to organize and store records and documentations to the criteria set by the user.

However, along with the use of Excel the user must learn and be familiar with the different functions that it contains because a certain mathematical calculation will only work if right function was used. In this regards, this article tackles one of the existing functions of Excel which is the LOG10 function. This is utilized to compute the base-10 logarithm of a certain value. Since Microsoft Excel gives appropriate answer due to formula so when using the LOG10 functions the syntax to be used is:


Where in:

number – is the positive actual number which is desired to compute the value of base-10 logarithm. To avoid error the value must be greater than zero value.

To understand more the result, below are some of the key pointers when using the program.

  • The outcome of the function is of similar kind and type of the value given.
  • The value is an ACTUAL representation of log10(number). Once the value arguments are equals to zero, balanced division exclusion happens. But once trapped, a negative infinity value is returned.
  • Once the value argument is lower than zero, invalid operation of the function occurs. Once it is trapped, no number value is returned.

Frequent Mistakes

It is normal that while doing the operations, there are mistakes encountered. To anticipate them it is better to contain ideas about it. So, listed below are common errors obtained:

  • #NUM! – this usually happens once the value of argument is zero or negative.
  • #NAME? – this is the result if the argument value or the base argument is not a numerical number.

LOG10 Function Example:

You may go to the examples that are written below and practice yourself to perform the examples in order to be familiar with the function.

From A1 cell, type the following value:

  • A1 = 10
  • A2 = 100
  • A3 = 15
  • A4 = 12
  • A5 = 25E5

After typing, do the following procedure to compute for the base-10 logarithm of the values:

  • Click the next right side cell, where to appear the answer.
  • From the empty cell, type in the LOG10 function syntax which is “=LOG10(number)”.
  • On the number argument to place value click on the reference cell. The Syntax to occur after clicking the reference must be “=LOG10(A1)”.
  • After placing the required value argument, press the enter key.
  • Instantaneously after pressing the enter tab, the answer will comes out and it is equals to 1.
  • Try to practice computing for the rest given values by following the procedures. The answers you must get are as follows:

A2 = 2

A3 – 1.17609

A4 = 1.07918

A5 = 6.39794

Once you did not arrive with the same answer, check your syntax. Usually errors occur due to wrong input of data.

Post comment