These docs are for v1.0. Click to read the latest docs for v1.2.

LOG / LOG10

Calculates the base 10 logarithm of the specified number

Syntax

=LOG(value)

=LOG10(value)

Arguments

ArgumentTypeDescription
valueNumberThe value used to calculate the base 10 logarithm. Must be greater than 0.

Examples

=LOG(4.5)0.6532125137753437
Calculates the base 10 log of 4.5

=LOG(10)1
Calculates the base 10 log of 10

=LOG10(-1)#ERROR!
Calculates the base 10 log of -1

=LOG(@"Property 1")0.08990511143939792
Calculates the base 10 log of the shape data property "Property 1", which has the value 1.23