Copy user input in real time

  • Hello, what I would like to be able to do is as the user inputs values in the form of probabilities I would like the corresponding 1-probability entered onto the corresponding cell on a seperate sheet. For example, if the user was to input 0.2 in cell a1 on sheet1, I would like cell a1 on sheet2 to display the answer to =1-0.2. I hope this makes sense. Thankyou.