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

Version Available

This function is available in product version 1.0 or later.

See Also

LN | LOG10 | Math and Trigonometry Functions