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.