IMLOG2: Complex Base-2 Logarithm in WPS Spreadsheet

=IMLOG2(inumber)

The one required argument is the complex number whose logarithm is wanted. The official lesson describes complex text using x+yi or x+yj; a cell can contain that input and be passed by reference. A quoted complex literal is text notation for a number, not a worksheet expression that multiplies a variable named i.

The lesson does not specify a logarithm branch or the exact zero-input error. The controls cover conventional real-logarithm values on positive real inputs and a bounded first-quadrant example corroborated by the vendor walkthrough. Wider complex branch behavior remains unverified, including the negative real axis and branch cuts.

For a positive real input r, the real coefficient is ln(r)/ln(2) and the imaginary coefficient is zero. The official formula image expresses this base change as multiplication of the complex natural logarithm by log_2(e), equivalently division by ln(2).

In general mathematical notation, a logarithm of a nonzero complex number relates magnitude and phase. Phase is not unique without a branch convention. That mathematical fact explains why a positive-real control cannot certify WPS branch choices for other inputs. No principal-branch claim is inferred from another spreadsheet.

Enter the quoted literals exactly as shown. For the cell-reference formula, place text 8+0i in A2 first. The table gives independently computed mathematical coefficients. It does not predict whether WPS serializes a real result as text, omits a zero imaginary term or chooses a particular number of displayed digits.

For =IMLOG2("3+4i"), the magnitude is sqrt(3²+4²)=5. The first-quadrant angle is atan(4/3), approximately 0.927295218002 radians. The natural-log coefficients are ln(5) and that angle. Divide both coefficients by ln(2) for this logarithm base. The independently expected coefficients are 2.32192809489 real and 1.33780421245 imaginary.

The official lesson’s published walkthrough shows input 4+3i with displayed coefficients 2.32192809488736 and 0.928375858462621. Independent magnitude-and-angle arithmetic reproduces that published example. This corroborates the bounded first-quadrant convention used here; it is vendor demonstration evidence, not a calculation performed in WPS for this guide. It does not settle full-plane branch behavior or guarantee the serialization of a new result.

Powers of two provide exact conceptual checks: 2 has logarithm 1 and 8 has logarithm 3. A positive input of 0.25 is 2 to the power −2, giving −2. The result for 3 is approximately 1.58496250072 and is not rounded up to the next integer automatically.

A positive ratio of 32 has a base-2 logarithm of 5, corresponding mathematically to five factors of two. A ratio that is not a power of two gives a fractional logarithm. If a separate planning problem requires a whole number of stages, choosing a rounding rule is an additional modelling decision, not part of IMLOG2.

Keep the imaginary suffix consistent within a complex-data model and use the notation documented by WPS. The lesson mentions i and j forms but does not establish every accepted spelling, embedded-space convention, uppercase suffix or text coercion rule. These controls avoid those ambiguities.

Zero has no finite complex logarithm mathematically, but the exact WPS error representation is not established by the lesson. Malformed complex text, empty cells, propagated errors, overflow and extreme magnitudes likewise have no execution-backed error table here.

For ordinary positive real calculations, the real logarithm functions may express the intent more directly. The complex function remains useful when maintaining a consistent complex-text workflow, but its name is not an exact alias for a real-only function. Any wider complex-domain use needs an independently established branch contract for the target WPS environment.

The official WPS lesson is dated 2019-06-24 and explicitly labels its applicability WPS Office for Windows Personal. It does not identify a numeric release. This establishes documentation by that date, not the function’s original introduction or its last working version. Current build limits and equivalence across WPS clients remain unverified. The available evidence does not establish retirement or formal deprecation.

Checked October 18, 2026. The examples in this guide are original, independently calculated controls based on the lesson. They have not been run in WPS or another spreadsheet application. No screenshot or execution result is claimed.

LN, LOG, LOG10.