1. Sign-up to become a member, and most of the ads you see will disappear. It only takes 30 seconds to sign up, so join the discussion today!
    Dismiss Notice

Anyone know of a way to integrate functions using Excel?

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

  1. Message #1 of 5 Apr 29, 2002
    Bryce

    Bryce Stunt Coordinator

    Joined:
    Mar 15, 2001
    Messages:
    61
    Likes Received:
    0
    Trophy Points:
    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. Message #2 of 5 Apr 29, 2002
    Ben Osborne

    Ben Osborne Second Unit

    Joined:
    Mar 9, 2002
    Messages:
    475
    Likes Received:
    0
    Trophy Points:
    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. Message #3 of 5 Apr 29, 2002
    Ken Situ

    Ken Situ Stunt Coordinator

    Joined:
    Aug 6, 2000
    Messages:
    102
    Likes Received:
    0
    Trophy Points:
    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. Message #4 of 5 Apr 29, 2002
    Ben Osborne

    Ben Osborne Second Unit

    Joined:
    Mar 9, 2002
    Messages:
    475
    Likes Received:
    0
    Trophy Points:
    0
  5. Message #5 of 5 Apr 30, 2002
    DaveF

    DaveF Moderator
    Moderator

    Joined:
    Mar 4, 2001
    Messages:
    21,922
    Likes Received:
    3,542
    Trophy Points:
    9,110
    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.
     
(You must log in or sign up to post here.)

Share This Page