What is the difference between LOG and LOG10?

LOG10 computes base-10 logarithms, while LOG computes natural logarithms (base e ≈ 2.718). Use LOG10 for decimal-based scales common in business and budgeting; use LOG for scientific calculations. Example: LOG10(100) = 2, but LOG(100) ≈ 4.605.

Why does LOG10 of a number between 0 and 1 return negative?

Negative logarithms represent fractional exponents: LOG10(0.1) = -1 because 10^-1 = 0.1. In budget analysis, LOG10(Actual/Budget) returns negative when actual is less than budget, making underages visually distinct from overages while maintaining mathematical accuracy.

Can LOG10 help with data visualization and dashboards?

Absolutely. LOG10 is essential for visualizing budget data with extreme ranges—if items span $100 to $100,000, logarithmic scaling makes all categories visible and comparable on one chart. This technique is standard in financial dashboards, portfolio analysis, and expense tracking.

How do I handle zero or negative values in my budget data?

LOG10 cannot process zero or negative numbers directly. Use LOG10(ABS(value)+0.01) to take the absolute value with a small offset, or filter your dataset to include only positive values before applying LOG10. For variance columns specifically, apply LOG10 only to absolute value cells.

LOG10 function

LOG10 returns the base-10 logarithm of a positive number, useful for converting exponential scales to linear analysis and visualization.

=LOG10(number)

Generate a LOG10 formula

Describe what you need. The generator will reach for LOG10 where LOG10 is the right tool, and tell you when it is not.

Arguments

How LOG10 reads its arguments

Argument	Required	Description
number	Required	A positive number greater than 0. If zero or negative, LOG10 returns #NUM! error; if text or non-numeric, returns #VALUE! error.

Returns

A decimal number representing the base-10 logarithm of the input number.

Availability

Excel: All · Google Sheets: Supported

Worked examples

1. Assess order of magnitude of a budget item

Category	Month	Budgeted
Housing	January	2000

=LOG10(B2)

Result: 3.301

LOG10(2000) returns 3.301, indicating the housing budget of $2000 falls between 10³ and 10⁴, specifically at 10^3.3. This helps quickly identify which magnitude range an expense belongs to, compressing a wide spread of values into normalized form for comparison.

2. Compare actual spending to budget using logarithmic ratio

Category	Budgeted	Actual
Entertainment	200	150

=LOG10(D5/B5)

Result: -0.1249

Dividing actual (150) by budgeted (200) yields 0.75; LOG10(0.75) returns -0.1249. The negative logarithm indicates the ratio is less than 1, representing actual spending approximately 25% below target. Negative log values are mathematically correct representations of fractional ratios.

3. Find the magnitude category of a medium expense

Category	Month	Actual
Utilities	January	325

=LOG10(D3)

Result: 2.512

LOG10(325) returns 2.512, placing utilities spending ($325) between 10² and 10³, at roughly 10^2.5. By applying LOG10 across all expense categories, dramatically different costs (from $150 to $2000) become visually comparable on a single chart without any category disappearing due to scale.

Common errors

Which LOG10 error are you seeing?

Error	Why it happens	How to fix it
#NUM!	The argument is zero or negative; LOG10 is mathematically undefined for non-positive values because no power of 10 produces zero or a negative result.	Ensure the input is a positive number. For variance data that includes negative values, use =LOG10(ABS(value)+1) to convert to absolute value with a small offset, preserving zero and negative entries.
#VALUE!	The argument is text, a boolean (TRUE/FALSE), or any non-numeric data type that LOG10 cannot interpret as a number.	Verify the referenced cell contains only numeric data with no text formatting, quotes, or symbols. Convert text-formatted numbers using VALUE() function if needed, or ensure the cell data type is set to Number.
#REF!	The formula references a cell that has been deleted, moved outside the sheet, or is otherwise invalid in the current workbook structure.	Check all cell references in your formula (B2, D5, etc.) still exist and contain the values you intend. Re-enter the formula with valid cell references, or use a stable named range instead of cell addresses.

Tips and when to use something else

LOG10 shines with datasets spanning multiple orders of magnitude—expenses from $10 to $10,000 become linearly comparable on a chart without any category vanishing into invisibility.
When comparing ratios like Actual/Budgeted, LOG10 of the ratio is more intuitive than the raw decimal: negative logs mean under-budget, positive logs mean over-budget, with zero log meaning perfect match.
For gentler scaling of smaller variances, consider SQRT() instead of LOG10; it amplifies differences less aggressively than logarithmic compression.
Reverse a LOG10 result using POWER(10, result) to recover the original value—for example, POWER(10, 3.301) returns approximately 2000.

Related functions

ROUNDROUND returns a number rounded to a specified number of decimal places, using standard rounding rules (0.5 rounds up).INTINT rounds any number down to the nearest whole integer, always discarding decimal places and rounding toward negative infinity.ABSABS returns the absolute value of any number, removing the sign to show only magnitude, useful for comparing distances regardless of direction.CEILING.MATHCEILING.MATH rounds numbers up to the nearest multiple of a given significance value, useful for conservative cost estimates and price rounding.

Frequently asked questions

What is the difference between LOG and LOG10?: LOG10 computes base-10 logarithms, while LOG computes natural logarithms (base e ≈ 2.718). Use LOG10 for decimal-based scales common in business and budgeting; use LOG for scientific calculations. Example: LOG10(100) = 2, but LOG(100) ≈ 4.605.
Why does LOG10 of a number between 0 and 1 return negative?: Negative logarithms represent fractional exponents: LOG10(0.1) = -1 because 10^-1 = 0.1. In budget analysis, LOG10(Actual/Budget) returns negative when actual is less than budget, making underages visually distinct from overages while maintaining mathematical accuracy.
Can LOG10 help with data visualization and dashboards?: Absolutely. LOG10 is essential for visualizing budget data with extreme ranges—if items span $100 to $100,000, logarithmic scaling makes all categories visible and comparable on one chart. This technique is standard in financial dashboards, portfolio analysis, and expense tracking.
How do I handle zero or negative values in my budget data?: LOG10 cannot process zero or negative numbers directly. Use LOG10(ABS(value)+0.01) to take the absolute value with a small offset, or filter your dataset to include only positive values before applying LOG10. For variance columns specifically, apply LOG10 only to absolute value cells.

Need a different formula?

The full generator is not scoped to one function — describe any spreadsheet problem and it will pick.

Open the formula generator

Reviewed 2026-09-17