Hi
I've a set a data with time in onle column and dta values in the others.
I would like to make a vb function that simultates a mathematical intergration, that is a vb function
Function integration(timerange as range, datarange as range,Result as double)
Could you help me out with this?
Please Login or Register to view this content.
But you don't need VBA. If the data is in A1:B10, thenPlease Login or Register to view this content.
=SUMPRODUCT( (A2:A10 - A1:A9) * (B1:B9 + B2:B10) ) / 2
... gives the same result.
Last edited by shg; 02-09-2009 at 01:58 PM.
Entia non sunt multiplicanda sine necessitate
Thanks a lot!.
How do I call the function within a button for example:
NumInt(sheet.??, sheet.??)?
What's the syntax for a range? in a function?
=NumInt(A1:A10, B1:B10)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks