Updated: November 21, 2026

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.

  1. Click the cell where you want the answer.
  2. Type =A1*B1 using the cells you want to multiply.
  3. 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.