Hi Guys,
So i have to create a column of numbers, where every sixth number needs to take the number above it and get multiplied by a cell that is fixed. After that this number needs to continue to be the same for 5 cells and then follow the exact same procedure as before.
So current formula looks something like this but now it wont automatically do that for the every sixth cell.
1
1
1
1
1
=$B$6*$F$2
=$B$6*$F$2
=$B$6*$F$2
=$B$6*$F$2
=$B$6*$F$2
=$B$11*$F$2
=$B$11*$F$2
=$B$11*$F$2
=$B$11*$F$2
=$B$11*$F$2
1
1
1
1
1
5
5
5
5
5
25
25
25
25
25
In essence the theory is that the rent of a house increases every 5 years by 5% or 10% or whatever.
I need to do this for a **** load of years but cannot figure out if there is any way i can do this automatically and not manually.
Your help would be really appreciated.
Bookmarks