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