Guys ,
I have a chain of 4 hotels say from b7 to b10. Each hotel will take certain no of years to construct. once construction is finished it will start generating revenue from next year.
Table 1 shows the construction period where 1= construction and 0=no construction.
Table 2 This table should be automatically updated once construction finished and it should start earning revenue i.e. 1= revenue and 0= no revenue
Table 3 This is what i am getting using if statement which is wrong. Revenue should continue instead of just one year as shown in table 3
Please advice where is problem in my formula. End result should look like table 2
[FONT=source_sans_proregular]You can sdownload the file from here https://mega.nz/#!s58GwRpI!dJnT4kTq2Iop9lS-xDM-g7bgtZz5YSTz1KbtsPehXiY
[/FONT]
I have a chain of 4 hotels say from b7 to b10. Each hotel will take certain no of years to construct. once construction is finished it will start generating revenue from next year.
Table 1 shows the construction period where 1= construction and 0=no construction.
Table 2 This table should be automatically updated once construction finished and it should start earning revenue i.e. 1= revenue and 0= no revenue
Table 3 This is what i am getting using if statement which is wrong. Revenue should continue instead of just one year as shown in table 3
Please advice where is problem in my formula. End result should look like table 2
[FONT=source_sans_proregular]You can sdownload the file from here https://mega.nz/#!s58GwRpI!dJnT4kTq2Iop9lS-xDM-g7bgtZz5YSTz1KbtsPehXiY
[/FONT]