The Excel IMCSCH function returns the hyperbolic cosecant of a complex number. Given "1+1.5707963267949i" as input, the function returns "-1.72324E-15-0.648054274i" as output.
=IMCSC(COMPLEX(1, PI()/2)) // returns -1.72324E-15-0.648054274i
The Excel IMCOSH function returns the hyperbolic cosine of a complex number. Given "1+1.5707963267949i" as input, the function returns "-5.4E-15+1.175201i" as output.
=IMCOSH(COMPLEX(1, PI()/2)) // returns -5.4E-15+1.175201i
When the...Read more
The Excel ATANH function returns the inverse hyperbolic tangent of a number. Given 0.5 as input, the function returns 0.549306144 as output.
=ATANH(0.5) // returns 0.549306144
The hyperbolic arc tangent function...Read more
The Excel ACOSH function returns the inverse hyperbolic cosine of a number. Given the input 2.0, the function returns the value 1.316957897.
=ACOSH(2) // returns 1.316957897
Given the x-component of a...Read more
The Excel COTH function returns the hyperbolic cotangent of a hyperbolic angle. Given 1.00 as input, the function returns 1.313035285 as output.
=COTH(1) // returns 1.313035285
The Excel SECH function returns the hyperbolic secant of a hyperbolic angle angle. Given 2 as input, the function returns 0.265802229 as output.
=SECH(2) // returns 0.265802229
The Excel CSCH function returns the hyperbolic cosecant of an angle. Given the hyperbolic angle of 1, the function returns 0.850918128 as output.
=CSCH(1) // returns 0.850918128
The Excel IMSINH function returns the hyperbolic sine of a complex number. For example, given 1+π/2i as input, the function returns -4.10319E-15 + 1.543080635i as output.
=IMSINH(COMPLEX(1, PI()/2)) // returns -4.10319E-15 + 1.543080635i...Read moreThe Excel IMCSC function returns the cosecant of a complex number. For example, given "4+3i" as input, the function returns "-0.075489833+0.064877471i" as output.
=IMCSC("4+3i") // returns -0.075489833+0.064877471i
In...Read more