How to multiply column A by Column B.

Discuss the spreadsheet application

How to multiply column A by Column B.

Postby louispaul » Fri Jan 18, 2019 10:36 pm

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.
Last edited by louispaul on Sat Jan 19, 2019 12:47 am, edited 1 time in total.
Open Office 4.1.4 on Windows 10
louispaul
 
Posts: 3
Joined: Fri Jan 18, 2019 10:21 pm

Re: How to multiply column A by Column B.

Postby FJCC » Fri Jan 18, 2019 11:16 pm

C3 should contain
Code: Select all   Expand viewCollapse view
=A3 * B3
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7011
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: How to multiply column A by Column B.

Postby robleyd » Sat Jan 19, 2019 1:07 am

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
Cheers
David
Apache OpenOffice 4.1.6 - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2441
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: How to multiply column A by Column B.

Postby FJCC » Sat Jan 19, 2019 5:29 am

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.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7011
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: How to multiply column A by Column B.

Postby louispaul » Sat Jan 19, 2019 9:32 pm

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.
Open Office 4.1.4 on Windows 10
louispaul
 
Posts: 3
Joined: Fri Jan 18, 2019 10:21 pm

Re: How to multiply column A by Column B.

Postby RusselB » Sat Jan 19, 2019 9:45 pm

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.
OpenOffice 4.1.6 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
RusselB
Volunteer
 
Posts: 4825
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: How to multiply column A by Column B.

Postby louispaul » Sun Jan 20, 2019 6:54 pm

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.
Open Office 4.1.4 on Windows 10
louispaul
 
Posts: 3
Joined: Fri Jan 18, 2019 10:21 pm

Re: How to multiply column A by Column B.

Postby RusselB » Sun Jan 20, 2019 7:09 pm

OpenOffice 4.1.6 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
RusselB
Volunteer
 
Posts: 4825
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 16 guests