Hi All,
I wondered if anyone can help me with a simple formula to automatically input activity cost data on the basis of frequency intervals.
Below is a simple example the cells in green are input by the user, the yellow ones I would like to be calculated by a formula.
<tbody>
</tbody>
I wondered if anyone can help me with a simple formula to automatically input activity cost data on the basis of frequency intervals.
Below is a simple example the cells in green are input by the user, the yellow ones I would like to be calculated by a formula.
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q |
1 | Activity | 1st year | frequency (years) | cost | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 |
2 | paint wall | 2018 | 1 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 |
3 | replace flooring | 2019 | 10 | 10000 | 10000 | 10000 | ||||||||||
4 | replace boiler | 2018 | 10 | 5000 | 5000 | 5000 |
<tbody>
</tbody>