integral calculus

[ryan glenn]

hi guys...

i would like to solve some integral calculus in the vba of excel...
do anybody know what is the vba codes for the integral...
please...
thanks in advance..

 

[Bernard V Liengme]

AH Ryan,
If only it was that easy! That type of ease is found only with real math
programs like Mathematica. In a spreadsheet you have to do some work. To
fins the value of an definite integral use the trapezoid or Simpson rule.
See www.stfx.ca/people/bliengme (Excel Tips) for ideas. If you are serious
you will need a book such as the one listed on my website.
Bernard

 

[Harlan Grove]

...
...

. . . use the trapezoid or Simpson rule. . . .

...

What, no adaptive quadrature?

Another site to peruse,

http://www.nag.com/numeric/cl/manual/html/indexes/kwic/quadrature.html