How to compute compound interest but with changing interest rates?

Hi, I have one large file and I need to compute the final value of investing a particular amount based on the returns given by the stock market. I'm trying to figure out a way that I can compute the answer without going into cell after cell with the same kind of formula. The formula that I'm looking for is like the formula for a compound interest. I.e. Final value = P(1+r)^n. However, in my case, r is always changing and hence P is also changing as well. What I'm currently doing is typing the same kind of formula into each cell. For example to find the year-end value I input: 1000(1.05) then the next year, the year-end value is this: (1000)(1.05)(1.10), and the next may be (1000)(1.05)(0.96)...and so on....does anyone know of a simpler way to do this?

If A1 is the original principal, and int is the range that contains the interest rates for each period, then this array formula (confirmed with Ctrl+Shift+Enter, not Enter) computes the result:

= A1 * PRODUCT(1 + int)

Hi, thanks! I have one more question, however, how do I apply a operand function to an entire column?

Sorry, I don't understand the question.

In general, many functions do not allow the use of an entire column -- and you usually wouldn't want to. That's what dynamic named ranges are for.