Thread: Automultiply
View Single Post
  #2   Report Post  
Sloth
 
Posts: n/a
Default

You can't do it the way you are describing, but you can type a number in a
dummy cell then copy and paste special and select multiply.

Just out of curiosity, why don't you want to use a formula? For example...

A1=1000
B1=2
C1=A1*B1
C1 outputs 2000

"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