| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inventory Formula
I'm trying to keep track of inventory using Excel. In B2, I have Initial
Quantity. Then I have to issue inventory to 4 different departments. So, cell C2 is dept. A, D2 is dept. B, E2 is dept. C, F2 is dept. D. If my initial qty. is 500, then I issue 25 to each dept. my remaining inventory should be 400. In cell G2, I have =SUM(C2:F2)-B2. It's returning a -400 and it should be positive 400. What is going on here? Any help would be greatly appreciated. Thank you, Karen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel IF Formula for an inventory... | Excel Discussion (Misc queries) | |||
| Formula needed for too much inventory | Excel Worksheet Functions | |||
| inventory comparison formula?? | Excel Worksheet Functions | |||
| Need help with a formula in inventory | Excel Discussion (Misc queries) | |||
| How can i get an inventory list that adds and subtracts inventory | Excel Discussion (Misc queries) | |||
Threaded Mode
