Description
The Excel LOG function calculates the logarithm of a given number, to a supplied base.
The format of the function is :
LOG( number, [base] )
where the arguments are listed in the table below :
Excel Log Function Examples
In the example below, the Excel Log function is used to calculate the logarithms of different numbers, using different bases.
The format of the functions is shown in the spreadsheet on the left and the result is shown in the spreadsheet on the right.
Note that, in cells A2 and A4 of the above spreadsheet, the [Base] argument has not been supplied to the function and so, in these examples, base 10 is used.
Log Function Errors
If you get an error from your Excel Log function, use the following table to diagnose the likely cause :
Common Errors
No comments:
Post a Comment