| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keep relationship between 2 cells that both accept data
I swear I saw someone who posted a trick to accomplish this...
I want the value in cell A1 to always be twice the value in A2, but I want to be able to enter data into either cell (not a formula). For example, I type a 2 in cell A1 and A2 returns a 1. I then type 3 into cell A2 and A1 returns a 6. Is this possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excell cells in worksheet will not accept new formatting. Help | Excel Discussion (Misc queries) | |||
| Excel chart source data y-values can only accept 7 data pts? | Charts and Charting in Excel | |||
| Charting the relationship between two cells | Charts and Charting in Excel | |||
| Cells won't accept specific text | New Users to Excel | |||
| Format cells to only accept numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
