Summation of a formula

[aloha31]

I'm trying to create a VBA code that calculates the summation of 1/[i*(i+1)] for i=1 to infinity and shows a message box when the term causes a change less than 0.0001% (one millionth).

Thanks for the help!

-Chad

[mikeTRON]

Can you not solve this with Goalseek?

This can get you started, I'm not exactly sure what you are trying to accomplish.

Please Login or Register  to view this content.

[aloha31]

I'm just trying to practice my For loops for the time being. Also, I apologize for not explaining more accurately. The code you provide looks correct except for the fact that each term (we'll call it test) should be added to the previous test to keep a cumulative sum. Then when cumulative sum i and cumulative sum j are less than one millionth % different, the code should stop. Thank you again for your time.

[aloha31]

Here's what I have so far:

Please Login or Register  to view this content.

My CumSum isn't performing correctly because I don't know how to keep a running sum of each term.

[mikeTRON]

You are correct, I didnt quite grasp your need, but I think I updated it appropriately above.

[aloha31]

Thanks a ton Mike! I was on the verge, that was exactly what I was looking for!

On a side note, good to see another person from Dallas on here! Have a great night.

[mikeTRON]

Sure. No problem. My VBA is not very developed so it's nice to be able to solve something for once haha.

Keep in mind it is ideal to use option explicit and declare every variable vs allowing everything to be a variant like I have done above.