Inventory Formula

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

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
 
Your welcom, don't worry it happens to me sometimes, when I am so
concentrated in something I don't see what is supposed to be obvious
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format part of text in concatenated field 4
Copying formulas across columns 2
how do I create a nonadjacent series for autofill to go by? 3
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula 2
Round Up/Down ? 2
Formula Problem For Checkbook Register 1
sumproduct _zafar 11
IF Function 3

Back
Top