Spread Formula Reference
Formula Functions / Functions H to L / LOG
In This Topic
    LOG
    In This Topic

    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