Formualizer Docs
ReferenceFunctionsMath Functions

LOG10

LOG10: Returns the base-10 logarithm of a positive number.

Summary

Returns the base-10 logarithm of a positive number.

Remarks

  • number must be greater than 0; otherwise the function returns #NUM!.
  • LOG10(POWER(10,x)) returns x up to floating-point precision.
  • Input errors are propagated.

Examples

Power of ten to exponent
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
3
Log base 10 of a decimal
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
-2

FAQ

When does LOG10 return #NUM!?

It returns #NUM! for non-positive input values.

Runtime metadata

Category

Math

Signature

LOG10(arg1: Number)

Arity

min 1, max 1

Arguments

arg1

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

crates/formualizer-eval/src/builtins/math/numeric.rs

LOG

Returns the logarithm of a number for a specified base.

MAX

MAX: Returns the largest numeric value from one or more arguments.

On this page

SummaryRemarksExamplesRelated functionsFAQWhen does LOG10 return #NUM!?Runtime metadata