Intergration in Excel

DaveWW00

New Member
Joined
Feb 3, 2006
Messages
40
Can somebody tell me if its possible to calculate integrals in excel?

I have a spreadsheet here at work that does the entire calculation set except for the step where we need to integrate. It would be nice to have excel calculate that step instead of us by hand.
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Damon Ostrander

MrExcel MVP
Joined
Feb 17, 2002
Messages
4,239
Hi DaveWW00,

Yes, it is possible to calculate integrals in Excel, but I do not believe there are any built-in functions to do it. You can do it by evaluating the function over the limits of integration as a worksheet table and summing the pieces and dividing by the dx using the trapezoidal rule for numerical integration or similiar higher-order methods.

It could also be accomplished via a user-defined function that would evaluate the function internally so that it wouldn't require worksheet space. The specifics of how to do this would depend on the nature of the functions you want to integrate (e.g., closed-form expressions, or tables of data), and the degree of flexibility you need (e.g., functions that never change vs functions that you are constantly modifying), etc.

Damon
 

Forum statistics

Threads
1,181,606
Messages
5,930,858
Members
436,764
Latest member
avalladarez

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top