- Joined
- Oct 19, 2009
- Messages
- 1
- Reaction score
- 0
Hi
I am trying to integrate a formula like this
=F2/E2*(1-1/I2)^(A7-1) , where F2=40, E2=2000, I2=50 and A7= 1-150.
My question is if there is a formula in Excel which allows me to get the sum of the above equation for A7=1 to A7=150?
It is important that I am able to do it all in one equation, instead of just copying the formula 150 times and summing it all up in a separate cell.
Any help would be greatly appreciated.
Regards
Stefan
I am trying to integrate a formula like this
=F2/E2*(1-1/I2)^(A7-1) , where F2=40, E2=2000, I2=50 and A7= 1-150.
My question is if there is a formula in Excel which allows me to get the sum of the above equation for A7=1 to A7=150?
It is important that I am able to do it all in one equation, instead of just copying the formula 150 times and summing it all up in a separate cell.
Any help would be greatly appreciated.
Regards
Stefan