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:

**Syntax**: =LOG10(A2)

**Result**:

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

**Note**:

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.