I am trying to set up a spreadsheet which will automatically work out the figure on entering the data in the appropriate cell and use this to calculate the other appropriate figure. e.g. when given a daily figure and enter this into the daliy cell location it will automatically work out the annual figure. There is no formula in the cell where it has been entered. I have attached a typical setup of the file i would be looking to create.



Just to give a bit mor background, i am looking to create a spreadsheet which will compare domestic energy supplies on a level playing field as the suppliers are changing the ways in which they quote prices, e.g. including tax excluding tax, daily standing charge, annual standing charge etc.

I have attached a file to show this

Any help appreciated on this.

Regards

Colin