Question about Excel formula
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