TANH in SoftMaker PlanMaker 2026: hyperbolic tangent syntax and examples

Mathematically TANH(x) = (EXP(x)-EXP(-x))/(EXP(x)+EXP(-x)) for real x. This sends negative inputs toward −1, positive inputs toward +1, and zero to zero. It is useful for normalized response models, visualization of saturation, signals and mathematical transforms, but it is not the ordinary trigonometric tangent TAN (which accepts an angle in radians). SoftMaker documents the TANH function and lists ATANH, COSH and SINH as related hyperbolic functions.

The EXP quotient above is an independent mathematical identity, not a claim about internal PlanMaker implementation or numerical stability. For large-magnitude arguments, using EXP manually may overflow in some numerical systems even when TANH itself has a finite limiting value; PlanMaker’s specific handling must be tested rather than assumed.

=TANH(Number)

The PlanMaker 2026 and 2024 English manuals independently document TANH(Number) with exactly one numeric argument and identical vendor example. The 2021 English manual likewise documents TANH. This demonstrates documentation-level continuity but does not establish the function’s introduction date or guarantee equal native behaviour across all editions. 2026 TANH; 2024 TANH; 2021 TANH.

Manually entered PlanMaker formulas must begin with =, as stated by SoftMaker’s formula-entry help. The examples here use English function names and decimal periods. The PlanMaker Edit settings allow system or custom decimal separators, and SoftMaker notes localized function names. A single-argument TANH call has no argument-list separator, but nested formulas may; do not assume English syntax works unchanged in every localization. No locale-specific native execution was performed.

Create two columns on a blank sheet: enter Input in A1 and TANH output in B1. Populate A2:A12 with the following numeric values. Enter =TANH(A2) in B2, then fill the formula down through B12. You may format B2:B12 to ten decimal places. The output column below shows independently calculated mathematical expectations, not screenshots or tested PlanMaker results.

The function is odd: mathematically TANH(-x)=-TANH(x). It approaches ±1 for large positive/negative inputs; the finite-real mathematical value is never exactly ±1, although finite-precision implementations can display or round to 1 or −1. Because no native test was executed, the exact point where PlanMaker displays 1 is not verified. The vendor’s own 0.45 example is rounded to four decimals. TANH 2026 reference.

Single-cell tests to try in an installed PlanMaker

• =TANH(0) → independently 0.
• =TANH(1) → independently 0.7615941560.
• =TANH(-1) → independently −0.7615941560.
• =TANH(0.45) → independently 0.4218990053, consistent with SoftMaker’s 0.4219 example.
• =TANH(ATANH(0.6)) → independently 0.6 (ATANH input is inside its required −1 to 1 interval).
• =ATANH(TANH(0.1234)) → independently 0.1234, matching the vendor example documented on its ATANH reference.

Assume a numerical process yields a score with arbitrary positive or negative size, and you want a bounded display value. Enter A16=-4, A17=0, A18=4, and place the following in B16, filling down:

=TANH(A16/2)

Independently expected B16 −0.9640275801, B17 0, B18 0.9640275801. The division by 2 adjusts the transition rate. This can be helpful for charts, but it changes the scale and discards some information in the tails; it is not a normalized probability or a statistically calibrated measurement. This is a mathematical application, not a SoftMaker-specific feature claim. TANH syntax.

The algebraic identity sigmoid(x) = (1+TANH(x/2))/2 maps real x to a value strictly between 0 and 1 mathematically. Enter A21=1, then B21:

=(1+TANH(A21/2))/2

Independently expected B21: approximately 0.7310585786. With A22=-1 and B22 containing the equivalent row-adjusted formula, the independent expectation is 0.2689414214. This is a useful example of a bounded curve but not a claim about neural-network training, logistic regression software, classification probability calibration or PlanMaker’s native modelling tools. The formula combines PlanMaker’s documented TANH with elementary arithmetic. PlanMaker TANH.

When an output y lies strictly within (−1,1), the inverse relationship gives TANH(ATANH(y))=y. Enter A25=0.8, then B25:

=ATANH(A25)

Independently expected B25: approximately 1.0986122887. In C25, enter =TANH(B25); independently expected 0.8. This cannot be applied at y=±1, because SoftMaker documents ATANH as undefined at the endpoints. Do not treat exact displayed 1.000000 (possibly rounded from a smaller value) as a safe ATANH input without checking the underlying stored value. PlanMaker ATANH.

For any finite real x, TANH(x)=SINH(x)/COSH(x) mathematically. Set A29=0.6, B29=TANH formula, C29=ratio check; use formulas in B30 and C30 after placing A30=0.6:

B30: =TANH(A30)
C30: =SINH(A30)/COSH(A30)

Independently expected both results: approximately 0.5370495670. The functions SINH and COSH are separately referenced on SoftMaker’s TANH page. Compare the values within a tolerance appropriate to floating-point calculations, not by assuming identical last decimal or string formatting. Do not assume the ratio form is numerically safer at extreme inputs.

Versions, platform and compatibility evidence

PlanMaker 2026: SoftMaker’s current English reference documents TANH(Number) and TANH(0.45) ≈ 0.4219. PlanMaker 2024 and 2021: their separate English references document the same signature and example. These are documentation checks, not native runtime executions or claims about which version first supported TANH. No mobile edition, platform-specific build, subscription edition or native precision boundary was executed or benchmarked. 2026; 2024; 2021.

Regional input: The English numeric decimal period and function spelling are examples from the English documentation only. PlanMaker allows alternate numeric separators and documents localized function names. Do not invent a translation for TANH or promise an identical comma/semicolon formula syntax in every locale. Vendor settings; locale guidance.

Microsoft Excel: Microsoft’s TANH reference separately documents TANH(number) with comparable mathematical meaning. That is a reference-level compatibility finding only; Excel was not opened, and no .xlsx import/export, error-code, file-format, locale or numerical-equivalence test was performed. Excel is not evidence for PlanMaker behaviour.

Checked related documentation (October 13, 2026)

• SoftMaker PlanMaker 2026 — TANH: current signature and vendor example.
• SoftMaker PlanMaker 2024 — TANH and 2021 — TANH: historical manuals, not native tests.
• SoftMaker PlanMaker 2026 — ATANH: inverse with strict input domain.
• SoftMaker PlanMaker 2026 — SINH and COSH: hyperbolic identity cross-check.
• SoftMaker formula-entry instructions, numeric separator settings and localized function names.
• Microsoft Excel — TANH: separate application’s documentation only.

Official documentation read: October 13, 2026, PlanMaker English 2026, 2024 and 2021 TANH references; vendor formula/locale documentation; Microsoft Excel reference as a separate source. Independently calculated mathematical expectations are identified as such. Native PlanMaker tests: 0; Excel tests: 0; native screenshots: 0; import/export tests: 0.