Hi,
My colleague is trying to create a 3 tiered table of energy usage, it has the following columns: 1st column has Green, Amber and Red. The 2nd has Usage and the 3rd is %. He wants it so that when the usage is changed in the red or the amber row, the difference it is changed by will affect the row above by the difference. The formulas that are already in use in the rest of the columns will change too. I have attached a basic display of what i mean.
Capture.PNG
Thanks in advance.
Dan.
Bookmarks