- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Math and Trignometric - LOG Function
Description
The LOG function returns the logarithm of a number to the base you specify.
Syntax
LOG (number, [base])
Arguments
Argument | Description | Required/Optional |
---|---|---|
Number | The positive real number for which you want the logarithm. | Required |
Base | The base of the logarithm. If base is omitted, it is assumed to be 10. | Optional |
Notes
The Logarithm of a number, to a given base, is the power to which the base must be raised to give that number
If ax = b, then Lna(b) = x
If either the specified number or the specified base is negative or zero, LOG returns #NUM! error.
If the specified number or the specified base is not a numeric value, LOG returns #VALUE! Error
If the specified base is equal to 1, LOG returns #DIV/0! Error.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016
Example
advanced_excel_math_trigonometric_functions.htm
Advertisements