Returns the base-10 logarithm of a number. LOG10 is equivalent to LOG(number, 10). Essential for common logarithm calculations, scientific notation, decibel calculations, and mathematical analysis.
Master the fundamentals of Excel LOG10 function
The LOG10 function returns the base-10 logarithm of a number. LOG10(number) = log₁₀(number). LOG10 is equivalent to LOG(number, 10) but is optimized for base-10 calculations. Key properties: LOG10(1) = 0, LOG10(10) = 1, LOG10(10^n) = n, LOG10(x) is negative for 0 < x < 1. Essential for common logarithm calculations, scientific notation analysis, decibel (dB) calculations in acoustics and electronics, pH calculations in chemistry, and logarithmic transformations in data analysis.
Always uses base 10
LOG10(10^n) = n
Input must be > 0
LOG10(x) = LOG(x, 10)
Function-specific parameters
Function-specific return type
Analyze orders of magnitude
Sound and signal measurements
Acidity/alkalinity in chemistry
Log transformations
Exact matching required
Returns numeric position
Handles missing text gracefully
=LOG10(number)The positive number for which you want the base-10 logarithm.
The base-10 logarithm
Description: Returns the base-10 logarithm of a number
Calculate base-10 log of 100
Returns 2 because LOG10(100) = log₁₀(100) = 2. 10² = 100, so the base-10 logarithm of 100 is 2.
Use LOG10 function in VBA
' Basic LOG10 in VBA
Range("C1").Value = Application.WorksheetFunction.Log10(100)
' Returns: 2
' Calculate base-10 logarithm
Sub CalculateLOG10()
Dim number As Double
number = Range("A1").Value
Dim result As Double
result = Application.WorksheetFunction.Log10(number)
Range("B1").Value = result
End Sub
' Calculate order of magnitude
Sub OrderOfMagnitude()
Dim number As Double
number = Range("A1").Value
Dim order As Double
order = Application.WorksheetFunction.Log10(number)
Range("B1").Value = Int(order)
' Integer part gives order of magnitude
End Sub
' Calculate decibels
Sub CalculateDecibels()
Dim powerRatio As Double
powerRatio = Range("A1").Value
Dim db As Double
' dB = 10 * LOG10(power_ratio)
db = 10 * Application.WorksheetFunction.Log10(powerRatio)
Range("B1").Value = db
End Sub
' Calculate pH from hydrogen ion concentration
Sub CalculatepH()
Dim hConcentration As Double
hConcentration = Range("A1").Value
Dim ph As Double
' pH = -LOG10([H+])
ph = -Application.WorksheetFunction.Log10(hConcentration)
Range("B1").Value = ph
End SubAnalyze orders of magnitude
Sound and signal measurements
Acidity/alkalinity in chemistry
Log transformations for normalization
LOG10 returns #NUM! for zero or negative numbers
=IF(A1>0, LOG10(A1), "Invalid")Solution: LOG10 only works with positive numbers. LOG10(0) and LOG10(negative) return #NUM!. Ensure input is > 0. Check for negative values or zero in your data.
Non-numeric input in LOG10
=LOG10(VALUE(A1))Solution: Ensure input is numeric. LOG10 requires a positive number. Check for text, errors, or empty cells. Use VALUE() if needed.
LOG10 results have many decimal places
=ROUND(LOG10(A1), 4)Solution: Use ROUND for display: ROUND(LOG10(value), digits). LOG10 can return many decimal places that may need formatting.
Uncertainty about LOG10 vs LOG
LOG10(100) = LOG(100, 10) = 2Solution: LOG10(number) is equivalent to LOG(number, 10). LOG10 is optimized for base-10 and slightly faster. Use LOG10 for base-10 calculations.