VBA中的数学公式

Table 3-5. Visual Basic math functions General
Abs Exp Fix Int Log
Rnd Sgn Sqr   
Trigonometric
Atn Cos Sin Tan
Financial
DDB FV IPmt IRR MIRR
NPer NPV Pmt PPmt PV
Rate SLN SYD   




Table 3-6. Derived math functions Function Formula
Secant (Sec) 1 / Cos(x)
Cosecant (Cosec) 1 / Sin(x)
Cotangent (Cotan) 1 / Tan(x)
Inverse Sine (Arcsin) Atn(x / Sqr(-x * x + 1))
Inverse Cosine (Arccos) Atn(-x / Sqr(-x * x + 1)) + 2 * Atn(1)
Inverse Secant (Arcsec) Atn(x / Sqr(x * x - 1)) + Sgn((x) - 1) * (2 * Atn(1))
Inverse Cosecant (Arccosec) Atn(Sgn(x) / Sqr(x * x 1))
Inverse Cotangent (Arccotan) 2 * Atn(1) - Atn(x)
Hyperbolic Sine (HSin) (Exp(x) - Exp(-x)) / 2
Hyperbolic Cosine (HCos) (Exp(x) + Exp(-x)) / 2
Hyperbolic Tangent (HTan) (Exp(x) - Exp(-x)) / (Exp(x) + Exp(-x))
Hyperbolic Secant (HSec) 2 / (Exp(x) + Exp(-x))
Hyperbolic Cosecant (HCosec) 2 / (Exp(x) - Exp(-x))
Hyperbolic Cotangent (HCotan) (Exp(x) + Exp(-x)) / (Exp(x) - Exp(-x))
Inverse Hyperbolic Sine (HArcsin) Log(x + Sqr(x * x + 1))
Inverse Hyperbolic Cosine (HArccos) Log(x + Sqr(x * x - 1))
Inverse Hyperbolic Tangent (HArctan) Log((1 + x) / (1 x)) / 2
Inverse Hyperbolic Secant (HArcsec) Log((Sqr(-x * x + 1) + 1) / x)
Inverse Hyperbolic Cosecant (HArccosec) Log((Sgn(x) * Sqr(x * x + 1) + 1) / x)
Inverse Hyperbolic Cotangent (HArccotan) Log(x + Sqr(x * x - 1))
Logarithm to base N (LogN) Log(x) / Log(n)