I am trying to make a spreadsheet that does a calculation from input data. I would like to be able to write data into any one of three cells depending on which source I get it from. The problem is that the data can come in three different values depending on their source. There is a mathematical formula to convert between the 3 values. I would like to have 4 cells, 1 for each of the 3 values and the 4th cell for the output calculation. What I would like to be able to do is enter the data into any one of the three cells, the other two cells would then calculate the value into their own style value.

e.g. 5/1 , 6.000 , 500 are the three styles but are all the same for my further calculations.

So if I entered 5/1 in cell A1, cells A2 and A3 would display 6.000 and 500 respectively.

If I then entered 6.000 in cell A2, cells A1 and A3 would display 5/1 and 500 respectively.

How do I do this?