Sold item in column E
Quantity in column D
In D2: =4-E2

"Tami" wrote:

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.