[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

LOG

Syntax:

LOG ( x [ , base ] )

Description: Computes the logarithm of x to the base base.

Arguments:

Name

Type

Description

x

number

The positive real number for which the logarithm is being computed.

base

number

The base of the logarithm. If omitted, base 10 is assumed.

 

Return Type and Value: number – The logarithm of x.

However, if

x is zero or negative, #NUM! is returned.

base is zero or negative, #NUM! is returned.

[Example:

LOG(10) results in 1
LOG(8,2) results in 3
LOG(86,2.7182818) results in 4.454347343

end example]