SheetRocks
Documentation/Formulas/LOG

LOG

Returns the logarithm of a number to a specified base

Syntax

LOG(number, [base])

Arguments

Argument Description Required
number The positive real number for which you want the logarithm Required
base The base of the logarithm. Defaults to 10. Optional

Examples

Base-10 logarithm (default)

=LOG(100)
Result ⇒ 2

Logarithm with custom base

=LOG(8, 2)
Result ⇒ 3

Logarithm from cell values

=LOG(A1, A2)
Result ⇒ 3
A
1 64
2 4

Related Functions

Other Math functions:


← Back to Formula Reference