Forum Discussion
Equation to transfer the difference to the next cell
Hi all
I want your help regarding the following:
If I have a target to be achieved on a weekly basis, for example, in field A1 = 126
Actually verified = 100 I want the difference to be transferred to the required field in the next week so that A2 = 152
3 Replies
In the screenshot below, the 'fixed' target 126 is in E1.
The formula in A2 is simply =E1
The formula in A3 is =$E$1+A2-B2
This can be filled down.
- There is something I did not mention, which is that the number 126 is the result of an equation, as it is the division of the total number by the weeks. For example, I have in the field E3 1263, so the field A1 contains the following equation = (E3 /10)
