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