ASEC function
Inverse secant function. ASEC(x) returns the inverse secant of x. The inverse secant function is the inverse function of the secant function and calculates the angle for a given secant. x must satisfy |x| ≥ 1 (i.e. x ≤ −1 or x ≥ 1). The result is an angle expressed in radians. To convert from radians to degrees, use the DEGREES function.
The argument x can be a real number or a matrix. When it is a matrix, the function returns a matrix with the same dimensions and with the ASEC function applied to all elements.
The inverse secant can be expressed in terms of the ACOS function:
$$ \operatorname{asec}(x) = \operatorname{acos}\!\left(\frac{1}{x}\right) $$
Examples
ASEC(1) equals 0
ASEC(−1) equals 3.1415927 (=PI)
ASEC(2) equals 1.0471976 (=PI/3)
DEGREES(ASEC(2)) equals 60