Logarithmic and Exponential Functions

EasySpreadsheet includes logarithmic, natural logarithmic, and exponential functions.

Logarithmic Functions

LOG (number, base): Returns the logarithm of the number to the specified base. If the base is omitted, base-10 will be used.

LOG10 (number): Returns the base-10 logarithm of the specified number.

LN (number): Returns the natural logarithm (based on the constant e) of the specified number. LN is the inverse of EXP.

Examples:

Formula

Result

=LOG(9, 3)

2

=LOG(10)

1 (base-10 is assumed)

=LOG(10^8)

8 (base-10 is assumed)

=LOG(0)

#NUM! (number must be greater than 0)

=LOG10(1)

0

=LN(EXP(2))

2

 

Exponential Functions

EXP (number): Returns e raised to the power of the specified number. EXP is the inverse of LN. For example, EXP(LN(2))would return 2. (Hint: Use EXP(1) for the constant value e, which is approximately 2.718281828.)

Note: To raise another number to a certain power, use the ^ operator. For example, 2^3 is the same as 2*2*2, and would return 8.