J
jhun
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
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