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.
Re: Copy user input in real time
In the formula for A1 on Sheet2, can you just use the formula:
And similar formulas for the rest of the range that they input probabilities for?