To multiply in Excel, enter an equals sign, the first number or cell reference, an asterisk, and the next number or cell reference—for example, with numbers in A2 and B2, type =A2*B2 in C2 to multiply them. Press Enter to see the result. You can also multiply several values with the PRODUCT function, then copy a formula down a column to calculate more rows.
What You’ll Need
- Microsoft Excel for Microsoft 365 on Windows, or access to Excel for the web or Excel for Mac. The multiplication formulas in this guide work in all three.
- A workbook with numbers entered in cells, or a blank worksheet where you can enter sample values.
- A destination cell for each result. It is helpful to keep your input values in separate columns and label them so you can tell what each number represents.
Step-by-Step
-
Set up your values in cells. Open the workbook and choose a worksheet. For a simple example, enter 12 in A2 and 5 in B2. You might label A1 Quantity and B1 Price, or use any labels that describe your data. Put the result in a third cell, such as C2, so the original values remain available. Excel can multiply numbers typed directly into a formula, but references to cells are usually easier to check and update.
-
Multiply two cells with the asterisk operator. Select C2, type the formula below, and press Enter. With 12 in A2 and 5 in B2, the formula returns 60. Excel uses the asterisk (*) for multiplication; the letter x is not a multiplication operator in a formula.
With the first value in A2 and the second value in B2, enter:
=A2*B2The result appears in C2. If you change either input, Excel recalculates the result automatically as long as calculation is set to Automatic, which is the usual default.
-
Multiply numbers directly when you do not need cell references. Select an empty cell, type the formula, and press Enter. This example multiplies 7 by 8 and returns 56. Direct-number formulas are useful for quick calculations, but they are less flexible: to use different values, you must edit the formula rather than change an input cell.
For a direct calculation, enter in any empty cell:
=7*8 -
Multiply more than two values. You can put additional asterisks between cell references. With 3 in A2, 4 in B2, and 5 in C2, enter this in D2; the result is 60. This format makes the factors visible in the formula, but a long chain can be harder to read.
With the three factors in A2, B2, and C2, enter:
=A2*B2*C2Alternatively, use PRODUCT when the values are in one continuous range. With 2 in A2, 3 in A3, and 4 in A4, enter the following in B2; it returns 24. PRODUCT can accept a range as an argument, which is convenient when there are many factors.
With the factors in A2:A4, enter:
=PRODUCT(A2:A4) -
Multiply each row in a list. For a quantity-and-price table, put quantities in A2:A6 and prices in B2:B6. Select C2, enter the formula below, and press Enter. With 3 in A2 and 4 in B2, C2 displays 12. Select C2 again, point to the small square at its bottom-right corner (the fill handle), and drag it down to C6. Excel adjusts the row references for each copied formula, so C3 uses A3 and B3, C4 uses A4 and B4, and so on.
With the quantity in A2 and the price in B2, enter in C2:
=A2*B2For a long list, you can double-click the fill handle instead of dragging. Excel typically fills down to match the adjacent continuous data. Check the last filled row to make sure it reaches the end of your table. In Excel for the web and Excel for Mac, the same formula and fill-handle approach work, though the ribbon layout can vary slightly.
-
Keep one factor fixed while copying a formula. If every row should be multiplied by the same rate stored in B1, use dollar signs to make B1 an absolute reference. With 12 in A2 and 1.15 in B1, enter the formula in C2; it returns 13.8. Copy it down and the A-row reference changes, while B1 stays fixed.
With a value in A2 and the fixed factor in B1, enter in C2:
=A2*$B$1The dollar signs lock both the column and row in B1. In Excel for Windows, while editing a cell reference in the formula bar or formula, pressing F4 cycles through reference styles. On a Mac, the keyboard shortcut can depend on the keyboard and Excel settings; you can also type the dollar signs yourself.
-
Format the result if it represents a measured or monetary value. Multiplication returns a numeric result; formatting changes how that result is displayed, not the underlying calculation. Select the result cells and use Home > Number Format to choose a suitable format, such as Number, Currency, or Percentage. Use a format that matches what the values mean, and check decimal places if the displayed result appears rounded.
Common Mistakes
- Using x instead of *. Excel formulas require the asterisk for multiplication. Typing something like A2xB2 will not multiply the cells. Start a formula with = and place * between the values or references.
- Forgetting the equals sign. Without = at the beginning, Excel may treat the entry as text instead of calculating it. If the formula is displayed exactly as typed, check the first character and the cell’s number format.
- Using the wrong cell references. A formula can calculate successfully and still use the wrong row or column. Compare the references with the intended inputs, particularly after copying formulas. For a fixed value, use an absolute reference such as $B$1 rather than B1.
- Multiplying text that looks like a number. Values imported from another program may be stored as text. A leading apostrophe or spaces can also prevent Excel from treating an entry as numeric. Check whether the value is left-aligned unexpectedly or has a warning indicator, then convert it to a number.
- Confusing a displayed rounded value with the stored result. A cell may show 12.3 while containing more decimal places. Increase the displayed decimal places or inspect the formula bar before deciding that the multiplication is wrong.
Tips
- Use cell references for repeatable work. A formula linked to input cells updates when those inputs change. This is easier to maintain than typing every factor directly into the formula.
- Add descriptive column headings. Labels such as Quantity, Unit price, and Total make a worksheet easier to review and help you spot when a formula points at the wrong column.
- Check one result by hand. For a small sample, calculate one row independently. If 6 items cost 9 each, the expected product is 54. Comparing that with Excel’s result can reveal a misplaced reference or unexpected input.
- Use PRODUCT for a range of factors. It is often clearer than a long chain of asterisks when multiplying many cells. Remember that a blank cell in a referenced range is treated as zero by PRODUCT, so a blank factor can make the result zero. Confirm that blanks are intentional.
- Keep formulas consistent down a table. After filling a formula down, inspect a few rows—including the last one. If a row was skipped or the adjacent data contains a blank, double-clicking the fill handle may stop earlier than expected.
- Separate calculation from presentation. Keep the underlying number and formula intact, and use number formatting for currency symbols, decimal places, or thousands separators. Do not type a currency symbol into a numeric input if you can apply a currency format instead.
Troubleshooting
- The cell shows the formula instead of the answer. Confirm that the entry begins with = and that the cell is not formatted as Text. Change the format to General or Number, then re-enter the formula: select the cell, press F2, and press Enter. If Show Formulas is enabled, turn it off from Formulas > Show Formulas, or use Ctrl+` on Windows. The ` key is usually near the top-left of the keyboard; Mac keyboards and shortcuts can differ.
- The result is #VALUE!. One of the referenced cells may contain text or an incompatible value. Check each factor individually, remove stray spaces or apostrophes, and convert numeric text to numbers. If a number came from an import, retyping it in a blank cell can help identify whether the original entry was stored as text.
- The answer is zero or unexpectedly small. Look for a blank cell in a PRODUCT range, a zero among the factors, or a reference that points to the wrong cell. Select the formula cell and review the colored outlines Excel shows around referenced cells. Check whether a factor is stored as a percentage or decimal different from what you intended.
- The formula does not update after an input changes. Check Formulas > Calculation Options and select Automatic if the workbook is set to Manual. You can also press F9 to recalculate in Windows. In Excel for Mac, use Formulas > Calculate Now if needed; on the web, recalculation is generally automatic.
- A copied formula repeats the same answer. Look for dollar signs locking a reference that should change, or confirm that the fill handle copied the formula rather than only the cell’s formatting. Select a few result cells and compare their formulas; ordinary relative references should advance one row at a time.
Frequently Asked Questions
What symbol do I use to multiply in Excel?
Use the asterisk (*). Put it between numbers or cell references in a formula that starts with an equals sign.
Can I multiply a whole column by one number?
Yes. Enter the number in a cell, use an absolute reference for that cell in the first row’s formula, and fill the formula down. For example, lock the factor cell with dollar signs so it stays fixed as the row reference changes.
How do I multiply a range of cells?
Use PRODUCT with the range as its argument. It multiplies the numeric values in the referenced range. Check for blanks, because a blank cell in a range is treated as zero by PRODUCT.
Can Excel multiply cells from different worksheets?
Yes. In the formula, use a sheet name followed by an exclamation mark before the cell reference. If the sheet name contains spaces, Excel encloses the name in single quotes. You can also build the reference by typing =, selecting the other worksheet and cell, then completing the formula with * and the second factor.
Why does my multiplication result look rounded?
The cell may be displaying fewer decimal places than the stored result. Select the cell and use Home > Increase Decimal to show more digits, or inspect the formula bar. Formatting changes the display, not the calculated value.
Do these multiplication formulas work in Excel for Mac and Excel for the web?
Yes. The asterisk operator, cell references, absolute references, and PRODUCT work in those versions too. Ribbon placement and some keyboard shortcuts can differ, but you can enter the same formulas.
Related
- Group and Ungroup in Excel with Keyboard Shortcuts
- Freeze X and Y Panes in Excel for the Web: Step-by-Step
- How to Freeze the Top Row in Excel While Scrolling
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- How to Make Excel Sort Dates Correctly, Oldest FirstTo make Excel sort dates correctly, first ensure the date cells contain real Excel dates rather than text,…
- How to Filter Subtotals in Excel by Group or TotalTo show subtotal rows without their detail rows, use the outline buttons Excel creates with Data > Subtotal,…
- How to Filter Within a Filter in ExcelTo filter within an existing Excel filter, leave the first filter in place and apply another filter from…
- COUNTIF Function Examples in ExcelIn Excel for Microsoft 365, COUNTIF counts cells in a range that satisfy one condition. With statuses in…
- Excel Date Calculation Methods and FormulasIn Excel, calculate dates by adding or subtracting dates and day counts, or use functions such as DATE,…
- How to Sort Dates in Excel Without Splitting RowsTo sort dates in Excel, select a cell in your data, open Data > Sort, choose the date…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.