See attached picture for the detail:
Question: The output for column D, E, F should be using the number in column C * % starting from 100% all the way down to year of 21; however, the installed number in column C can happened in year 5,6, or any year, how to make the calculation in column D, E,F be more dynamic? For example, if there is installed amount 55 happened in year 5, how to write a formula in column D to make the number be calculated automatically in year 5
Question: The output for column D, E, F should be using the number in column C * % starting from 100% all the way down to year of 21; however, the installed number in column C can happened in year 5,6, or any year, how to make the calculation in column D, E,F be more dynamic? For example, if there is installed amount 55 happened in year 5, how to write a formula in column D to make the number be calculated automatically in year 5