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.