Log()

Working with Formulas > Functions Used in Formulas > Numeric Functions > Log()

LOG() returns the logarithm of a number in the specified base. If no base is specified, LOG() uses a default base of ten. If the input is invalid, the function returns zero.

Function Format

LOG(number [, base]) 

Return Value

LOG() returns a numeric value 

Examples

LOG(10) = 1 

LOG(10, 2) = 3.3219 

LOG(1024, 2) = 10 

LOG(1, 0) = 0