Formualizer Docs
ReferenceFunctionsMath Functions

LOG

Returns the logarithm of a number for a specified base.

Summary

Returns the logarithm of a number for a specified base.

Remarks

  • If base is omitted, base 10 is used.
  • number must be positive.
  • base must be positive and not equal to 1.
  • Invalid domains return #NUM!.

Examples

Base-10 logarithm
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
3
Base-2 logarithm
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
3

FAQ

Which base values are invalid for LOG?

Base must be positive and not equal to 1; otherwise LOG returns #NUM!.

Runtime metadata

Category

Math

Signature

LOG(arg1: Number, arg2…: Number)

Arity

min 1, max variadic

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

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

LN

LN: Returns the natural logarithm of a positive number.

LOG10

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

On this page

SummaryRemarksExamplesRelated functionsFAQWhich base values are invalid for LOG?Runtime metadata