SINH in SoftMaker PlanMaker 2026: hyperbolic sine, syntax and worksheet examples

For a real number x, the hyperbolic sine is defined as sinh(x) = (e^x - e^(-x))/2. Unlike the ordinary trigonometric function SIN, it is not based on an angle on the unit circle. It is a smooth, increasing, odd function: SINH(-x) = -SINH(x). Its value is zero at x = 0, positive for positive x, and negative for negative x. These are mathematical properties; they do not describe undocumented internal PlanMaker implementation. SoftMaker’s SINH reference establishes the worksheet function’s name and purpose. The related COSH reference documents the hyperbolic cosine.

Common uses include checking exponential relationships, evaluating the hyperbolic-sine component of engineering equations, and constructing nonlinear worksheets with a known mathematical model. Do not substitute SINH for SIN when working with degrees or radians: =SINH(1) has an expected value of about 1.175201193644, whereas ordinary SIN(1) has a different result.

=SINH(Number)

The English PlanMaker 2026 and 2024 manuals both show SINH(Number) with one argument. Because SINH is unary, no function-argument separator is needed in these examples. A decimal-point example such as 0.45 follows the English documentation; decimal commas, localized function names, coercion of numeric text and formula separators depend on installation settings and are not asserted to work identically in every locale. PlanMaker 2026 · PlanMaker 2024, checked 2026-10-13.

Reproducible example: sample values

Enter the following numbers in A2:A7, and in B2 enter =SINH(A2); copy B2 down to B7. Format column B with enough decimal places for comparison.

Results may display fewer digits because of cell formatting or floating-point rounding. These values were independently generated using Python’s math.sinh, not from native PlanMaker execution. In particular, the function is not constrained to outputs between −1 and 1; that bound belongs to TANH, not SINH.

Reproducible example: use a changing input cell

Put 0.45 in D2 and enter =SINH(D2) in E2. The expected E2 value is approximately 0.465342016934. Change D2 to -0.45: E2 should change sign to about −0.465342016934. This provides a simple sign-symmetry sanity check without creating multiple separate formulas.

1. Verify the odd-function identity

With any real input in A2, enter =SINH(A2)+SINH(-A2) in B2. Mathematically, B2 should be 0. Floating-point results may differ from exact zero by a tiny amount; display sufficient decimals if investigating an apparent mismatch. With A2 = 0.45, the two terms are approximately 0.465342016934 and -0.465342016934.

2. Compare two independent hyperbolic formulas

With A2 = 0.45, enter =SINH(A2) in B2. Independently, the mathematical identity predicts that =(EXP(A2)-EXP(-A2))/2 should equal the same value, roughly 0.465342016934. This is an educational cross-check, not evidence about how PlanMaker implements SINH internally. The PlanMaker 2026 EXP reference describes exponentiation by e. Note that manual exponential expressions can overflow or lose precision for sufficiently large input magnitudes even when a built-in hyperbolic implementation might behave differently. Do not infer PlanMaker’s exact thresholds without application testing.

3. Check the fundamental hyperbolic identity

With A2 = 0.45, type =COSH(A2)^2-SINH(A2)^2 in B2. The mathematical result is 1. This compares two separately documented PlanMaker functions. Because of floating-point rounding, it is safer to check with a tolerance such as =ABS(B2-1)<0.00000001 than require exact bit-for-bit equality. PlanMaker COSH · PlanMaker SINH. Independent math verification is not native formula execution.

4. Transform a positive growth factor

Enter 2 in A2 and compute =SINH(LN(A2)) in B2. The expected result is exactly 0.75 mathematically because sinh(ln 2) = (2-1/2)/2. Enter =SINH(LN(0.5)) to obtain the independently expected value −0.75. Both calculations require a positive input to LN; this is a mathematical transformation, not a recommended business metric without a defined model. See the official LN documentation.

5. Example from a documented Excel formula — not a PlanMaker test

The Microsoft Excel SINH reference shows a probability-model illustration. Its formula =2.868*SINH(0.0342*1.03) has an independently predicted result of approximately 0.1010490631. This confirms the arithmetic identity; it does not establish that PlanMaker’s implementation, locale parsing or workbook exchange was tested. The empirical probability model belongs to that specific illustrative example and must not be generalized. Microsoft Excel SINH documentation, checked 2026-10-13.

Argument limits: The official PlanMaker page specifies one Number argument, but does not publish a precise numeric overflow cutoff, text-coercion rule, platform-specific error display, or treatment of nonfinite inputs. This review therefore avoids assigning unverified error codes such as #VALUE! or #NUM!. SoftMaker SINH documentation.

Similar function names and mathematical definitions indicate a plausible formula-level comparison, not a certificate of cross-application native behaviour. Do not interpret documentation presence as confirmation of availability in every PlanMaker edition, distribution or platform. SoftMaker 2026 · SoftMaker 2024 · Microsoft Excel.

• COSH — hyperbolic cosine: mathematical partner satisfying COSH(x)^2-SINH(x)^2=1.
• TANH — hyperbolic tangent: SINH(x)/COSH(x) for real x.
• ASINH — inverse hyperbolic sine: inverse of SINH; verify its own independent domain and syntax before using.
• EXP — exponential function: use to explain mathematical exponential identities.
• SIN — ordinary trigonometric sine: use for actual trigonometric angles; do not confuse with SINH.

Evidence ledger (all checked 2026-10-13): SoftMaker 2026 SINH (syntax, purpose and vendor example), SoftMaker 2024 SINH (historical documented presence), Microsoft Excel SINH (independent Excel syntax and named versions), and SoftMaker related-function pages linked above. Numerical tables, parity tests and derived identities are independent Python mathematical calculations, not native PlanMaker/Excel test results. No screenshots were captured or fabricated.