Thread: Keep relationship between 2 cells that both accept data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Arun Arun is offline
external usenet poster
  
Posts: 103
Default 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?
Reply With QuoteReply With Quote