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?
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
Very many thanks in advance
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
"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
> 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.
Bill Renaud#2; Fri, 23 May 2008 00:56:00 GMT