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. |