In this article:

How to Multiply in Google Sheets (The Easy Way!)

May 8, 2024

In this article we will show you exactly how to multiply numbers in google sheets using the multiply sign (operator),  MULTIPLY function and PRODUCT functuon along with sample formulas and examples.

How to Multiply Using the Multiply Operator (*) 

The Multiply operator is the simplest way of getting the product of two or more numbers in Google Sheets. We show three ways to use this method below.

Syntax 

=num1*num2*num3*...

Where num1, num2, num3 can be numbers or references to the cells containing them. 

You can add more as needed, as indicated by the ellipsis (...) symbol; however, add the operator before the next number. For example, you want to get the product of five numbers. The formula becomes:

=num1*num2*num3*num4*num5

Multiply Two Numbers

Step 1: Select a cell to output the result

Google Sheets select cell to place the formula

Step 2: Add formula =num1*num2

Google Sheets how to multiply using operator 

Step 3: Press Enter

Google Sheets result 

Screencap

Google Sheets how to multiply two numbers screencap

Multiply Two Numbers Stored in Different Cells

Step 1: Select the cell to output the answer

Google Sheets select cell to place formula

Step 2: Enter the multiply formula =num1*num2

Cells selected and formula being added

Start with the first cell, then type an asterisk symbol, then select the second cell. 

Step 3: Press Enter

Google Sheets result

Screencap

Google Sheets get the product of 2 cells screencap

Multiply Three or More Numbers

Step 1: Select a cell to display your answer

Google Sheets cell containing formula selected

Step 2: Use the multiply formula =num1*num2*num3*...

Google Sheets formula for multiple numbers added

If the numbers are stored in different cells, you can select them one by one, adding an asterisk after each selected cell until the last one. 

Step 3: Press Enter

Google Sheets formula for multiple numbers result

Screencap

Google Sheets formula for multiple numbers screencap

How to Multiply using the MULTIPLY function

Google Sheets Multiply Formula Syntax

=MULTIPLY(num1,num2)

Where num1 and num2 are numbers. They can be the numbers themselves or references to the cells containing them. 

If you add at least a third number to the formula, you will get the following error:

Google Sheets Error wrong number of arguments expected if you add a third number to the function

Step 1: Select the cell

Google Sheets select cell containing the function

Step 2: Add formula =MULTIPLY(num1,num2)

Google Sheets multiply function formula added

Press Ctrl button (Windows) or Command ⌘ (Mac) while selecting the cells. 

Step 3: Press Enter

Google Sheets function result

Screencap

Google Sheets multiply function screencap

How to Multiply with A Fixed Number

In certain calculations, you need to deal with a fixed number or factor. This is possible, whether you include the number or store it in a separate cell. 

Syntax

There are two ways to pull this off:

=num1*const

=MULTIPLY(num1,const)

Where num1 is the number to be multiplied to fixed number const. Num1 is reference to the cell containing the value while const can either be number added to the formula or a reference to the cell containing it fixed as absolute reference with the following form:

$C$R

Where C is the column letter and R is the row number. If the fixed number is located at A3, then the corresponding reference is

$A$3

Step 1: Select the cell

Select cell that will contain formula

Step 2: Add formula =num1*const or =MULTIPLY(num1,const)

Google Sheets formula with fixed number added

Step 3: Mark const as absolute reference

Reference converted to absolute reference

Step 4: Press Enter

Google Sheets formula with fixed number result

Step 5: Apply to other Cells Along the Column

Hold the small box on the lower-right corner of the highlight of the cell, then drag it down the column. You can also double-click it to automatically be copied to other cells along the column.

Formula copied to other cells along the column

Screencap

Google Sheets how to multiply with a fixed number screencap

How to Multiply Using the PRODUCT function

Use this function if you need the product of three or more numbers.

Syntax

=PRODUCT(num1,num2,num3,...)

Where num1, num2, num3 can be numbers or references to the cells containing them. You can add more as needed.

Step 1: Select the cell

Google Sheets select cell 

Step 2: Add formula =PRODUCT(num1,num2,num3,...)

Google Sheets product function 

Press Ctrl button (Windows) or Command ⌘ (Mac) while selecting the cells. 

Step 3: Press Enter

Google Sheets product function result

Screencap

Google Sheets product function screencap

How to Multiply Two Columns in Google Sheets

If you need to get the product of two numbers along two columns, it takes a long time if you decide to set the formula for each row. Turns out, there is a simple solution. 

Google Sheets Multiply Formula For Columns Syntax

=ARRAYFORMULA(MULTIPLY(col1,col2))

Where col1 and col2 are the range of columns. Make sure they have the same length so the formula works. 

Step 1: Select the cell

Google Sheets two columns of data

Step 2: Add formula =ARRAYFORMULA(MULTIPLY(col1,col2))

Google Sheets multiply columns formula

Step 3: Press Enter

Google Sheets columns product result

Screencap

Google Sheets multiply columns screencap

FAQs

How many numbers can I input?

You can have up to 30 numbers. Realistically, you only need to set three to five numbers for a formula.

When to use MULTIPLY and PRODUCT function?

MULTIPLY function is best used when dealing with two numbers. PRODUCT function works best when dealing with three or more numbers. 

If you enjoyed this article, you might also like our article on how to add up columns in Google Sheets or our article on how to subtract in Google Sheets. 

If you want to get a copy of our Google Sheets address book template, we also suggest checking out our detailed guide. 

Use our payment reminder software to easily follow up payments from your spreadsheet in just a few clicks. 

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->