September 23, 2023

How to use the Excel LOG10 function

The LOG10 Excel function is a Math formula that returns the logarithm of a given number, using base 10. The logarithm of a given number is the exponent to which another fixed number (the base 10) must be raised to produce that number. In this guide, we’re going to show you how to use the LOG10 function in Excel and also go over some tips and error handling methods.

Syntax: =LOG10(number)

The LOG10 function syntax has the following arguments:

  • Number: This specifies the number of which you want its logarithm.

Example: Let’s look at some Excel LOG10 function examples and explore how to use the LOG10 function as a worksheet function in Microsoft Excel:

Excel LOG10 function - How to use the Excel LOG10 function

Syntax:  =LOG10(A2)


Excel LOG10 function 1 - How to use the Excel LOG10 function

Based on the Excel spreadsheet above, the following LOG10 examples would return:

Syntax: =LOG10(A3)
Result: 1

Syntax: =LOG10(A4)
Result: 2

Syntax: =LOG10(A5)
Result: 3

Syntax: =LOG10(A6)
Result: 4

Syntax: =LOG10(A7)
Result: 5

Syntax: =LOG10(A8)
Result: -1

Syntax: =LOG10(A9)
Result: -3

Syntax: =LOG10(A10)
Result: 1.397940009


There are instances when one will get an error after using the LOG10 function. This can be due to the following two reasons:

#NUM! – This error will occur if you supply a negative or zero number.

#VALUE! – This error will occur if you supply a non-numeric number.

READ:  How to use the Excel MULTINOMIAL function

Leave a Reply

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