| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I multiply the content of a cell by a number
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I multiply the content of a cell by a number
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. "KTK" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I multiply the content of a cell by a number
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 "KTK" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to multiply only a portion of a cell number? | Excel Worksheet Functions | |||
| How do I multiply a cell by 1.5x a number in another cell | Excel Worksheet Functions | |||
| How do you multiply each cell by the same number? ( 899.80*.085) | Excel Discussion (Misc queries) | |||
| how can i multiply a number in each cell? | Excel Discussion (Misc queries) | |||
| multiply by actual number in cell | Excel Worksheet Functions | |||
Linear Mode
