EXCEL LOG10 FUNCTION

The LOG10 function in Excel computes the base 10 logarithm of a given integer.

Syntax :

=LOG10( number )

Parameters :

  • The number input is the positive real number whose base 10 logarithm you want to compute.

Step By Step Guide of LOG10 Function

Example :

The spreadsheet below contains four instances of the Excel Log10 function:

#NUM! – This error occurs when the supplied number argument is negative or zero.
#VALUE! – This error occurs if the given number argument is not a number.

Related Functions

HLOOKUP Function

HLOOKUP Function

Explore Now

VLOOKUP Function

VLOOKUP Function

Explore Now

INDEX Function

INDEX Function

Explore Now

MATCH Function

MATCH Function

Explore Now

DATE Function

DATE Function

Explore Now

IF Function

IF Function

Explore Now

OR Function

OR Function

Explore Now

AND Function

AND Function

Explore Now

RANK Function

RANK Function

Explore Now

SUMIF Function

SUMIF Function

Explore Now

XIRR Function

XIRR Function

Explore Now

WORKDAYS Function

WORKDAYS Function

Explore Now