Calculate to another cell as default value
Hi.
Given the following:
A B C
1 5 9 __
2 8 10 __
I'd like for the user to enter values in A and B and have Excel display B
minus A in C as a DEFAULT value. That is, for row 1, once the user enters 9
in B, I want to display 4 in C but give the user the option to override the
calculation. A formula in C won't work because the user would delete the
formula if he overrides it.
Thanx.
I don't
|