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