Stack Exchange
webapps.stackexchange.com › questions › 150399 › google-sheets-wrong-value-of-multiplication-and-division
Google Sheets wrong value of multiplication and division - Web Applications Stack Exchange
January 25, 2021 - Thanks to @ErikTyler, I found that the value displayed as "1.7" was actually a "01/07/2021". I have no idea why the sum is still correct but the multiplication isn't and why Google Sheets interprets it as such but at least I could fix the error by changing it to a real "1.7".
Reddit
reddit.com › r/googlesheets › i keep receiving incorrect multiplication answers throughout my sheet
I keep receiving incorrect multiplication answers throughout my sheet : r/googlesheets
April 12, 2024 - u/TragicFanatic Because of the placement of your IMPORTRANGE formula, I'm not able to see the actual value of H12.
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
Is there a Paste special multiply option in Google Sheets?
No. Excel has one, Google Sheets does not. Use a helper column with =B2*$F$1, copy it, then paste back over the original column with Edit > Paste special > Values only, and delete the helper column afterwards.
simplesheets.co
simplesheets.co › blog › how-to-multiply-in-google-sheets
How to Multiply in Google Sheets: 8 Formula Methods
How do I multiply two entire columns without dragging the formula down?
Put =ARRAYFORMULA(IF(A2:A="", "", A2:A*B2:B)) in the first cell of the result column and leave the rest of that column empty. It calculates every row at once and keeps working as new rows are added.
simplesheets.co
simplesheets.co › blog › how-to-multiply-in-google-sheets
How to Multiply in Google Sheets: 8 Formula Methods
Google Support
support.google.com › docs › thread › 117716789 › why-are-the-figures-not-multiplying-correctly
Why are the figures not multiplying correctly? - 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
Reddit
reddit.com › r/googlesheets › formula not multiplying correctly
r/googlesheets on Reddit: Formula not multiplying correctly
June 30, 2021 -
Hi! I am trying to calculate price x frequency for a monthly total. An example of my formula in my cell is =E10*D10, through out the column with obviously different numbers in each row. 9time out of 10 it is working, but every few cells, the results are wrong. It will read $8 x 1 = $7.50 It seems to be 50 cents per frequency off the total it should be.
I am a novice google sheet/excel user. Can anyone please please help me?
Google Support
support.google.com › docs › thread › 26974000 › multiplication-answers-are-wrong-when-one-cell-is-having-sum-function
Multiplication answers are wrong when one cell is having sum() function - Google Docs Editors Community
January 28, 2020 - 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
Stack Overflow
stackoverflow.com › questions › 65707696 › google-sheet-not-multiplying-in-if-formula
if statement - Google Sheet Not Multiplying in IF Formula - Stack Overflow
As BigBen noticed in his comment - there's a mistake in your formula.
SimpleSheets
simplesheets.co › blog › how-to-multiply-in-google-sheets
How to Multiply in Google Sheets: 8 Formula Methods
January 21, 2026 - The rule: without the dollar signs, dragging =B1*C1 down turns row 2 into =B2*C2, and C2 is empty, so the answer becomes 0. That is the single most common multiplication mistake in Google Sheets. If your multiplier is a percentage, remember that a cell showing 10% holds the value 0.1. Multiply by the cell, not by 10.
Latenode
community.latenode.com › other questions › google sheets
Google Sheets showing wrong calculation results for multiplication - Google Sheets - Latenode Official Community
August 15, 2025 - I’m having a weird issue with Google Sheets calculations that’s driving me crazy. When I multiply 14 by 7.18 in a cell, Google Sheets gives me 100.57 as the result. But when I check this same calculation on my regular ca…
JustAnswer
justanswer.com › computer › qj1hn-google-sheet-formula-not-calculating-correctly-h6-i6.html
Fixing Google Sheets: Why H6*I6 Formula Fails?
November 7, 2024 - Here are a few things you or the customer can verify:1. Ensure Cells Are Numeric: Occasionally, cells may look like they contain numbers but actually have spaces or other hidden characters that Google Sheets interprets as text.
The Bricks
thebricks.com › home › resources › how to multiply two numbers in google sheets
How to Multiply Two Numbers in Google Sheets - Bricks
February 17, 2025 - If your formula result is 0 and ... are treated as zero in mathematical operations. Solution: Check your source cells to make sure they all contain the correct data....
Ben Collins
benlcollins.com › home › when your formula doesn’t work: formula parse errors in google sheets
Formula Parse Errors In Google Sheets And How To Fix Them
April 3, 2026 - In this example, I misspelt the SUM function as SUMM, which Google Sheets didn’t recognize, so returned an error: Another reason for a #NAME? error is referencing a named range that doesn’t actually exist or is misspelled. ... Missing quotation marks around a text value, as shown in this simple formula, will also cause a #NAME? error: ... Check your function names are correct.
Lifewire
lifewire.com › multiply-in-google-spreadsheets-3123883
Create a Formula in Google Sheets to Multiply Numbers
November 29, 2022 - Open Google Sheets, and select a cell. Enter the equal sign ( = ). Type a number. Enter the asterisk ( * ) to signify multiplication. Type the second number. Press Enter to see the result. Even though entering numbers directly into a formula works, it's not the best way to create formulas.
The Bricks
thebricks.com › home › resources › how to use multiply in google sheets: a step-by-step guide
How to Use Multiply in Google Sheets: A Step-by-Step Guide
April 22, 2025 - This happens when a formula refers to its own cell, creating an infinite loop. For instance, putting the formula =A5*B5 into cell B5 is a circular dependency. How to fix: Identify and remove the part of the formula that refers to its own cell.
Reddit
reddit.com › r/googlesheets › error when trying to multiply two values
r/googlesheets on Reddit: Error when trying to multiply two values
September 23, 2021 -
I am trying to multiply 2 values, but it keeps on giving me this error message: Wrong number of arguments to MULTIPLY. Expected 2 arguments, but got 1 arguments.
Eg. I am trying to multiply 0.4 by 10.
Top answer 1 of 2
1
Did you do this? =multiply(0.4*10) So the correct syntax is (using the in-sheet helper will get you this answer quicker) =multiply(0.4,10) but really, everyone does this most of the time =0.4*10
2 of 2
1
Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide . You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
Super User
superuser.com › questions › 1482150 › google-sheets-formula-not-working
worksheet function - Google Sheets: Formula not working - Super User
September 13, 2019 - I'm not exactly sure what I'm doing ... 2 and 3. ... That did it! Thanks Akina!! ... There is not a MULTIPLY function, so use simply operator *....
Spreadsheet Point
spreadsheetpoint.com › home › google sheets tips › how to multiply in google sheets and excel
How To Multiply in Google Sheets and Excel
February 9, 2024 - Simply use the multiply operator between all the values that you want to multiply. You can also use the multiplication operator to square numbers in Google Sheets. For example, if you have values in cell A1, A2, and A3, you can use the formula ...
The Bricks
thebricks.com › home › resources › how to multiply two columns in google sheets
How to Multiply Two Columns in Google Sheets - Bricks
April 22, 2025 - Solution: Look at the cells directly below the one containing your ARRAYFORMULA. If there is any text, number, or even an old formula there, delete it. Once the path is clear, the error will resolve itself, and the results will populate correctly. You've now seen several powerful methods for multiplying columns in Google Sheets.
The Bricks
thebricks.com › home › resources › how to add multiplication in google sheets
How to Add Multiplication in Google Sheets
February 17, 2025 - Accidental spaces can also trigger this, so ensure your numbers are formatted correctly. Circular Dependency Error: This occurs when a formula refers to its own cell, creating an infinite loop. For instance, if you accidentally type =D2*C2 into cell D2. To fix this, simply ensure your formula is only referencing other cells. You've now learned the essential methods for multiplication in Google Sheets, from the simple asterisk operator to the efficient PRODUCT and ARRAYFORMULA functions.
Reddit
reddit.com › r/googlesheets › formula error? why does google sheet keep making this mistake?
r/googlesheets on Reddit: Formula error? Why does google sheet keep making this mistake?
August 24, 2022 -
Can someone please advise on why, on occasion, when I enter a simple multiplication formula the result is incorrect?
In this case I’m multiplying 10 * 12, but the results says 115 instead of 120.
Help, please😭
Top answer 1 of 2
1
Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide . You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
2 of 2
1
What’s your formula?
Better Analyst
betteranalyst.com › home › google sheets formulas › how to multiply in google sheets
How to Multiply in Google Sheets | Formulas
•Use an asterisk (*) for multiplication; the letter x is text and will not calculate. •Lock fixed tax, commission, or conversion rates with an absolute reference such as $F$1. •PRODUCT ignores text in referenced ranges, so check that values ...