Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
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 -- Brevity is the soul of wit. "Angela" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
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 "Angela" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |