Average Cost for Inventory

Hoping someone can help me with this - I am attaching an excel spread sheet with the results that I need and I am having a problem coming up with an IF function for the Inventory On Hand Column as when you either purchase inventory or you sell it, the avaerage cost will change. Any help would be much appreciated.