Hi,

I apologize if I haven't understood your posting correctly.

You can not enter a number in a cell and expect the SAME cell to hold
another value and also a formula (that would multiply the original and the
newly entered numbers and show the outcome). The two numbers and the result
have got to reside in different cells.

If A1 and B1 contain 1000 and 2 respectively, enter the following formula in
C1.
=A1*B1
and click 'ENTER'.

The contents of A1 and B1 can be changed, and C1 will get updated accordingly.

Once again, my apologies if I didn't understand your posting properly.

Regards,
B. R. Ramachandran

"John Britto" wrote:

Dear All,
Is it possible to set a value in a cell and that value be multiplied when i
enter a number.
Eg: a cell must hold a value 1000, so when i enter 2 the result should be
2000 and if the cell holds a value 15 and when i enter a number say 5 the
result must be 75 and so on. Any suggestion please