Automultiply

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[AlfD]

Hi!

But you can if you use VBA.

Is this what you want?

Example: A1 holds 1000.
You click on A1 and enter 2
A1 now shows 2000

Al

 

[Guest]

Hi,
Yes, you are correct. Though I don't know VBA. Please explain me how to
accomplish my request. Suppose a container holds 2000 cartons and 5
containers equal how much. So, when i enter 5 the result will be 10,000..
Just out of curiosity I am looking for this..

Thanks..john britto

 

[Sandy Mann]

John,

You will know best, but are you sure that that is what you want? You will
end up with 10,000 in the cell and no trail to tell you how that figure was
arrived at. Would you not be better to use more than one cell so that the
result will be more meaningful.

--
Regards


Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk