Anyone know of a way to integrate functions using Excel?

Discussion in 'Archived Threads 2001-2004' started by Bryce, Apr 29, 2002.

  1. Bryce

    Bryce Stunt Coordinator

    Joined:
    Mar 15, 2001
    Messages:
    61
    Likes Received:
    0
    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.
     
  2. Ben Osborne

    Ben Osborne Second Unit

    Joined:
    Mar 9, 2002
    Messages:
    475
    Likes Received:
    0
    I'm not sure what you mean by "integrating functions." Do you mean creating user-defined functions? If so then yes, it is possible using Visual Basic.
    Here's a good source for Excel questions:
    http://www.mrexcel.com/board/index.php
     
  3. Ken Situ

    Ken Situ Stunt Coordinator

    Joined:
    Aug 6, 2000
    Messages:
    102
    Likes Received:
    0
    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.
     
  4. Ben Osborne

    Ben Osborne Second Unit

    Joined:
    Mar 9, 2002
    Messages:
    475
    Likes Received:
    0
  5. DaveF

    DaveF Moderator
    Moderator

    Joined:
    Mar 4, 2001
    Messages:
    17,983
    Likes Received:
    1,545
    Location:
    One Loudoun, Ashburn, VA
    Real Name:
    David Fischer
    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.
     

Share This Page