Hi
This is re. Stock control with spreadsheet. I have been trying to create an excel formula that will be applicable for all the scenarios given below:
Scenario 1
Opening Stock………………………..10
Receipt to Store 1…………………200
Orders from members…………500
Dispatch to members…………210
Closing Stock at Store 1
Correct Answer…………………….-290
Scenario 2
Opening Stock…………………………0
Receipt to Store 1…………………….100
Orders from members……………..50
Dispatch to members……………..50
Closing Stock at Store 1
Correct Answer………………………..50
Scenario 3
Opening Stock………………………..20
Receipt to Store 1……………………50
Orders from members……………100
Dispatch to members………………70
Closing Stock at Store 1
Correct Answer………………………..30
Scenario 4
Opening Stock…………………….50
Receipt to Store 1………………..100
Orders from members…………50
Despatch to members………..50
Closing Stock at Store 1
Correct Answer……………………100
Scenario 5
Opening Stock…………………….-150
Receipt to Store 1…………………100
Orders from members………….50
Despatch to members………..100
Closing Stock at Store 1
Correct Answer……………………-100
Trust I am clear. I am looking for help in arriving at ONE formula for all the above to arrive at the Closing Stock at Store 1
cheers
Kris