Seriessum is not quite it...need help, please

L

lizard2806

I am trying to find a formula that will take a sum of a series of powers
without having to use a load of IF statements. Here is what I need:

User inputs a positive number, y and excel a constant number, x, to calulate
the following:

X+X^2+X^3+X^4+....+X^Y.

It appears that series sum is not capable of doing this, as it adds another
factor to the equation, multiplying a times X, with a changing for each term.


Anyone have any ideas?

Thanks.
 
N

NHarkawat

use
=SUMPRODUCT(A2^ROW(INDIRECT("1"&":"&B2)))
where cell A2 = X and cell B2 = Y
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting Terms and Exponents of a Text Poly Formula ?? 4
need help with Formula 1
function returning SUM of 2 adjacent cols in 2 separate cells 7
Worksheet Formula Returning Sum of a Series 16
linking to formula template on different tab 0
Help - I've tried all kinds of things but no luck. 1
VLookup & Nested Functions 7
Need help graphing an equation 7

Top