Page 1 of 1

How to multiply column A by Column B.

PostPosted: Fri Jan 18, 2019 10:36 pm
by louispaul
I have read the posts on multiplying one column by another but I cannot get the formula to work. I tried C3 = A3*B3 and then put it in brackets but I get a value of #Name10. After I get the formula installed I want to copy it down the column into all the cells in Column C. What is the correct format for typing the formual into the first cell in column c? What is the command to copy the formula into all of the remaining cells in Column C. I tried the Fill, Down command but that only copied the data from the first cell.

Re: How to multiply column A by Column B.

PostPosted: Fri Jan 18, 2019 11:16 pm
by FJCC
C3 should contain
Code: Select all   Expand viewCollapse view
=A3 * B3

Re: How to multiply column A by Column B.

PostPosted: Sat Jan 19, 2019 1:07 am
by robleyd
If you are new to spreadsheets, you may find the following to be useful resources.

[Tutorial] Ten concepts that every Calc user should know

OpenOffice Spreadsheet Tutorial for Beginners with Examples

Re: How to multiply column A by Column B.

PostPosted: Sat Jan 19, 2019 5:29 am
by FJCC
There are several ways to copy the formula in C3 down to the other cells in the column. Here are three:
1. Left click on C3. It will now have a black border with a small black square at the lower right corner. Click and hold on that small square and drag down as far as you need the formula to be copied.

2. Left click on C3. It will now have a black border with a small black square at the lower right corner. Double click on that small square and the formula will be filled down the column as far as the neighboring column on the left is filled.

3. Left click on C3. Go to the menu item Edit -> Copy. Now click and hold on cell C4 and drag down to select cells as far as you want the formula to go. With those cells selected, choose the menu item Edit -> Paste.

Re: How to multiply column A by Column B.

PostPosted: Sat Jan 19, 2019 9:32 pm
by louispaul
I cannot determine what I am doing wrong. I tried all three ways as you itemized, and each method copied only the data from C3 into every cell below.

Re: How to multiply column A by Column B.

PostPosted: Sat Jan 19, 2019 9:45 pm
by RusselB
Are you seeing the formula copied down, rather than the results, or are you seeing the same results?
If you are seeing the formula, go to Tools -> Options -> OpenOffice Calc -> View
Then uncheck the box in the Display section beside Formulas

If you are seeing the same results, check that you don't have $ in front of the row indicator in your formula (ie: make sure it reads C3 not C$3)
If you have eliminated that, then check that the referenced numbers are not the same, or multiply to the same (ie: if A3 has 5 and B3 has a 2, then make sure that A4 isn't 10 with B4 being 1)
There are lots of possibilities that can give you the same results, so the results of the formula look the same, even though the formula is calculating correctly.

If you have eliminated that last option (ie: tested A3 with 5 and B3 with 6, giving C3 at 30, and A4 with 2 and B4 with 3, giving C4 at 6), but your still seeing 30 for C4, then please attach a sample of your document.

Re: How to multiply column A by Column B.

PostPosted: Sun Jan 20, 2019 6:54 pm
by louispaul
I made a copy for you of the three columns from my spreadsheet but do not know how to send it to you on this reply form. If you could give me an email address where you can receive the data, I can attach the file to my email and send it to you.

Re: How to multiply column A by Column B.

PostPosted: Sun Jan 20, 2019 7:09 pm
by RusselB