How to Multiply Cells With Formulas in a Spreadsheet

Multiplication formulas come up whenever a spreadsheet holds quantities and prices, hours and rates, or units and weights. Typing the product by hand for each row works until one input changes, and then every result has to be updated. A formula recalculates on its own, so the table stays correct when the source numbers change.

This guide covers four cases: multiplying two cells, multiplying a cell by a fixed number, multiplying several cells in one row, and multiplying a whole range. You will also learn how to copy a formula down a column and how to check that the results are right. The examples use a small order list, so you can reproduce each step in any spreadsheet program.

Which formula multiplies cells? The short answer

Type an equals sign, the first cell address, an asterisk, and the second cell address, such as =A2*B2, then press Enter. The asterisk is the multiplication operator, and the equals sign tells the program that what follows is a formula rather than text.

Your situation	What to do	Why
Two numbers sit in two cells	Enter `=A2*B2`	A simple product that updates when either cell changes
One cell times a fixed rate	Enter `=A2*$F$2`	The dollar signs keep the rate reference fixed when you copy the formula
Several numbers in one row	Enter `=A2B2C2`	Add as many asterisks and cell addresses as you need
A whole range of numbers	Enter `=PRODUCT(B2:B6)`	Multiplies every value in the range in one step
The same formula for many rows	Enter it once, then fill down	Each copied row adjusts its references automatically

Before you start

Confirm the cells contain numbers. Numbers pasted or imported as text often align to the left of the cell and can produce zero or an error when multiplied. Re-enter them as numbers, or convert the column to a number format, before you build the formula.
Decide which values are fixed. If many rows use the same tax rate or exchange rate, place it in its own cell and refer to it with dollar signs. Changing that one cell then updates every row.
Look for blank cells in a range. A range product skips empty cells, so a missing value will not show up as an error. Scan the range before you trust the total.
Note where the numbers came from. If the figures sit in a PDF table, you can export them to a spreadsheet format using the PDF editor in the OmniDoc desktop client and then build your formulas. Check the exported values against the original, because a table can shift during export.

Multiplying cells with a formula, step by step

Open the spreadsheet and select the result cell. Put results in a separate column so the source values stay unchanged and easy to audit.
Type an equals sign. Without it, the program stores your entry as plain text and does not calculate it.
Enter the first value. Click its cell or type its address, such as A2, and the address appears in the formula.
Type an asterisk. This tells the program to multiply. The plus, minus and forward slash characters perform addition, subtraction and division.
Enter the second value. Click a second cell, or type a number such as 0.08 for a fixed rate, then press Enter to see the result.
Copy the formula down the column. Drag the small square at the bottom-right corner of the result cell over the rows you need. The references shift row by row, so each result uses its own data.
Lock a reference that must not move. Put a dollar sign before the column letter and the row number, as in $F$2, so copying the formula keeps pointing to that one cell.
Multiply a range with PRODUCT. Type =PRODUCT(, select the cells, such as B2:B6, then close the parenthesis and press Enter. This works well for a column of factors you want as a single total.

Check the result

After you fill the formulas, check a few outputs before you use the table.

Check	How to see it	If it's wrong
The result matches a hand calculation	Multiply one row yourself, such as 4 × 2.5, which equals 10	Click the cell and confirm that each reference points to the cells you meant
The numbers are stored as numbers	Text usually aligns to the left by default	Convert the column to a number format, or re-enter the values
The formula copied correctly	Click a filled cell and read the formula bar	Add dollar signs to any reference that should stay fixed
No error codes appear	Look for #VALUE! or #NAME? in a result cell	#VALUE! often means a cell holds text; #NAME? often means a misspelled function name
Decimal places look right	Compare the displayed value with the formula bar	Change the number format. This changes only the display, not the stored value

If the figures came from a scanned PDF or a table conversion, treat the first few multiplications as a test. Compare the source numbers with the spreadsheet values, because a single misread digit will carry into every product.

❓ FAQ

1. Can I multiply and add in one formula?

Yes. Write the whole expression, such as =A2B2+C2, and the program multiplies before it adds. Use parentheses, as in =(A2+B2)C2, when you want the addition to happen first.

2. How do I reference a cell on another sheet?

Put the sheet name before the cell address, separated by an exclamation mark, such as =Sheet2!A2*B2. If the sheet name contains spaces, wrap it in single quotation marks, as in ='Q1 Orders'!A2.

3. How do I multiply a column by a percentage?

Enter the percentage as a number in its own cell, then multiply by that cell with a dollar-sign reference. You can also type the percentage directly in the formula, such as =A2*8%, though a separate cell is easier to change later.

4. What does a blank cell do in a single multiplication?

A blank cell counts as zero when you multiply it directly, so the result will be 0. That can look like a real answer, so compare the result against the source row when a value is missing.

📝 Summary

Multiplication in a spreadsheet starts with an equals sign and an asterisk, and PRODUCT handles a range in one step. Lock shared rates with dollar signs, make sure your numbers are stored as numbers, and check a few results by hand before you rely on the table.

Open OmniDoc to work on your spreadsheets