🌐
Google Support
support.google.com › docs › answer › 3093978
MULTIPLY - Google Docs Editors Help
Returns the product of two numbers. Equivalent to the `*` operator. Sample Usage MULTIPLY(A2,B2) MULTIPLY(2,3) Syntax MULTIPLY(factor1, factor2) factor1 - The first multiplicand
Discussions

I want to multiply the numbers in one column by the numbers in the next column - Google Docs Editors Community
Skip to main content · Google Docs Editors Help · Sign in · Google Help · Help Center · Community · Google Docs Editors · Terms of Service · Submit feedback · Send feedback on More on support.google.com
🌐 support.google.com
How do I multiply with text in the cell?
u/jojododo1 Please remember to tap the three dots below the most helpful comment and select Mark Solution Verified to officially close your thread. Marking your post as “solved” without indicating a solution is actually a violation of the subreddit rules (see rule #6). More on reddit.com
🌐 r/googlesheets
11
1
June 27, 2024
I want to multiply two cells, but one of them has text mixed with numbers
=arrayformula(Iferror(Value(RegexReplace(Lower(D2:D200),"lbs|kg",""))*E2:E200,"")) Put this in H2 and it will do from row 2, to 200, you can change the dimensions as needed. it will do Pounds, Ounces and Kilograms RegExReplace looks for Lbs, Oz, or KG and turns it into "" which is nothing, the | acts as an OR Lower forces all text to be lower case as RegExReplace is case sensitive Value then tries to turn the remaining text into a number then multiplies it with whats in the F column IfError turns the value into nothing if the formula errors out and ArrayFormula allows you to do arrays of data instead of putting the formula into each cell More on reddit.com
🌐 r/googlesheets
23
3
July 1, 2025
How to multiply row by constant - google sheets - Stack Overflow
in Google Sheets. Row 1 are all labels. Column 1 are all labels. Both are locked. Row 2 has unique quantities. Row 3 is a constant of 0.09. I want to multiply all of row 2 by row 3, and have all responses placed under each set, into row 4. UPDATE: Can I do this at one time or do I need to go pair by pair? ... input in cell ... More on stackoverflow.com
🌐 stackoverflow.com
People also ask

How can I multiply numbers from different sheets in Google Sheets?
To multiply numbers from different sheets, reference the sheet name and cell address in your formula. For example, if you want to multiply the value in cell A1 of Sheet1 by the value in cell A1 of Sheet2, you would use the formula =Sheet1!A1*Sheet2!A1.
🌐
superjoin.ai
superjoin.ai › home › blog › how to multiply in google sheets: a comprehensive guide
How to Multiply in Google Sheets: A Comprehensive Guide | Superjoin
What is the multiply formula in Google Sheets?
It is the asterisk. Type an equals sign, the first value, an asterisk, then the second value, for example =A1*B1. There is also a named function, =MULTIPLY(A1, B1), which does exactly the same thing but accepts only two arguments.
🌐
simplesheets.co
simplesheets.co › blog › how-to-multiply-in-google-sheets
How to Multiply in Google Sheets: 8 Formula Methods
How do I multiply values based on a condition in Google Sheets?
You can use the SUMPRODUCT function for conditional multiplication. For instance, to multiply values in the range A1 that are greater than 5, you can use the formula =SUMPRODUCT((A1:A10>5)*A1:A10).
🌐
superjoin.ai
superjoin.ai › home › blog › how to multiply in google sheets: a comprehensive guide
How to Multiply in Google Sheets: A Comprehensive Guide | Superjoin
🌐
SimpleSheets
simplesheets.co › blog › how-to-multiply-in-google-sheets
How to Multiply in Google Sheets: 8 Formula Methods
January 21, 2026 - Click the cell where you want the result. The pattern is an equals sign, the first number, an asterisk, then the second number. To multiply 9 and 2, type =9*2. The cell shows 18. The formula stays in the formula bar, so you can change either ...
🌐
Superjoin
superjoin.ai › home › blog › how to multiply in google sheets: a comprehensive guide
How to Multiply in Google Sheets: A Comprehensive Guide | Superjoin
June 10, 2024 - You can also multiply the values of two cells by referencing their cell addresses: Select the cell where you want the result to appear. ... Enter the cell address of the first value (e.g., A1). ... Enter the cell address of the second value (e.g., B1). Press Enter. For instance, if cell A3 contains the value 3 and cell B3 contains the value 8, the formula =A1*B1 would result in 24. Google Sheets also provides a built-in MULTIPLY function that allows you to multiply multiple values or cell references together:
🌐
Google Support
support.google.com › docs › thread › 204257010 › i-want-to-multiply-the-numbers-in-one-column-by-the-numbers-in-the-next-column
I want to multiply the numbers in one column by the numbers in the next column - Google Docs Editors Community
Skip to main content · Google Docs Editors Help · Sign in · Google Help · Help Center · Community · Google Docs Editors · Terms of Service · Submit feedback · Send feedback on
🌐
W3Schools
w3schools.com › googlesheets › google_sheets_multiplication.php
Google Sheets Multiplication Operator
Multiplication uses the * symbol in Google Sheets. ... You can add more cells to formula by typing (*) between the cells.
Find elsewhere
🌐
Lifewire
lifewire.com › multiply-in-google-spreadsheets-3123883
Create a Formula in Google Sheets to Multiply Numbers
November 29, 2022 - For example, in a cell, type =A2*B2 > Enter to multiply numbers in cells A2 and B2. Use numbers in formulas. For example, type =3*4 > Enter to multiply 3 times 4. Use an equal sign (=) at the beginning of all formulas.
🌐
Layer
golayer.io › home › how to multiply in google sheets (+ examples)
How to Multiply in Google Sheets (+ Examples) | Layer Blog
July 17, 2024 - The MULTIPLY function can only multiply two scalar values, so it is much more limited than PRODUCT. The syntax for MULTIPLY is as follows: MULTIPLY(factor1,factor2). The values of the factors can be cell references, or they can be typed directly ...
🌐
LiveFlow
liveflow.com › product-guides › multiply-function-in-google-sheets
MULTIPLY Function in Google Sheets: Explained | LiveFlow
Note that the MULTIPLY formula takes only two arguments and doesn’t accept a range or more than two factors as its arguments. ... Save hours formatting your next financial spreadsheet! ... You can also use the =MULTIPLY formula to multiply ...
🌐
Better Analyst
betteranalyst.com › home › google sheets formulas › how to multiply in google sheets
How to Multiply in Google Sheets | Formulas
Column C multiplies the quantity in column A by the unit price in column B. ... Put the first factor in A2 and the second factor in B2. ... Click the result cell, type =A2*B2, and press Enter.
🌐
The Bricks
thebricks.com › home › resources › how to multiply two columns in google sheets
How to Multiply Two Columns in Google Sheets
April 22, 2025 - Select the Second Cell to Multiply: Click on cell E2 (the first cell in the "Price Per Unit" column). ... Press Enter. Google Sheets will calculate the product of the two cells and display the result in F2.
🌐
Reddit
reddit.com › r/googlesheets › how do i multiply with text in the cell?
r/googlesheets on Reddit: How do I multiply with text in the cell?
June 27, 2024 -

I have a column of time that goes like this - 23:05:47 (Hrs, Min, Sec). When the hours go over 24, the cell turns into days such as 2 days, 05:25:09. I need to convert the time into all minutes. So far, I have been making the column into plain text and then multiplying the cell by 1440 which works for the cells with no days. I have about 300 cells that have days, and it's too much to manually convert all of the days back into hours.

So, how do I make a cell like 5 days, 17:31:31 or 44 days, 16:03:00 into only minutes?

The 129 hrs is from converting the days into hours.
🌐
Someka
someka.net › home › blog › google sheets tips › how to multiply in google sheets?
How To Multiply In Google Sheets? | Multiplication Functions
May 15, 2023 - To multiply using the Google Sheets MULTIPLY formula, you can type the symbol “=”, then type “MULTIPLY(” and type the first number, type the second number with “,” finish the function “)” and press enter.
🌐
Google Sheets
sheetsformarketers.com › home › blog › how to multiply in google sheets
How To Multiply in Google Sheets // Sheets for Marketers
November 1, 2023 - If you want to multiply more than one number, do not separate cell references or numbers by commas. This will result in an ERROR notification. Separate each value by an asterisk. ... When it comes to Google Sheets multiplication, you still have to understand when to use the correct equation.
🌐
Reddit
reddit.com › r/googlesheets › i want to multiply two cells, but one of them has text mixed with numbers
r/googlesheets on Reddit: I want to multiply two cells, but one of them has text mixed with numbers
July 1, 2025 -

I want to multiply D14 by E14 and I want the product to be shown in the H14 collumn

I want to start tracking my training with sheets to make a log of my training long term, I also want to be able to visualize my progress with a line graph, however the problem is that there are many metrics that I want the graph to be able to show, I dont want many graphs for all my stats, so first what I wanted to do is to mesh reps with weights on a score sistem that it would be basiclly the reps multiplied by the weight, that way if I increese weights but keep the same amout of reps or do more reps with less weight the graph will reflect my growth accordingly because instead of showing neither it will show the score of that day.

I dont know if thats the best way to go about it, im a noob in google sheets, so if you have any suggestions it would be gladly appreciated.

🌐
Quora
quora.com › How-do-you-multiply-some-cells-by-a-constant-in-Google-Sheets
How to multiply some cells by a constant in Google Sheets - Quora
Answer (1 of 5): You do it using a formula in another cell Example: If cell A2 and A3 contain 10 and 20 respectively and you wish to show the multiplied results in column B The constant is keyed into cell A1:- In column A1 input the value “50” In column B2 put formula “=A2*$A$1” (assuming ...
🌐
TheGoodocs
thegoodocs.com › tips & tutorials › google sheets tutorials › how to multiply in google sheets?
Explore This Tutorial on How to Multiply in Google Sheets | Thegoodocs.com
November 8, 2023 - Q: Can I multiply numbers in Google Sheets without using formulas or functions? A: Yes, you can. One way to do this is to use the Fill handle to copy the formula across multiple cells.
🌐
Coefficient
coefficient.io › home
How to Multiply in Google Sheets: A Step-by-Step Guide
September 2, 2025 - To learn how to multiply two cells ... simply select the cells you want to multiply, type an equal sign (=), and then type the first cell reference you want to multiply, followed by an asterisk (*), and then the second cell reference you want to multiply...
🌐
HardReset.info
hardreset.info › devices › apps › apps-google-sheets › multiply
How to Multiply on Google Sheets
Now click on the cell you want to display the result. This can be any cell in the worksheet, but the closer the cell is to the result, the easier it will be to enter the data. In the formula field, start creating an action with the = sign. Then click the cell with the value to be multiplied.