Menu
EXCEL LOG FUNCTION
Excel LOG Function Introduction
The Excel LOG function computes the logarithm of a given integer in relation to a particular base.
Description of Excel LOG Function
Syntax :
=LOG( number, [base] )
Parameters :
- The following parameter are:
number –
- The positive interest number for which you wish to compute the logarithm.
[base] –
- An optional input indicating the base in which the logarithmic should be computed.
Step By Step Guide of LOG Function
Example :
If the [base] option is missing, the default value of 10 is used (i.e. the logarithm to the base 10 is calculated).
The worksheet below contains four instances of the Excel Log function:
Key Points
- #NUM! – Occurs if either the provided number or [base] parameter is negative or zero.
- #DIV/0! – Happens if the given [base] parameter equals 1.
- #VALUE! – Occurs if either the specified number parameter or the given [base] argument i.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
