On Fri, 7 Oct 2005 22:46:51 -0500, Danchops
wrote:


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.


Try this:

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

Substitute numbers or cell references for x, y and n


--ron