| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 formula. Very many thanks in advance |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I set up two cells with a reciprocal formula?
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Non reciprocal formula? | Excel Discussion (Misc queries) | |||
| How do I set up two cells with a reciprocal formula? | Excel Programming | |||
| trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
| Copy a formula to a range of cells via VB6 using .Range(Cells(row,col), Cells(row,col)).Formula= statement | Excel Programming | |||
| Reciprocal range? | Excel Programming | |||
Hybrid Mode
