Skip to content
Excel

LOG10 function in Excel

Returns the base-10 logarithm of a number

=LOG10(number)

LOG10 syntax and parameters

One argument, one required.

  • numbernumberRequired

    The positive real number for which you want the base-10 logarithm.

LOG10 examples

Formulas you'll actually reuse.

  1. Orders of magnitude of a value:

    =LOG10(B2)

    Result5.17

  2. A ratio expressed in decibels:

    =20 * LOG10(B2 / C2)

    Result6.02

LOG10 in Google Sheets

Same name — your formula ports as-is.

Try LOG10 in the playground

Edit the example — nothing to install.

Preloaded with the LOG10 formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.