In cell D1 put........
=(B1+C1)-A1
Vaya con Dios,
Cuck, CABGx3
"Gilles Desjardins" wrote in message
.. .
In D type the following formula: =(A-B)-C .
Always start a formula with an equal sign. The result (positive or
negative)
will show up in D.
HTH
"Julian Campbell" wrote in message
...
I am trying to simplfy my job as a production planner.
I have a spreadsheet with various amounts to be added, But my main
problem
is this.
In cell A, I input a figure (My daily production requirements) 10000
In cell B, I input a figure (Materials on site to be used) 5000
In cell C, I input a figure (Materials being delivered by a supplier)
5000
So in cell D I can now show a balance required ( A - B -C = 0 )
But What I want to know is this
If C Is more or less than the required balance, I want the variance
figure to be shown in another Cell (E)
Eg; A = 10000
B = 5000
C = 7000
D = 2000
OR A = 10000
B = 5000
C = 3000
D = -2000
I hope this makes sense and thanks for any help
|