LOG10 function in Excel

What is LOG10 function in Excel?

The LOG10 function is one of the math functions of Excel.

It Returns the base-10 logarithm of a number.

We can find this function in Math & trig category of insert function Tab.

How to use LOG10 function in excel

  1. Click on empty cell (like F5 )
empty cell in excel
  1. Click on the fx icon (or press shift+F3)
fx icon in excel

3. In insert function tab you will see all functions

insert function tab in excel

4. Select math and trig category

5. Select LOG10 function

6. Then select ok

excel LOG10 function

7. In function arguments Tab you will see LOG10 function

8. Number is the positive real number for which you want the base-10 logarithm

9. You will see results in formula result section

How to use LOG10 function in excel

Examples of LOG10 function in excel

Example 1:

How to use LOG10 function in excel

You can see examples of LOG10 function below:

Examples of LOG10 function in excel
log10(1) ----->>>>answer is  0

log10(10) ----->>>>answer is  1

log10(100) ----->>>>answer is  2

log10(1000) ----->>>>answer is  3

log10(10000) ----->>>>answer is  4

What is the purpose of LOG10 function?

It Returns the base-10 logarithm of a number.

What is the Return value of LOG10 function?

It returns a number.

How many arguments does LOG10 function have?

This function has just 1 Argument.

The argument of LOG10 function is number.

Number is the positive real number for which you want the base-10 logarithm.

The argument of LOG10 function is required and not optional.

LOG10(number) = number

Which version of excel supports LOG10 function?

This function is available for all excel versions (2003-2019)

Errors in LOG10 function

LOG10 related functions :

Leave a Reply

Your email address will not be published. Required fields are marked *