Need help with formula in Excel XP

D

Danchops

I'm trying to create a formula in a cell that, given x, y, and n in
other cells, calculates x*y + (x*y)*y + ((x*y)*y)*y + (((x*y)*y)*y)*y
.... n times. Anyone know how to do that?

Any help is greatly appreciated.
 
R

ramana

Hi,

Your problem seems to be sum of geomeric expression.

Looking into your question we can take x as a common factor and the
equation can be written as X*(y+y^2+y^3+......+y^n).

Say in cell A1=X
Cell B1=y
Cell C1=n
now youcan write the formula as =A1*((B1^(C1+1)-1)/(B1-1)+1)

Hope that this might solve your problem.

Thanks and Regards

Ramana
 
R

ramana

Err... just a small correction i kept +1 instead of -1.
Now notedown the formula.

=A1*((B1^(C1+1)-1)/(B1-1)-1)

where ^ denotes to the power of and to get this Press Shift+6 and then
press space.

rgds

Ramana
 
R

Ron Rosenfeld

I'm trying to create a formula in a cell that, given x, y, and n in
other cells, calculates x*y + (x*y)*y + ((x*y)*y)*y + (((x*y)*y)*y)*y
.. n times. Anyone know how to do that?

Any help is greatly appreciated.
Click to expand...


Try this:

=x*SUMPRODUCT(y^ROW(INDIRECT("1:" & n)))

Substitute numbers or cell references for x, y and n


--ron
 
Top