Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating column A * column B = Results in another column
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating column A * column B = Results in another column
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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating column A * column B = Results in another column
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
Formula to look up a column and paste results in another column | Excel Worksheet Functions | |||
Sum of column C where results in column A match | Excel Worksheet Functions | |||
Adding one column based on results from another column | Excel Discussion (Misc queries) | |||
Calculating totals in a column based on a lookup in another column | Excel Worksheet Functions |