Use the LOG Function to Find the Logarithm in Base 10

Description

Returns the logarithm of the given number to the base 10.

LOG(Number)

Argument	Type	Dimensions	Description
Number (required)	Number	Any Dimensions	Number to return the logarithm to the base 10 for.

Argument

Type

Dimensions

Description

Number

(required)

Number

Any Dimensions

Number to return the logarithm to the base 10 for.

Type	Dimensions
Number	Dimensions of Number

Negative Numbers return BLANK.

Formula	Result	Description
`LOG(1)`	0	log(1) equals 0.
`LOG(100)`	2	log(100) equals 2.
`LOG(0.5)`	-0.30103	log(0.5) equals -0.30103.
`LOG(-2)`	`BLANK`	-2 is a negative number, the function returns `BLANK`.