Posted by Joseph Anthony on December 17, 2001 1:11 PM
Formula help please!
What I am trying to accomplish is A2 is if starting capital is e.g., $25000 when it doubles to $50,000 in whatever cell then I would reduce or withdraw by 1/2 of original capital ($12,500 in this example) and would continue future calculations from that point or 2*A2- 1/2 of A2.
2*$25000=$50000- 1/2 of original capital =$12,500.
Then future calculations, next cell would calculate from capital of $50,000 -$12,500 = $37,500.
Thank you in advance,