ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Integrals (https://www.excelbanter.com/excel-programming/314693-integrals.html)

brett4098[_2_]

Integrals
 

Is there a way to solve integrals in excel without incorporating the us
of VB code

--
brett409
-----------------------------------------------------------------------
brett4098's Profile: http://www.excelforum.com/member.php...nfo&userid=451
View this thread: http://www.excelforum.com/showthread.php?threadid=27228


Jerry W. Lewis

Integrals
 
Depends on what you are trying to do.

Excel has no built-in general calculus functions, but there are a number
of functions that calculate specific definite integrals, such as ERF(),
ERFC(), and *DIST() cumulative continuous probability distribution
functions.

Jerry

brett4098 wrote:

Is there a way to solve integrals in excel without incorporating the use
of VB code?



Paul Robinson

Integrals
 
Hi Brett
You should be able to implement the Trapezoid or Simpson's Method in
Excel pretty easily using tables and simple worksheet functions (you
probably only need Sum).
Look in any Engineering maths book - they might even show you how it
is done in Excel.


regards
Paul

brett4098 wrote in message ...
Is there a way to solve integrals in excel without incorporating the use
of VB code?



All times are GMT +1. The time now is 09:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com