Navigation:  Formula Reference > Spreadsheet Formula Functions >

LOG

Previous pageReturn to chapter overviewNext page

 

This function returns the logarithm base Y of a number X.

Syntax

LOG(number,base)

Arguments

This function has these arguments:

Argument

Description

number

Number for which to find a logarithm. This must be a positive real number

base

[Optional] Base of the logarithm; if omitted, the calculation uses 10 as the base (See LOG10.)

Data Types

Accepts numeric data for both arguments. Returns numeric data.

Examples

LOG(B3,C5)

LOG(R1C2,R4C4)

LOG(255,16) gives the result 1.9985883592

 

See Also

LN

LOG10