Prev: Writing an IF statement in Microsoft Query
Next: Folder listing
From: jhun on 29 Mar 2010 23:44
How do i calculate a whole list in one column (B1-b6) (mathematical function
i.e. multiply, divide, summation) with another column (c1-c6) and have excel
display the output in another set of columns (d1-d6) i.e.

input X input = output by excel
b1 X c1= d1
b2 X c2= d2
b3 X c3= d3
b4 X c4= d4

without me having to change the column number row by row and insert the
value row by row after each calculation.

thank you
From: T. Valko on 30 Mar 2010 00:04
Enter this formula in D1...

=B1*C1

Then just drag copy down as needed. Or, you can left double click the fill
handle. The fill handle is that little black square at the bottom right of
the selected cell. Hover your mouse over the fill handle until it changes
from a fat plus sign to a skinny plus sign. When it changes to the skinny
plus sign left double click.

--
Biff
Microsoft Excel MVP


"jhun" <jhun(a)discussions.microsoft.com> wrote in message
news:F067A748-9098-43A5-90B0-3290F883FAC4(a)microsoft.com...
> How do i calculate a whole list in one column (B1-b6) (mathematical
> function
> i.e. multiply, divide, summation) with another column (c1-c6) and have
> excel
> display the output in another set of columns (d1-d6) i.e.
>
> input X input = output by excel
> b1 X c1= d1
> b2 X c2= d2
> b3 X c3= d3
> b4 X c4= d4
>
> without me having to change the column number row by row and insert the
> value row by row after each calculation.
>
> thank you


From: trip_to_tokyo on 30 Mar 2010 00:13
EXCEL 2007

In cell B1 I have the number 2

In cell C1 I have the number 2

In cell D1 I have:-

=(B1*C1)

This results in 4 being placed in cell D1.

Do a Ctrl-C in cell D1 to copy the formula contained there and Ctrl-V to
paste that formula to cells D2 to D4 inclusive.

If my comments have helped please hit Yes.

Thanks.



In cell

"jhun" wrote:

> How do i calculate a whole list in one column (B1-b6) (mathematical function
> i.e. multiply, divide, summation) with another column (c1-c6) and have excel
> display the output in another set of columns (d1-d6) i.e.
>
> input X input = output by excel
> b1 X c1= d1
> b2 X c2= d2
> b3 X c3= d3
> b4 X c4= d4
>
> without me having to change the column number row by row and insert the
> value row by row after each calculation.
>
> thank you
 | 
Pages: 1
Prev: Writing an IF statement in Microsoft Query
Next: Folder listing