Need help developing a formula

ellsgei

New Member
Joined
Dec 6, 2005
Messages
1
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 :eek:
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Ron Morris

Active Member
Joined
Oct 18, 2004
Messages
430
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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,760
Messages
5,574,080
Members
412,566
Latest member
TexasTony
Top