How to use a cell that can have both a formula or a directly entered value. Specifically I'm trying to have one first cell to enter an english unit of measure and the metric formula conversion in a second cell; while also being able to enter a metric value in the second cell and convert to english units in the first cell. This requires each of the two cells to have either a directly entered value or a formula, perhaps using some sort of switching mechanism.