How do you format a cell to automatically multiply entry times 2?

  • Thread starter Thread starter HL Charts
  • Start date Start date
H

HL Charts

I want to be able to have a set of cells be automatically multiplied times 2.
For exampls, if I type in 2 in the cell, I want it to show up as 4 in that
cell. Is this possible?
 
Hi,

Only if you write a VBA macro. And then the issue would be which cells do
you want the macro to run for? For example if you enter a date, Excel thinks
its a number so would you really want to multiply a date by 2.
 
HL said:
I want to be able to have a set of cells be automatically multiplied times 2.
For exampls, if I type in 2 in the cell, I want it to show up as 4 in that
cell. Is this possible?
Click to expand...

If you want to put 4 in a cell instead of 2, why don't you just type 4,
he asked facetiously. <g>

Bill
 
Shane Devenshire said:
Hi,

Only if you write a VBA macro. And then the issue would be which cells do
you want the macro to run for? For example if you enter a date, Excel thinks
its a number so would you really want to multiply a date by 2.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"HL Charts" wrote:

> I want to be able to have a set of cells be automatically multiplied times 2.
> For exampls, if I type in 2 in the cell, I want it to show up as 4 in that
> cell. Is this possible?
Click to expand...


How can one do this? I need to have multiple figures in various cells multiplied by certain figures... It would be helpful if there is a macro for this.

If this is possible, I really could use it.

Much thanks.
 
Back
Top