LOG10 in WPS Spreadsheet: Measure Powers of Ten and Decimal Scale

• Introduced: documented by 2019-06-20 in the official WPS lesson; original introduction is not established.
• Availability: WPS Office for Windows Personal; no numeric release is stated. This is documentation evidence, not an installed-build guarantee.
• Scope: exact supported builds remain unverified. The Windows lesson does not establish equivalent availability in other WPS clients.
• Checked: October 14, 2026 against function-specific documentation. Examples were independently calculated; no native WPS test was performed.

=LOG10(number)

The WPS lesson identifies the argument as a positive real number. The examples therefore use positive numeric cells. The direct source does not provide exact current-build error codes for zero, negatives or unrecognized text.

For another base, use LOG. For the natural logarithm, use LN. LOG10’s base is fixed; it has no second argument for an alternative base.

Put 0.001, 0.1, 1, 10, 1000 in A2:A6 and fill:

=LOG10(A2)

Independent expected results are -3, -1, 0, 1 and 3. The output records the exponent on ten, not the number of zero characters displayed in a cell.

For example, 0.001 contains several displayed zeros but has logarithm -3. Changing a cell format to show 1000.00 does not change the underlying value’s logarithm from three to some count based on visible digits.

Two positive measurements in the same unit are 2500 and 25:

=LOG10(2500/25)
=LOG10(2500)-LOG10(25)

Both have expected result 2, representing a factor of 100, or two powers of ten. A logarithmic difference is not an ordinary subtraction of 2475 measurement units.

Doubling a value changes its base-ten logarithm by approximately 0.301029996, while multiplying it by ten changes the logarithm by exactly one in the mathematical model. Equal additions on the logarithmic scale represent equal multiplicative ratios.

Take positive number 0.0042. Its base-ten logarithm is approximately -2.376750710. Applying downward INT gives exponent -3:

=INT(LOG10(0.0042))
=0.0042/10^INT(LOG10(0.0042))

Expected outputs are -3 and 4.2, so the number is 4.2 times 10^-3. The exponent uses downward INT; truncating -2.376… toward zero would give -2 and a mantissa below one, a different normalization.

This is an independent small-number construction, not an exhaustive native scientific-formatting implementation. The original numeric value should remain available rather than being replaced by manually assembled display text.

For positive whole numbers, the mathematical expression INT(LOG10(n))+1 counts decimal digits. Use the explicit control values 1, 9, 10, 99, 100, 999 in C2:C7:

=INT(LOG10(C2))+1

Expected counts are 1, 1, 2, 2, 3 and 3. This model excludes zero, negatives, decimals and leading-zero text identifiers. An identifier stored as 00125 is a representation question, not the three-digit numeric value 125 alone.

Values extremely close to powers of ten can expose floating-point boundary behavior. These finite controls do not certify every integer magnitude or exact native boundary. Use a representation-based method when counting characters in a text identifier is the actual requirement.

=10^LOG10(25) has independently expected value 25. Conversely, =LOG10(10^4) has expected 4. The two forms make the exponent relationship visible.

Taking LOG10 of a sum is not the sum of the individual logarithms. For example, LOG10(10+100) is approximately 2.041392685, while LOG10(10)+LOG10(100)=3. The logarithm-of-product identity does not apply to addition.

Check that values are positive and stored numerically before interpreting a result. A negative LOG10 output can be entirely valid for a positive fraction; a negative input is a different issue outside the stated domain.

The historical WPS lesson establishes the base and domain, while the added examples are independent calculations. Current-client support, complete conversion rules and exact precision/error boundaries remain unverified. Keep full precision for subsequent arithmetic and round only the displayed report.

• WPS Academy: LOG10 lesson, 2019-06-20 (Chinese; Windows Personal scope).
• Editorial testing standards.

The cited WPS product lesson was read directly. Worked outputs are independent expectations, not captured native results or proof of support across all current WPS clients.