If you want to know how to multiply in Google Sheets formula form, the fastest answer is simple, use the asterisk symbol between numbers or cell references. You can multiply two cells, an entire column, or a mixed formula with other math, all from the same basic pattern. Once you know the syntax, multiplying in Google Sheets becomes a one-line job instead of a manual calculation.
The basic multiplication formula in Google Sheets
To multiply numbers in Google Sheets, start with an equals sign, then place the values you want to multiply with an asterisk between them. This is the core multiplication formula in Google Sheets, and it works for both typed numbers and cell references.
Simple examples
Use these directly in a cell:
- =2*3 for 2 times 3
- =A1*B1 to multiply the values in cells A1 and B1
- =A1*10 to multiply a cell by a fixed number
There is no special multiplication function in Google Sheets for basic multiplication. The asterisk is the standard way to do it. If you are looking for a formula for Google Sheets to multiply, this is the formula you want first.
How to multiply two cells in Google Sheets
If you need to multiply two cells in Google Sheets, click the result cell and type the formula with the two cell references. This is the most common use case for multiplication on Google Sheets, especially for quantities, prices, rates, and totals.
- Click the cell where you want the answer.
- Type =A1*B1 using the cells you want to multiply.
- Press Enter.
If A1 contains 4 and B1 contains 7, the result is 28. If you want to multiply 2 cells in Google Sheets across many rows, enter the formula in the first row and fill it down by dragging the small square at the bottom-right corner of the cell.
Copying the formula down a column
To multiply numbers in Google Sheets across a list, write the formula in row 2, such as =A2*B2, then drag it down. Google Sheets adjusts the row numbers automatically, so each row multiplies its own values. This is the easiest way to auto multiply in Google Sheets without rewriting the formula for every line.
How to multiply numbers in Google Sheets with constants
When one number stays the same, lock it into the formula as a constant. This is useful for tax rates, discounts, markups, conversion factors, and unit pricing. If you want a formula for multiplying in Google Sheets with one fixed value, use a cell reference or a typed number.
Multiply by a fixed number
Examples:
- =A1*12 multiplies A1 by 12
- =B2*1.1 increases B2 by 10 percent
- =C3*0.75 applies a 25 percent discount
If you want the fixed value in its own cell, put the number in a separate cell and reference it. That makes updates easier, because changing the source number changes every formula linked to it.
Use absolute references for a fixed cell
If the constant is in cell D1 and you plan to copy the formula down, use $D$1 so it does not move. For example, =A2*$D$1 keeps the same multiplier in every row. This is the clearest way to make Google Sheets multiply numbers across a table while keeping one rate unchanged.
How to multiply an entire range in Google Sheets
If you need to multiply multiple rows at once, fill the formula down or use an array formula. For most spreadsheets, a copied row formula is the simplest answer. For dynamic output, an array formula can return results for the whole range automatically.
Fill down for row-by-row multiplication
Enter =A2*B2 in C2, then drag it down. Each row gets its own product. This setup handles invoices, inventory counts, and sales totals cleanly.
Use ARRAYFORMULA for automatic expansion
If you want one formula to handle a whole column, use:
=ARRAYFORMULA(A2:A*B2:B)
This multiplies each value in column A by the matching value in column B and returns the results down the column. It is the fastest formula in Google Sheets for multiplying many rows without manual copying.
Multiplication formulas with mixed math
Google Sheets lets you combine multiplication with addition, subtraction, division, and parentheses. This matters when you need a real calculation, not just a basic product. Use parentheses to control the order of operations.
Common patterns
Examples:
- =(A1+B1)*C1 adds A1 and B1 first, then multiplies by C1
- =A1*B1/100 multiplies first, then divides by 100
- =(A1*B1)+C1 calculates a product, then adds C1
If you leave out parentheses, Sheets follows standard math order. Multiplication happens before addition and subtraction. Use parentheses whenever you want the spreadsheet to read your formula exactly the way you mean it.
Common mistakes when multiplying in Google Sheets
Most multiplication problems come from formula syntax, not from the math itself. If your result looks wrong, check the formula structure first. The multiplication function in Google Sheets does not use words like MULTIPLY for simple products, so the asterisk is required.
Watch for these issues
- Use = at the start of every formula.
- Use * for multiplication, not an x or lowercase letter.
- Make sure the cells contain numbers, not text.
- Remove spaces inside the formula if they break the expression.
- Use $ signs when you want a cell reference to stay fixed.
If a cell is stored as text, multiplication will not work until the value is converted to a number. Format the cell as a number, or replace imported text values with numeric data. That solves most cases where people ask how do I multiply in Google Sheets and get an error instead of a result.
Frequently Asked Questions
How do you multiply in Google Sheets?
Type an equals sign, then the numbers or cell references with an asterisk between them. For example, =A1*B1 multiplies the values in A1 and B1. That is the standard multiplication formula in Google Sheets.
What is the formula for Google Sheets to multiply?
The basic formula is =number1*number2 or =cell1*cell2. For example, =5*8 or =A1*B1. If you need a repeated calculation down a column, copy the formula or use =ARRAYFORMULA(A2:A*B2:B).
How do I multiply two cells in Google Sheets and copy it down?
Enter the formula in the first result cell, such as =A2*B2, then drag the fill handle down the column. Google Sheets adjusts the row numbers for each line, so every row multiplies its own pair of values.
How do I auto multiply in Google Sheets?
Use ARRAYFORMULA for automatic multiplication across a range. A formula like =ARRAYFORMULA(A2:A*B2:B) calculates every row at once and keeps the results updated when the source data changes.
Is there a multiplication function in Google Sheets?
For simple multiplication, Google Sheets uses the asterisk operator instead of a separate function. If you want to multiply numbers in Google Sheets, * is the correct tool. Use functions like ARRAYFORMULA only when you need to apply multiplication across a whole range.
Related Posts:
Google Sheets
- How to Convert Currency in Google Sheets
- Google Sheets Formulas: The Essentials With Examples
- How to Add or Remove Borders in Google Sheets
- How to Edit a Pivot Table in Google Sheets
- How to Sort by Date in Google Sheets
- How to Add Bullet Points in Google Sheets
- How to See Edit History in Google Sheets
- How to Insert a Hyperlink in Google Sheets
- How to Calculate Days Between Dates in Google Sheets
- How to Merge Cells in Google Sheets
- How to Convert Google Sheets to PDF
- How to Make a Graph in Google Sheets
- How to Add Cells and Columns in Google Sheets (SUM)
- How to Export Google Sheets to CSV (and Import One)
- How to Calculate Percentages in Google Sheets
- How to Remove Duplicates in Google Sheets
- How to Hide Zero Values in Google Sheets
- How to Lock a Formula or Cell in Google Sheets
- How to Alphabetize in Google Sheets
- How to Protect Cells and Sheets in Google Sheets
- How to Insert an Image Into a Cell in Google Sheets
- How to Make a Bar Graph in Google Sheets
- How to Change Row Height in Google Sheets
- How to Change Cell Width in Google Sheets
- How to Remove a Drop-Down in Google Sheets
- How to Sort Numbers in Order in Google Sheets
- How to Insert Multiple Columns in Google Sheets
- How to Use VLOOKUP and XLOOKUP in Google Sheets
- How to Delete Columns in Google Sheets
- How to Calculate Hours Worked in Google Sheets