Filling in cells based on 2 other cells data
I need to figure out how to enter data fro column b and then subtract that from column a and enter the new value, then keep that going to formulate each days target for the whole month
So if cell a1 is 105 and b1 has a goal of 33 a day then c1 is 33.
Then c2 and c3 would need to also be 33
Then c4 would be the 6 remaining plus the goal from b2
So a2 would be 19 and b2 would be 27
And so forth
|