I want to do the following.
I want to add X + X (the same again) + a Growing multiply-able % of the same X.
Then the Result of this + X (the same) + double the % of X.
So if i got 100 as X
The a cell adds 100+100 + say 5% of 100 = 200 + 5 = 205
However for the next cell i want this to add the result + 10% instead of 5% of the 100.
So far I can do it by saying =CELL + (SAMECELL*1.05)
But that way i have to tweak the current modifier (1.05 [5%]) for every cell.
I bet there is a fancier way of doing that...
Anyone?
P.S.
Solutions:
1. See Ben's example in post 2.
2.
Here's the entire thing so anyone can recreate it:
C18 is 100 (Base number)
B18 is 20 (the %)
D18 is =C18*B18% (that shows you how much 20% is off 100)
C1 =C18
C2 =(C1+C$18)+ROWS(C$2:C2)*D$18
C3 =(C2+C$18)+ROWS(C$2:C3)*D$18
C4 =(C3+C$18)+ROWS(C$2:C4)*D$18
C5 =(C4+C$18)+ROWS(C$2:C5)*D$18
C6 =(C5+C$18)+ROWS(C$2:C6)*D$18
However if you don't want a cell to view the result you get off your Base and % you can skip it by replacing the last bit *D$18 with *(C18*B18%) and that is that.
Rows counts the number of cells in a specified range, in this case from A4 to A21. Depending on which of the two cells on the end of the range you lock, the formula auto adjusts to count 1 more or less cell in each following cell you paste it. Allowing you to work with both exponential increase or decrease.
And as Ben was said you add a $ when you want the cell numbers to stay fixed from auto adjustment when you paste formulas elsewhere.
Bookmarks