Anyone know of a way to integrate functions using Excel?

Bryce

Stunt Coordinator
Joined
Mar 15, 2001
Messages
61
I've searched the help topics but can't seem to find any information on whether or not the program is capable of it. This would help me tremendously by saving me the time it take to enter it into a calculator repeatedly and run the risk introducing multiple errors into my final answer.
 

Ken Situ

Stunt Coordinator
Joined
Aug 6, 2000
Messages
102
Integration is no more than a sum - implement the function with the results for each interval, and sum them up should give you the result.

As noted above, you can always use VBA to code the function.
 

DaveF

Moderator
Senior HTF Member
Joined
Mar 4, 2001
Messages
23,872
Location
Catfisch Cinema
Real Name
Dave
What sort of function are you integrating? It might be simpler and more accurate to integrate if analytically, and then numerically evaluate the result in Excel or whatever.

Another option is to use symbolic math program, like Mathcad or Mathematica.
 

Forum Sponsors

Forum statistics

Threads
345,204
Messages
4,734,010
Members
141,407
Latest member
An Elvis Fan