Add the following formula to the cell C1, and fill down as necessary
=IF(A1="keyword",B1*2,B1)
References
IF - Google Editors Help
Google Support
support.google.com › docs › thread › 26967763 › multiplying-based-off-if-another-cell-has-text
Multiplying based off if another cell has text... - 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
Top answer 1 of 2
4
Add the following formula to the cell C1, and fill down as necessary
=IF(A1="keyword",B1*2,B1)
References
IF - Google Editors Help
2 of 2
1
If you need to do this for multiple values across the board down the entire column for automation purposes, you can also use the following formula:
=IF(
OR(A:A = "Keyword 1", A:A = "Keyword 2"),
B:B*2,
IF(A:A = "Keyword 3",
B*B*3,
))
Reddit
reddit.com › r/sheets › formula to multiply cell based on if another cell has text
r/sheets on Reddit: Formula to multiply cell based on if another cell has text
March 9, 2021 -
I created a spreadsheet that is a mileage log, when I select an two address from the drop downs, it will calculate via API driving distance and display it, that is working. What I am trying to figure out is when there is text in Round trip cell, that it will multiply the distance driven by 2 and it will get the correct price. and if there is nothing in round trip, then it will just calculate as is. https://docs.google.com/spreadsheets/d/1w0XhNzKL30jXVSSSf-gOelcLkw9Uuald5Ftoc4qfapc/edit?usp=sharing
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
What happens if I multiply a number by a blank cell?
You get 0, because Google Sheets treats an empty cell as zero in a multiplication. Use =PRODUCT() instead if you want blanks to be skipped rather than to zero out the answer.
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
Quora
quora.com › How-do-I-multiply-a-number-with-text-next-to-it-in-Google-Sheets-For-example-1-Amp-A-A-2-returns-contains-text-error-instead-of-2-Amp
How do I multiply a number with text next to it in Google Sheets? For example, 1 Amp| =A:A*2 returns "contains text error" instead of 2 Amp.
Answer (1 of 4): Doing what was requested is not recommended, and represents bad professional practice. If you read the Comments to this question, you will see a discussion with the Asker on this topic. He disagreed with my opinion on good professional practice, and has a valid point. But spread...
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. Top answer 1 of 5
2
Seems like it works now. In column B: =if(istext(A2), if(REGEXMATCH(A2, " days, "), Split(REGEXREPLACE(A2," days",""),",",true), Split(REGEXREPLACE(A2," day","") ,",",true)),0) If there isn't a number in A, split the number of days from the rest (in two different ways depending on if it "day" or "days"). Othervise put a 0. In column D: =if(isnumber(C2),split(C2,":"),split(A2,":")) Split the numbers in either A or C, depending on where it is. In column D everything is added up. Note that seconds are rounded. Hope this helps.
2 of 5
1
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).
SimpleSheets
simplesheets.co › blog › how-to-multiply-in-google-sheets
How to Multiply in Google Sheets: 8 Formula Methods
January 21, 2026 - Remove the characters so the cell holds only the number, then apply currency or unit formatting instead of typing it. You get 0, because Google Sheets treats an empty cell as zero in a multiplication.
Latenode
community.latenode.com › other questions › google sheets
How to multiply values based on text conditions in Google Sheets - Google Sheets - Latenode Official Community
July 23, 2025 - I’m working on a Google Sheets formula that needs to multiply numbers based on a text condition in my data. Here’s what I’m trying to do: When the formula encounters the first occurrence of a specific text value, it sh…
Statology
statology.org › home › how to use a multiply if function in google sheets
How to Use a MULTIPLY IF Function in Google Sheets
July 19, 2022 - You can use the following basic formula to create a MULTIPLY IF function in Google Sheets: =ARRAYFORMULA(PRODUCT(IF(A2:A11="string",B2:B11,""))) This formula multiplies all of the values together in B2:B11 where the corresponding cell in the ...
Arab Psychology
scales.arabpsychology.com › home › how to easily multiply values with criteria in google sheets
How To Easily Multiply Values With Criteria In Google Sheets
November 28, 2025 - The entire formula, therefore, multiplies all of the values together in the multiplication range (B2:B11) where the corresponding cell in the criteria range (A2:A11) is equal to the specified criteria, such as “string.” This intricate coordination of functions is what grants the conditional multiplication capability within Google Sheets, providing a flexible tool for data aggregation based on precise selection rules.
Google Support
support.google.com › docs › thread › 93143737 › multiplying-a-formula-if-there-is-a-value-in-another-cell
Multiplying a formula if there is a value in another cell - 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
Acceleratecomputertraining
acceleratecomputertraining.com › free-online-training › google-apps-intermediate-sheets-and-forms › chapter-2.php
Free Online Tutorial > Google Apps Intermediate Training Class > Chapter 2: Google Calendar
Referencing a cell that contains a value is smarter than typing the value itself into the formula, because if the value in a referenced cell changes, the formula result will update instantly to reflect the new result. To create a reference to a cell that lives on another sheet, click that sheet tab while writing the formula, and then click the cell.
Google Support
support.google.com › docs › answer › 3093583
SUMIF - Google Docs Editors Help
sum_column The data column to be summed, if different from `criteria_column`. Tip: Returning sum across multiple columns is not supported. ... If range contains text to check against, criterion must be a string. criterion can contain wildcards including ? to match any single character or * ...
The Bricks
thebricks.com › resources › guide-how-to-add-multiplication-in-google-sheets-using-ai
How to Add Multiplication in Google Sheets using AI - Bricks
You simply use the multiplication operator, the asterisk (*), to multiply numbers. For instance, if you want to multiply the contents of cell A1 by B1, you'd write =A1*B1 in another cell.
Google Support
support.google.com › docs › thread › 51290837 › if-cell-contains-certain-text-then-calculate
If cell contains certain text then calculate - 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
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.
MrExcel
mrexcel.com › forums › question forums › excel questions
If cell contains word, multiply two cells. But if cell contains a different word, multiply two other cells. | MrExcel Message Board
July 25, 2014 - I've been looking everywhere for a solution to this but I haven't found one yet. If cell contains a specific word, then multiply two cells. But if cell contains a different word then multiply two other cells.
Ablebits
ablebits.com › ablebits blog › google sheets tips › google sheets functions › google sheets if function – usage and formula examples
Google Sheets IF function – usage and formula examples
February 27, 2023 - I can easily create such if statements in Excel, so I hope that they can also be used in Google Sheets. ... I believe, you'd better use the SUMIF function for this task. ... Column A = 10,000 In Column B, if column A is equal or less than 90,000 then the value in column B must be the value in A in Column B, if column A is greater than 90,000 then the value in column B must 90,000 ... Thank you so much for this article! It's just what I was looking for. Is there a way to set a condition for if one cell contains certain text, then the number in the cell next to it (on the same row) is populated into a 3rd cell.
Google Support
support.google.com › docs › thread › 173312908 › multiplying-values-using-if-and-functions
multiplying values using IF < and >= functions - Google Docs Editors Community
July 31, 2022 - 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
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 - That means you can use the same method to multiply in Google Sheets that you would in Excel. I’ll show five examples below. ... If you have two numbers or cells that contain the numbers that you want to multiply, there are a couple of techniques to carry out multiplication on Google Sheets.