LOG10()

Syntax. LOG10(number)

Definition. This function returns the common logarithm (base 10) of a number.

Argument

  • number (required) The positive real number for which you want to calculate the base-10 logarithm

Background. The LOG10() function uses the common logarithm with base 10.

Examples. The common logarithm is often used in natural science; for example, to calculate the volume in decibels:

image with no caption

You will find more information in specialist literature.

More examples for this function are:

  • =LOG10(2) returns 0.301029996.

  • =LOG10(6) returns 0.77815125.

  • =LOG10(9) returns 0.954242509.

  • =LOG10(10) returns 1.

See Also

EXP(), IMLN(), IMLOG10(), IMLOG2(), LN(), LOG() ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial