Returns the base-10 logarithm of a number.
ฟังก์ชันนี้ทำงานใน Google Sheets เหมือนกับใน Excel — ไวยากรณ์และอาร์กิวเมนต์เดียวกัน
LOG10(number)The LOG10 function calculates the exponent to which 10 must be raised to equal the specified number. It is commonly used in scientific calculations, such as measuring sound intensity in decibels or pH levels.
=LOG10(100)ผลลัพธ์: 2
Since 10 raised to the power of 2 equals 100, the result is 2.
=LOG10(1000)ผลลัพธ์: 3
Since 10 raised to the power of 3 equals 1000, the result is 3.
The function will return a #NUM! error because the logarithm of a negative number is undefined in real numbers.