How do I set up two cells with a reciprocal formula?

N

New user

I would like to be able to input a number into Cell 1 and obtain a
calculation in Cell 2 via a formula and equally input a number into Cell 2
and obtain the reciprocal in Cell 1 via the same formula whilst guarding the
formula.

Very many thanks in advance
 
B

Bill Renaud

Put a value in Cell1.
Put the formula in Cell2.
Putting a value in Cell1 works as normal.
To force Cell2 to a value, select Cell2, but then use Tools|Goal Seek to
set the value of Cell2 to the desired value by changing Cell1.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top