# Intergration in Excel

#### DaveWW00

##### New Member
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
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

thanks!

Replies
0
Views
241
Replies
0
Views
222
Replies
0
Views
177
Replies
7
Views
2K
Replies
15
Views
1K

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

### 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.

### Which adblocker are you using?

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

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