How do I multiply (1 cell) times a rge of cells to a rge of cells

[kenny]

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.

 

[Alojz]

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.

 

[francis]

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

 

[Shane Devenshire]

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.