Where do I start - Formula

[Julian Campbell]

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

 

[Gilles Desjardins]

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

 

[CLR]

In cell D1 put........

=(B1+C1)-A1

Vaya con Dios,
Cuck, CABGx3

 

[Ron Rosenfeld]

If C Is more or less than the required balance, I want the variance figure
to be shown in another Cell (E)

Assuming your cells are in Row 1, in E1 place the formula:

=IF(D1<>0,D1,"")


--ron