Function Math Trig Complex Class

Secant

"Secant" Secant of a complex or real number. Inverse of the ASec function.

Signature (Visual Basic / VBA)

Public Function Secant( _
    ByVal vX As Variant _
    ) As Variant

Code Example

    Secant(-0.5) = 1.13949392732455
    Secant(0) = 1
    Secant(0.5) = 1.13949392732455
    Secant(1) = 1.85081571768093
    Secant(1.5) = 14.1368329029699
    Secant(2) = -2.40299796172238
    Secant(2.5) = -1.24821565146882
    Secant(3) = -1.01010866590799
    Secant(3.5) = -1.06785504719181
    Secant("2.3|-4.5") = "-1.48055525157198E-02|-1.65664869105198E-02"

Parameters

Parameter Description
vX Number whose secant is returned. Function returns Null if vX is Null or cannot be fixed up to a real or complex number (as defined by the ComplexStringToReals function). Complex numbers are represented within strings as "R|I" where R is the real part and I is the imaginary part.

Notes & Version History

Return The result is expressed in radians.
Note Microsoft named this function Sec within their Derived Math Function help topic.