Embedding a formula into a cell

[Jlitterio]

Okay, So here is goes.

I want to take two cells that calculate power in two different Units. Say A1 is measurements in watts, A2 is measurements in Amps.

I want to be able to enter a value in either cell and have the other cell display its value in its perspective unit.

A1 has a function of =IF(A2>0,(A2*120),0)
A2 has a function of =IF(A1>0,(A1/120),0)

I know this a circular reference and is easily solved.....

This is the part I can't get. I want to embed these two functions in the cells so that I can enter a value in one cell and the other cell will display the result. But, (1) if I delete the value, both cells will return to zero, -or- (2)If I enter a value into the other cell it will automatically change the other cell back to the embedded function.

Make any sense? Please help.

[alansidman]

Here is a short VBA solution. If both cells are empty, place a value in A2, put your cursor in A1 and run the macro.
Do the opposite for the other solution.

Please Login or Register  to view this content.

You could link this to a command button.