In this post from February a set of VBA trigonometric functions were presented, using the derivations given on the Microsoft Developer Network site:
Unfortunately two of the functions were wrong; the correct versions are shown below:
|Inverse Secant||Arcsec(X) = Atn(1 / Sqr(X * X – 1)) + Sgn((X) -1) * (2 * Atn(1))|
|Inverse Cosecant||Arccosec(X) = Atn(1 / Sqr(X * X – 1)) + (Sgn(X) – 1) * (2 * Atn(1))|
I have corrected the spreadsheet, which can be downloaded from: VBA Trig Functions
Does anyone know how I can notify Microsoft of the error?