Skip to main content

Description

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

 

Syntax

LOG(Number)

 

Arguments

Argument Type Dimensions Description

Number

(required)

Number Any Dimensions Number to return the logarithm to the base 10 for.

 

Returns

Type Dimensions
Number Dimensions of Number

 

Negative Numbers return BLANK.

 

Examples

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

 

See also

Excel: LOG

Related articles: LN, EXP

Be the first to reply!