LOG10 Function in ONLYOFFICE Spreadsheet Editor: Base-10 Logs and Examples

Each increase of 1 in LOG10 corresponds to multiplying the original measurement by ten. LOG10 is different from rounding a number to the nearest power of ten.

For x>0: LOG10(10^k)=k for powers representable by the calculation; LOG10(x)=LOG(x,10)=LN(x)/LN(10) mathematically.

=LOG10(number)

This is a one-argument function and has no optional base. It is mathematically equivalent to LOG(number,10); LOG(number) also uses base 10 according to ONLYOFFICE’s LOG reference.

The spelling, argument order and documented defaults above follow the ONLYOFFICE LOG10 function reference, accessed 2026-10-13. No argument-order assumptions were borrowed from another spreadsheet product.

1. Open a blank spreadsheet and select an empty result cell.
2. Type a formula beginning with =, or use Formula → Function, search for LOG10, then enter the required arguments.
3. For the following examples, use the English function name, a decimal point, and commas where multiple arguments appear, matching ONLYOFFICE’s documented English formula examples.
4. Confirm the result, then use the cell’s number format to display six decimal places when comparing fractional expected values.
5. If a formula is rejected, check File → Advanced Settings for formula language and regional settings. ONLYOFFICE lets you change formula language and decimal/grouping separators; the exact punctuation for each locale has not been tested. Do not blindly replace commas with semicolons without checking the target installation.

Enter these six positive values into A2:A7. Type =LOG10(A2) in B2 and fill through B7. Use a six-decimal display format for B2:B7 to compare to the independently computed expected outputs.

Verification method: table outputs above are numerical expectations computed independently with Python’s math library, formatted to six decimal places. They are not asserted as ONLYOFFICE screenshots, native execution results or exact display strings. The vendor’s reference verifies the formula form but not the sample rows.

The following formulas use literal numeric values, so they can be pasted into any blank result cell of a scratch workbook. Results are six-decimal mathematical expectations (unless the underlying calculation is an exact integer).

Avoid mistaking a displayed rounded value for exact mathematical equality. A visible 0.000000 may arise from cell formatting when the internal value is merely small.

If A2 contains 45000, enter:

=INT(LOG10(A2))

The independently calculated expected result is 4, meaning the number lies between 10⁴ inclusive and 10⁵ exclusive. This interpretation only applies to positive inputs. For an exact positive power of 10 such as A2=100000, the result is 5.

Comparing two positive measurements

Place 100 in B2 and 1000 in C2:

=LOG10(C2/B2)

The expected result is 1: the ending value is one order of magnitude (tenfold) larger. Swap the inputs to get −1 mathematically. Never pass a zero or negative ratio.

Find the multiplier back from a log reading

Suppose B2 has the base-10 log value 2.5. Enter:

=POWER(10,B2)

Expected 316.227766. The relationship is mathematical: 10^LOG10(x) = x for x>0, subject to numeric precision.

Use the right logarithm

At input 100, LOG10(100)=2 while LN(100)≈4.605170. In ONLYOFFICE documentation, LOG(100) also defaults to base 10. The natural logarithm must be called LN explicitly.

The argument must be positive. Numeric precision can affect the last displayed digits in non-powers of ten, and very large/small numbers may be constrained by implementation limits. The official reference does not provide a numeric overflow range, platform-specific differences or the first-supported release; retain these as verification tasks.

For a comparative spreadsheet tutorial, note that other spreadsheet editors may expose identically named functions, but naming alone does not prove equivalent coercion, domain error codes, or release support. Formula portability must be tested in the actual target software and version. No such third-party result is used to establish ONLYOFFICE behaviour here.

• Documentation scope: The current ONLYOFFICE Help Center function reference lists LOG10 in the Math and Trigonometry catalogue and gives the syntax above. The page does not identify the first supported Desktop, Docs server or self-hosted release. The listing is evidence of present documentation, not an execution test across editions.
• Desktop/web: The separate Desktop Editors changelog and browser-oriented Spreadsheet Editor guide exist, but a specific minimum version for LOG10 was not established. Do not label all historical versions compatible.
• Locale: ONLYOFFICE advanced settings documents formula language and regional numeric formatting. The formulas here use English names and decimal-point notation. Localized formula names, separators and translated errors remain pending native verification.
• File exchange: These examples are designed around workbook formulas and simple numeric cells; saved-file round trips and cross-application differences were not executed.

Native Desktop/web execution, text/blank coercion, invalid-argument errors, regional formula entry, historical release support and workbook round trips remain unverified.