Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I multiply (1 cell) times a rge of cells to a rge of cells
I want to make a budget analysis we I can input a dollar figure in one cell
and multiply to times a range of cells. When I copy the formula excel correlates the cells to the next in line. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I multiply (1 cell) times a rge of cells to a rge of cells
Not very clear what's ur problem.
Assuming in A1 is ur dollar figure. B1:F1 u have desired range. In B2:F2 will be A1 times B1:F1. Select by mouse range B2:F2 and type: =a1*b1:f1 then press ctrl+shift+enter (array formula). Or insert to B2 =A$1*B1, then drag and copy to C2:F2. "kenny" wrote: I want to make a budget analysis we I can input a dollar figure in one cell and multiply to times a range of cells. When I copy the formula excel correlates the cells to the next in line. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I multiply (1 cell) times a rge of cells to a rge of cells
I think its the relative references that you are using,
try putting absolute references to your formula, example like =$A$1*(B2:B10), A1 will not change if you copy the formula across =A1*($B$2:$B$10), B2:B10 will not change, A1 will change to A2 if copy down and A1 will change to B1 if copy across =$A2*($B$2:$B$10), Col A will ne intact but row ref will change etc......you may want to read this from the Help section, type absolute reference in the search for help. -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis "kenny" wrote: I want to make a budget analysis we I can input a dollar figure in one cell and multiply to times a range of cells. When I copy the formula excel correlates the cells to the next in line. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I multiply (1 cell) times a rge of cells to a rge of cells
Hi,
this question is not clear. But if I use you subject line as the question: Suppose that the range you want to multiple is A1:A10 and you want to multiply it by the value in cell E1. and you want the results in B1:B10, then Highlight the range B1:B10, type =E1*A1:A10 and press Shift+Ctrl+Enter. This is not the standard way to do this but it works an takes less memory. the standard way would be =E$1*A1 and copy that down to B10. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "kenny" wrote: I want to make a budget analysis we I can input a dollar figure in one cell and multiply to times a range of cells. When I copy the formula excel correlates the cells to the next in line. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I MULTIPLY MANY CELLS BY A CONSTANT CELL ? | Excel Discussion (Misc queries) | |||
How do you format a cell to automatically multiply entry times 2? | Excel Discussion (Misc queries) | |||
formula for multiply one cell to one of two other cells? | Excel Discussion (Misc queries) | |||
Would like one cell to both count and multiply a range of cells | Excel Worksheet Functions | |||
How do I multiply a cell by the product of two other cells? | Excel Discussion (Misc queries) |