Use two cells:

Say in Z100 we usually have =A1/B1, but sometimes we want a manual value
instead. In Z100 enter:

=IF(B9="",A1/B1,B9)

so if B9 is empty, the formula is used. If B9 has a value, the value is used.
--
Gary''s Student - gsnu200753


"Jean9" wrote:

Hello,

I've programmed my worksheet to automatically calculate a number but
sometimes we have to enter a manual number. Is it possible to input a manual
number yet still be able to keep the programmed calculation for the same cell?

Jean9