Tags: calculation, cell, cells, equally, excel, formula, input, microsoft, msdn, number, obtain, reciprocal, software, via

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

On Microsoft » Microsoft Excel

1,489 words with 2 Comments; publish: Fri, 23 May 2008 00:54:00 GMT; (30678.13, « »)

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

All Comments

Leave a comment...

  • 2 Comments
    • Two possible solutions.

      1 - VBA without a formula in the cell. You can use the on change event to

      catch changes to one cell and then calculate the required value and put it in

      the other cell. Fairly straight forward to do but we will need a bit more

      info to hel you.

      2 - A bit of slight of hand using the Camera. Check out this link. (you will

      also need to use data validation to ensure only one cell is populated at any

      given time)

      http://j-walk.com/ss/excel/odd/odd04.htm

      --

      HTH...

      Jim Thomlinson

      "New user" wrote:

      > 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

      >

      #1; Fri, 23 May 2008 00:55:00 GMT
    • 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.

      --

      Regards,

      Bill Renaud

      #2; Fri, 23 May 2008 00:56:00 GMT