How do I multiply the content of a cell by a number

  • Thread starter Thread starter KTK
  • Start date Start date
K

KTK

I need to multiply the content of a cell by a number (e.g. 2) but have been
receiving the error message saying that there is a circular reference. Is
there a way out?
 
EXCEL 2007

In cell A1 I type the number 1.

In cell B1 I type the number 2.

In cell C1 I type:-

=(A1*B1)

This gives a result of 2 in cell C1.

Hope the above helps.

If it does please hit Yes.

Thanks.
 
Hi,
you can have that number in one cell let's say A1 and then you want to
multiply everything in column B by that number

=B1*$A$1

copy formula down
 
Back
Top