COSH in WPS Spreadsheet: Calculate Hyperbolic Cosine and Symmetric Curves

• Introduced: documented by 2019-06-24 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.

=COSH(number)

The WPS lesson requires one real-number argument. Its displayed equation confirms the average of the two exponentials. No degree conversion is part of that definition. If a model uses a scaled input x/a, choose consistent units so the ratio has the intended meaning.

Examples use English names and commas. Results below are independently calculated expectations rounded to nine decimal places, not observations from a running WPS build.

Enter −2, −1, 0, 1 and 2 in A2:A6, then fill =COSH(A2) down B2:B6:

Opposite inputs have the same result: COSH is even. It has minimum mathematical value one at zero, rather than oscillating between negative one and one as COS does. A value greater than one is expected here.

For a modest input of one:

=COSH(1)
=(EXP(1)+EXP(-1))/2

Both expected results are approximately 1.543080635. The two exponential terms are approximately 2.718281828 and 0.367879441.

This is an explanatory identity using EXP, not a recommendation to replace COSH everywhere with a hand-built formula. Intermediate overflow and numerical accuracy can differ, and no extreme-input benchmark was run.

A fictional mathematical profile is defined by y=2*(cosh(x/2)-1). Enter −4, −2, 0, 2 and 4 in D2:D6. In E2 enter and fill down:

=2*(COSH(D2/2)-1)

Expected values are 5.524391382, 1.086161270, 0, 1.086161270 and 5.524391382. Dividing x by two sets the horizontal scale. Subtracting one moves the curve’s minimum to zero; the outside factor two sets its vertical scale.

This is a reproducible mathematical example, not a structural-design calculation. A physical application needs its own assumptions, units and independently validated model.

For the profile above, set y to two. Rearranging gives cosh(x/2)=2:

=2*ACOSH(2)
=-2*ACOSH(2)

Expected positions are approximately 2.633915794 and −2.633915794. Substitution into the profile gives two at either position. The separation between the two points is approximately 5.267831588.

ACOSH supplies the nonnegative principal inverse. The second location comes from the original curve’s symmetry, not from a second value returned by one ACOSH call.

For x=1, the mathematical identity cosh(x)^2-sinh(x)^2=1 gives a useful cross-check:

=COSH(1)^2-SINH(1)^2

Expected result: 1, subject to native floating-point rounding if you run the control. SINH is the hyperbolic sine, which is odd rather than even.

Since COSH(-1)=COSH(1), its output alone cannot reveal the original sign. Taking ACOSH of that output recovers a magnitude, not a signed input. Preserve the original sign separately when a model needs it.

Check that the intended function is hyperbolic, that the argument is numeric and that any scaling was applied to the correct quantity. The selected lesson does not provide a complete current-build error or coercion table. Blank, text, logical and extreme-magnitude behavior remain untested.

Do not interpret the historical lesson date as the first implementation date. The availability block identifies the actual Windows edition evidence and its unresolved current-build scope.

• WPS Academy: COSH lesson, 2019-06-24 (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.