[Solved] Multiplying columns

[Nitrocowboy]

MultiplicationWelcome beginner. What is your question or comment?
Please try to briefly and clearly tell us: What you want, What you tried, and What happened.mn multip


Yes I am a beginner and I am having problems with having one column multiply by the value in another column and the answer come up in a third. When I tried the formula (B)X(C) it comes with #NAMES in the. column that I am trying to get the answer in. Can you give the right formula that I need to do the calculations correctly?

[acknak]

You can't multiply whole columns, only cells (single values). E.g.
A1: 12
B1: 2
C1: =A1*B1 shows the result: 24

Note the syntax for multiplication: m*n not mXn

[Nitrocowboy]

Thank you very much for the assistance.

[ERINI]

You type in the first funtion e.g. C1=A1*B1 and then you click on C1, the black box with a dragging point on the right-hand side appears, and you drag it as far down the C column as you need to go. This copies the formula down the column by adapting it to each row automatically

[Chiragray11]

Hello Team,

i am using your APACHE OPEN OFFICE Version 3.4.1

but i am facing formulas for "multiplication"

i will explain in brief:

i have 10 column but i want to multiplication of two column, column have integer value and decimal value for example...

100 * 1.85

i am using your formula like =C1*D2

but not getting any response, getting only error like "#VALUE!".

so, please solve my issue ASAP.


Thanks,
Chirag Ray

[universe]

Yes you can multiply entire columns at once. This is for Google but also works for Open Office Calc :
https://www.lifewire.com/multiply-in-go ... ts-3123883

Start with "multiplication formula example" then move through "multiply across multiple rows" . If you want to multiply one column by one number, copy that number, select (blue out) a column next to the column set to be multiplied. Paste. That number should appear next to each number. 3rd column will create entire set multiplied by that repeated number.

Surprised I could not find this within Open Office.