The range of values are not in the worksheet itself. Let me give more
details on what I want to do.
My problem: I'm trying to calculate the number of rows that will be stored
in a data warehouse fact table over a period of time. My assumption is that
I will be starting with "X" number of rows that will be stored the first
week, and that every week we will be adding another bunch of "X" rows, but
"X" will be growing by approximately 1% every week.
For example, lets say "X" is 1,000,000 rows and I want to calculate how many
rows will be stored over 6 weeks.
Week 1: 1,000,000
Week 2: 1,010,000
Week 3: 1,020,100
Week 4: 1,030,301
Week 5: 1,040,604
Week 6: 1,051,010
So my sum after 6 weeks would be: 6,152,015
I have two numbers stored in two cells of the worksheet:
Cell A1 = X = "starting" number of rows
Cell A2 = Y = number of weeks to calculate for
So the formula that I want to sum is "=INT(A1*(POWER, 1.01, n-1))", where n
ranges from 1 to A2.
I don't want populate "n" number of cells and then just sum them up because
"n" can get quite large, and I want to quickly be able to model the effects
of changing the value of "n" for different fact tables.
Hopeully this sheds more light on exactly what I'm trying to do.