Forum Discussion
Automatically calculate values
Is there a way to make the "WHAT YOU WILL NEED TO RUN" update to equal 6 based off values put into actual tpph?
brianf00 If this is what you need....
The formula in C4 is =IF(B3=0,C2,B2-B3+C2)
Copy it to D4:H4
So I assume this is a manufacturing schedule. Projected is what was planned. Actual was what was made. If we were projected to make 6.25 on Wed, but we only made 6, we will need to make 6.5 on Thu. to catch up.