How to calculate logarithms and build a base-10 log table in Excel
In Excel, use LOG to choose the base, LOG10 for base 10, and LN for the natural logarithm. LOG also uses base 10 if you omit its second argument. To build a base-10 log table, combine a row heading and a column heading before applying LOG10.
Choose the right logarithm function
A logarithm tells you which exponent gives the input number. Two cubed is eight, so the first formula returns 3. The next two return 2 for an input of 100. The last returns 1 because the natural logarithm uses base e.
=LOG(8,2)
=LOG(100)
=LOG10(100)
=LN(EXP(1))
Set up the table and enter the formula
- Enter 1.0 in A2 and 1.1 in A3, select both cells, and drag the fill handle through A91. Check that the last entry is 9.9. Enter the digits 0 through 9 in B1:K1. Each column heading supplies the hundredths digit.
- Enter the formula below in B2. The reference $A2 keeps column A fixed, and B$1 keeps row 1 fixed. Copying to the right changes only the column heading. Copying down changes only the row heading.
=LOG10($A2+B$1/100)
- Fill B2 across through K2. Then select B2:K2 and fill down through row 91. The range B2:K91 contains 90 rows and 10 columns, for a total of 900 results.
Check the completed table
B2 is 0 for 1.00. C2 is about 0.004321 for 1.01, and K91 is about 0.999565 for 9.99. Display about six decimal places to see the differences. Cell formatting changes what you see while preserving the value used in calculations.
Troubleshoot errors or repeated values
The input must be greater than zero. A base supplied to LOG must also be positive and different from 1. If a formula returns an error, check for numbers stored as text and use the argument separator expected by your regional settings.
If the same result repeats, inspect the dollar signs in C2 and B3. C2 should refer to $A2 and C$1. B3 should refer to $A3 and B$1.




