Need help developing a formula

[ellsgei]

I'm using Excel to keep track of a small inventory, about 125-150 items. Most of the sheet is text data. But I was trying to develope a simple formula for the "Qty On-Hand" (cell C1) column based on the "Qty Sold" (cell B1) and "Qty Rcv'd" (cell A1) columns. The latter two columns (cells A1 & B1) would change as items are sold and new items received. But the "Qty On-Hand" (cell C1) always needs to show the 'true' quantity on hand.
Is this possible? Right now I feel like a dog chasing it's tail

 

[Ron Morris]

Hi,

Perhaps you will need a 4th column, make it colum A. Title - On Hand. You other columns will then shift over one place to the right and you can change column D to - Available Inventory.

In column D type =(A2+C2)-B2 in other words

On hand Inv. + Qty received - Qty sold = Qty Available

Hope this helps.

Ron