Number.Sinh
NumberReturns the hyperbolic sine of a number.
Syntax
Number.Sinh(number as nullable number) as nullable numberParameters
| Name | Type | Required | Description |
|---|---|---|---|
number | number | Yes | The number whose hyperbolic sine is computed. |
Return Value
number — The hyperbolic sine of the number.
Remarks
Number.Sinh returns the hyperbolic sine, defined mathematically as:
sinh(x) = (e^x − e^(−x)) / 2
Unlike the circular sine function (which is bounded between -1 and 1), the hyperbolic sine is unbounded — it grows without limit as x increases. At x = 0, the result is 0, and for large positive x the result approaches e^x / 2.
The function is odd: sinh(−x) = −sinh(x), meaning it is antisymmetric about the origin. Hyperbolic functions do not take radians or degrees as input — they accept any real number.
Hyperbolic sine appears in physics (catenary curves, special relativity's rapidity), certain probability distributions, and engineering calculations. Together with Number.Cosh, it satisfies the fundamental identity cosh²(x) − sinh²(x) = 1. In everyday Power Query data transformation work, Number.Sinh is rarely needed.
Examples
Example 3: Verify odd symmetry — sinh(x) = -sinh(-x)
#table(
{"x", "sinh(x)", "sinh(-x)", "IsOdd"},
{
{2, Number.Sinh(2), Number.Sinh(-2), Number.Sinh(2) = -Number.Sinh(-2)}
}
)x | sinh(x) | sinh(-x) | IsOdd | |
|---|---|---|---|---|
| 1 | 2 | 3.63 | -3.63 | TRUE |