ASINH in WPS Spreadsheet: Invert Hyperbolic Sine with a Documented Domain Caveat
Understand WPS ASINH, audit its conflicting lesson prose, and calculate positive, signed and scaled inverse models with honest native-test limits.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: ASINH(number) is the inverse hyperbolic sine. Its formal WPS definition allows any real input; =ASINH(1) has mathematical expected result approximately 0.881373587. The lesson’s walkthrough contradicts that domain, so signed examples below are explicitly documentation-based mathematical controls rather than native certification.
Availability and version history
- Introduced: documented by 2019-06-25 in the official WPS lesson; original introduction is not established.
- Availability: WPS Office for Windows Personal; no numeric release is stated in the edition metadata.
- Scope: exact current 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.
Syntax and the source conflict
=ASINH(number)
The official lesson’s formal Number definition says any real number. Later walkthrough prose says the number must be at least one, a restriction that conflicts with both that definition and the real inverse of SINH. The guide follows the formal definition while preserving the discrepancy here.
Positive examples at or above one agree with both passages. Zero, negative and positive-below-one cases remain disputed by the walkthrough and have not been run in WPS. Do not silently generalize the lesson into a verified current-build input matrix.
Example 1: positive controls within both source descriptions
Enter 1, 2 and 10 in A2:A4 and fill =ASINH(A2) down:
| Input | Independent expected result |
|---|---|
| 1 | 0.881373587 |
| 2 | 1.443635475 |
| 10 | 2.998222950 |
These are inverse hyperbolic values, not circular angles to be converted into degrees. Use English function names and comma separators. Decimal values are rounded only for display.
For input two, applying SINH to the unrounded result returns two mathematically. A rounded number copied from the table may leave a small reconstruction difference.
Example 2: expose the logarithmic identity
For the same modest positive input:
=ASINH(2)
=LN(2+SQRT(2^2+1))
Both expected results are approximately 1.443635475. The inner square root is √5, and the logarithm receives the positive quantity 2+√5.
This is an independent mathematical identity, not a claim that WPS internally uses that expression. A direct formula can be less stable for certain signs or large magnitudes, so it is not recommended as an unrestricted numerical replacement.
Advanced example: invert a scaled hyperbolic-sine model
Suppose a fictional relation is y=5*sinh(x/2), and y is 10. Divide by five before applying the inverse, then restore the horizontal scale:
=2*ASINH(10/5)
Expected x: approximately 2.887270950. Substituting the unrounded result into 5*SINH(x/2) gives 10 mathematically.
Applying ASINH to 10 and dividing afterward would solve a different expression. The order of the scale transformations matters. The ASINH input here is two, safely inside the two lesson passages’ common stated domain.
Advanced mathematical control: a signed, scaled transformation
For a modeling exercise, let z=asinh(value/10) and use values −20, −10, 0, 10 and 20. The real-function expectations are −1.443635475, −0.881373587, 0, 0.881373587 and 1.443635475.
The intended worksheet formula is:
=ASINH(D2/10)
This signed table follows the formal all-real definition and mathematics. Because the walkthrough conflicts with it, the nonpositive rows are not claimed as validated WPS results. Use them as explicit target-build tests before deploying this transformation.
Mathematically, the inverse is 10*SINH(z), which recovers each original value. The scale ten controls how much of the input range falls near the approximately linear central region. It must be chosen for the actual model rather than assumed from the function name.
Advanced check: compare with an ordinary logarithm
For positive x=10, ASINH(x) is approximately 2.998222950, while LN(2*x) is approximately 2.995732274. Their difference is approximately 0.002490677.
The logarithm is an approximation at this input, not an exact substitute. Unlike a real logarithm of x, the formal mathematical ASINH definition also accommodates zero and negative values; the conflicting WPS walkthrough prevents treating that observation as a native product test.
Errors and limits
The walkthrough mentions #VALUE! for a non-real input without defining a complete spreadsheet coercion matrix. No error code is inferred for zero, negative numbers or numeric-looking text from that incomplete description.
Keep the conflict visible when reproducing the guide in a current build. See SINH for the forward function and ACOSH for the inverse whose real domain genuinely begins at one.
References and verification
- WPS Academy: ASINH lesson, 2019-06-25 (Chinese; Windows Personal scope).
- Editorial testing standards.
The direct WPS product lesson supports the stated function scope. Worked outputs are independent expectations, not captured native results or proof of support across all current WPS clients.