Forum Discussion
Value in cell calculated on previous cell value
In this case we are using the same COEF for the rest of the year. Such as for August we will multiply forecasted value for July and COEF that calculated in actual month. In other words we consider that the COEF will remain the same for the rest of the year.
So you are basically leaving the rest of the 0M Column blank and calculate everything using C16 and C6. Is that right?
Not exactly. The column C for blank cells is calculated using the values from the column B and Fixed coefficient. I have made alterations in the post to clarify this and some more explanations.
Then we use real value from previous month in C (C6) to calculate forecatsed value in D in the next month (D7), also we using forecated value for the next month in C(C7) to calculate forecasted value in D in two months (D8) etc.