How to Multiply in Google Sheets

If you’re working with numbers or data, learning how to multiply in Google Sheets helps you perform quick and accurate calculations.

Multiply using the asterisk (*) operator

In Google Sheets:

1. Click on a cell
2. Type =
3. Enter the numbers or cell references
4. Use * to multiply

Example:
=A1 * B1

→ Press Enter to get the result

Multiply multiple cells

You can multiply more than two values:

=A1 * B1 * C1

→ This multiplies all selected cells

Use PRODUCT function

1. Click on a cell
2. Type:
   =PRODUCT(A1:B1)

→ This multiplies all values in the range

Multiply a column

1. Enter the formula in the first row
2. Drag the fill handle down

→ This applies the formula to the entire column

Why multiply in Google Sheets

• Perform quick calculations
• Automate data processing
• Save time on repetitive tasks

Quick tip

Always use cell references instead of typing numbers manually so your calculations update automatically when data changes.