Spread Formula Reference
LOG
Formula Functions > Functions H to L > LOG

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