Hi Guys
Need some help on the following.
I have in the attached spreadsheet in column C capital spend for 3 years. I need a formula in cell D4 which basically says if spend for the total 3 years is above 2.5m than choose value in cell c9 but delay it by one year so that the higher value appears in cell e4 and d4 still has the lower value. So a kind of a delay. Also within that formula even though the total for the 3 years is above 2.5m year 1 still has only 500k which is lower than the 2.5m hence the value in cell d4 should only be 34. BUt the formula needs to be flexible incase i change the amount.
I have tried to manually to insert it in the spreadsheet but hoping someone can help me come up with a formula
Cheers
Raj
Need some help on the following.
I have in the attached spreadsheet in column C capital spend for 3 years. I need a formula in cell D4 which basically says if spend for the total 3 years is above 2.5m than choose value in cell c9 but delay it by one year so that the higher value appears in cell e4 and d4 still has the lower value. So a kind of a delay. Also within that formula even though the total for the 3 years is above 2.5m year 1 still has only 500k which is lower than the 2.5m hence the value in cell d4 should only be 34. BUt the formula needs to be flexible incase i change the amount.
I have tried to manually to insert it in the spreadsheet but hoping someone can help me come up with a formula
Cheers
Raj
Attachments

9 KB Views: 4