Returns the logarithm of a number to a specified base.
Cú pháp
LOG(number, [base])Đối số
numberbắt buộc
The positive real number for which you want the logarithm.
basetùy chọn
The base of the logarithm; if omitted, it defaults to 10.
The LOG function calculates the logarithm of a positive number based on a provided base. If the base argument is omitted, Excel defaults to a base of 10.
=LOG(100, 10)→2Calculates the base-10 logarithm of 100, which is 2.
=LOG(8, 2)→3Calculates the base-2 logarithm of 8, which is 3.
Select a cell
Click on the cell where you want the result to appear.
Enter the formula
Type =LOG(number, base) and replace the arguments with your specific values or cell references.
The function will return a #NUM! error because logarithms are only defined for positive numbers.