View Single Post
  #4   Report Post  
Niek Otten
 
Posts: n/a
Default

I don't see what you mean. If the users enters nothing in C, Excel will
subtract B from A. Only if he enters something in C, then that will be used.
Do I miss something?

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Hector" wrote in message
...
That's a good idea. Though, I would like for the user to enter a value
only
in exceptions. This method would make the user do the calculation which
will
be more complicated.

Thanx.

"Niek Otten" wrote:

Why not use an extra column (C) and have this formula in D:

=IF(C1="",B1-A1,C1)

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Hector" wrote in message
...
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