Hi,

I've wondered this for a while.

Say cell A1 is Speed, B1 is Distance, C1 is Time.

I want to write a formula in each cell that is dependant on the value of the other two but I don't want the value I enter to overwrite the formula.

For eg. I want to calculate time so I enter values in the distance and speed cells. I then want to calculate speed so I delete what I previously entered in the speed cell and overwrite the answer it just gave me for time with my new value.

Is there a simple inbuilt function to do this?

Thanks

Rob