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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

multiply range of cells by a fluctuating exchange rate 8
constant multiplier 4
Column multiplied by a matrix 2
Multiplying one cell by a column 5
Sum Formula for cell range 1
How do I multiply a cell by the product of two other cells? 1
Multiplying the number in one cell and providing the product in an 4
Formula For Multiple Rows 2

Back
Top