Hi,

Try this
Assuming Receiving begins at B3, and Shipped in C3, Current inventory
beginning balance in D2
Formula in D3: =D2+B3-C3
Copy down as needed
Hope this helps.

Dave


"Jackie" wrote in message
...
if there's a # in the "Qty. Received" cell then I want it to add to the
"Current inventory" cell but if there's a # in the "Qty. Shipped" cell
then I
want it to subtract it........how can i seperate these functions in 1
formula
so it will do either 1 or the other?