Formula

[Angela]

Hi everyone,
I am sure the answer is simple, but I think I have Monday morning lock
brain. LOL

This is what we want to do at my company. We have a spreadsheet that we use
to order plants. What we want is to have have the sheet figure how much open
stock we need to order based upon set levels.

Ex. For a particlar order we want to order 6" pothos. Dept A needs 10, Dept
B needs 25, Open stock currently has 4. When the order is recieved, we need
to have 50 in Open Stock. (So we would need to order 81). (

I would like to write a formula to do that so someone doesn't have to
manully figure it out. Currently we have the dept columns, an open stock
column, and a total column (just summing the dept fields minus open stock
field.) I know I will need to add another column for on hand qty levels.
But then, how do i write the formula?

Thanks for your help!!!

Angela

 

[Dave F]

Well, if you have 4 on hand and need to order 81 then you you have a total of
85.

85 = X + Y + Z where X is the 4 on hand and Y and Z are the amounts you want
in Dept A and B respectively.

So the formula you're looking for would be, for example, =A1+B1+C1 where
column A could be the amount you have on hand, column B could be the amount
you want in Dept. A, and column C could be the amount you want in Dept. B.

Hope that helps.

Dave

 

[aarif]

Hi Angela,

Column
A1 B1 C1 D1
E1
DEPT. A DEPT. B OPEN STOCK OPEN STOCK NEEDED ORDER TO PLACE
10 25 4 50
81

Try this,
Formula is =sum(A1:B1)-C1+D1

Aarif