I've been using excel for some math analysis and came to a stop when I found that excel did not have an integration function
I'm not asking for anything fancy. Numerical integration using the trapezoidal rule would do.
I have some foggy ideas how to go about this. Here goes.
Write the integration function in qbasic(a primitive language but still good enough) then tell qbasic to make a file containing the data that is needed. Then excel SOMEHOW looks at this file and pastes the data into the cells.
Is there a better way?? or how does one implement the above method?
---
addition to this post
on this site i found somewhat of a solution to the probelm
http://www.stfx.ca/people/bliengme/E...UnderCurve.htm
but this is far too crude. That method uses up a great deal of cells. For my needs I could program that into excel right now but I would use well over 10,000 cells to do it. I want the value of the definite integral to be displayed in a cell, but that value is the result of the differance between lower and upper limit being divided into at least 100 intervals Of course that only applies if the original function can not be integrated by the elementary functions.
That is why I though of using Qbasic as sort of a quick and dirty way to do the hard core math behind excel's back and then just inserting the results into excel.
What about VBA?
Bookmarks