| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reducing Quantity When an Item is Sold
I am struggling to find what I think should be a very simple formula to
automatically reduce the Quantity when an item is sold. I have several columns with formulas to calculate different tasks: Retail Price Our Cost Net Quantity Sold Total COG Inventory Amt. $18.00 $7.00 $11.00 4 1 $18.00 $7.00 $28.00 What I would like to do is when I sell an item and mark the amount Sold, it automatically deducts from the Quantity that I have in stock. So by marking 1 in the Sold Column, it would make the Quantity 3. I have been doing this manually because I haven't figured out a formula to make this work. Any help would be greatly appreciated. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Numeric Rank By Qty Sold | Excel Discussion (Misc queries) | |||
| Item numbers result in item description in next field in Excel | Excel Worksheet Functions | |||
| keep track of gift certificates sold | New Users to Excel | |||
| Need formula to count number of books sold | Excel Worksheet Functions | |||
| How I type SOLD across column length without changing current data | Charts and Charting in Excel | |||
Threaded Mode
