To multiply in Excel, use the asterisk (*) between values or cell references—for example, if A2 contains 6 and B2 contains 4, enter =A2*B2 in another cell to return 24. For multiplying several values or a range, Excel also provides the PRODUCT function.
The basic Excel multiplication formula
The multiplication operator in Excel is the asterisk, not the letter x and not the multiplication sign ×. A formula must start with an equals sign, so type the equals sign, the first value or cell reference, an asterisk, and the next value or reference. Press Enter to calculate the result.
For example, with the number 6 in A2 and 4 in B2, enter =A2*B2 in C2. Excel displays 24. The formula uses the values in the cells, so changing either input updates the result automatically. You can also multiply numeric constants directly: with no particular cell layout needed, =6*4 returns 24, although references are usually more useful in a working spreadsheet because the inputs can be edited separately.
Multiplication can be combined with other arithmetic in one expression. Excel follows the usual order of operations: multiplication is performed before addition and subtraction, while parentheses let you control the order. If a calculation has a specific sequence, use parentheses to make it clear rather than relying on an assumption about how the expression should be read.
Multiply two cells or a row of values
For a row-by-row calculation, put the inputs in two columns and place a multiplication formula beside them. With quantities in A2:A4 and unit prices in B2:B4, enter =A2*B2 in C2. If A2 is 3 and B2 is 5, the result in C2 is 15. Copy the formula down to C3 and C4 to calculate the remaining rows.
When copied down, Excel adjusts ordinary cell references relative to the new row: the formula in C3 refers to A3 and B3. You can drag the small square at the bottom-right corner of the selected formula cell (the fill handle) down the column. Double-clicking the fill handle often fills down alongside a neighboring column of data. Check the last few rows after filling, especially if there are blank rows or the data columns are different lengths.
This approach is useful for line totals, such as quantity multiplied by price, hours multiplied by an hourly rate, or units multiplied by a conversion factor. Keep the inputs in separate cells and label the columns. That makes it easier to audit the calculation and update assumptions without rewriting formulas.
Use PRODUCT to multiply several numbers
PRODUCT is Excel’s built-in function for multiplying numbers. It can take individual values, cell references, or ranges as arguments. For example, with 2 in A2, 3 in A3, and 4 in A4, enter =PRODUCT(A2:A4) in B2; the result is 24. A range argument is convenient when you need to multiply a sequence of cells.
You can also use individual cell arguments. With 2 in A2, 3 in B2, and 4 in C2, enter =PRODUCT(A2,B2,C2) in D2 to return 24. The comma separates arguments in standard English-language Excel settings. In some regional settings, Excel uses a different list separator, so a formula copied from another computer may need its separators adjusted.
For only two values, the asterisk is often easiest to read. PRODUCT becomes more useful when there are many values or when the cells form a range. Both methods multiply; choose the version that makes the calculation easiest for another person to understand.
Multiply by a fixed number or factor
To multiply each value by one fixed factor, enter that factor in its own cell and use an absolute reference so it stays fixed when the formula is copied. For example, with the factor 1.1 in B1 and values in A2:A4, enter =A2*$B$1 in C2. If A2 contains 50, C2 returns 55. Copying the formula down changes A2 to A3 or A4, but the dollar signs keep the reference pointed at B1.
The dollar signs mark an absolute reference. A reference such as B1 normally changes when copied to another location; $B$1 locks both the column and row. You can also lock only one part of a reference, but the fully locked version is common when a single rate or multiplier applies to a whole column. The factor cell should have a clear label, such as Multiplier or Rate, so its purpose is apparent.
A fixed number can also be typed directly into a formula. With the value 8 in A2, enter =A2*15 in B2 to return 120. That is quick for a one-off calculation, but placing 15 in a labeled cell is easier to maintain if the factor might change later.
Calculate percentages with multiplication
Excel stores a percentage as a decimal value for calculations: 8% is equivalent to 0.08. If A2 contains 50 and B2 contains 8% as a percentage, enter =A2*B2 in C2. The result is 4, which is 8% of 50. Format B2 as a percentage if you want it to display as 8% rather than 0.08.
To add a percentage increase to an original amount, multiply the original by one plus the rate. With 50 in A2 and 8% in B2, enter =A2*(1+B2) in C2. The result is 54: the original 50 plus an increase of 4. Parentheses matter here because they ensure Excel multiplies by the combined factor 1.08.
To calculate a decrease, the corresponding structure is one minus the rate. With 50 in A2 and 8% in B2, enter =A2*(1-B2) in C2; the result is 46. These are general arithmetic examples, not guidance about any particular tax, price, or financial product. Confirm the applicable rate and rules from an appropriate source for real-world decisions.
Multiply and add a set of products
Sometimes the task is not to multiply every value together, but to multiply matching pairs and then add those products. SUMPRODUCT is designed for this kind of calculation. For example, suppose A2:A4 contains quantities 2, 3, and 4, and B2:B4 contains prices 5, 2, and 1. With that layout, enter =SUMPRODUCT(A2:A4,B2:B4) in C2. The result is 18: 2×5 + 3×2 + 4×1.
SUMPRODUCT is useful for weighted totals, line-item totals, and similar calculations where corresponding positions in ranges should be multiplied and summed. The ranges should have matching dimensions so Excel can pair their entries as intended. It does not return the product of all values in a range; PRODUCT does that. The names are similar, but the operations answer different questions.
For a small calculation, separate row formulas followed by a sum may be easier to inspect. For a larger table, SUMPRODUCT can make the calculation compact. If the logic is important, document the column meanings and consider showing intermediate results so readers can verify the calculation.
Common multiplication problems and fixes
- The formula displays as text: Check that the cell is not formatted as Text and that there is no apostrophe before the equals sign. Change the cell to a suitable number format, then edit and re-enter the formula so Excel evaluates it.
- The result is zero or unexpectedly small: Check whether one of the referenced cells contains zero, a blank, or a value that looks numeric but is stored as text. Verify the input cells and their number formats; formatting alone does not always convert text into a number.
- Excel shows #VALUE!: One or more inputs may contain text that cannot be used in the arithmetic, or a reference may point to an unexpected cell. Inspect the referenced cells and remove unintended text or correct the reference.
- The copied formula uses the wrong factor: If the multiplier should remain in one cell, make that reference absolute with dollar signs before filling the formula down.
- The result looks incorrect but the formula is right: Cell formatting can hide decimal places or display a value as currency or a percentage. Select the result cell and review its number format and displayed precision.
Also check the formula bar when a result is surprising. The displayed value may be rounded for presentation while the underlying calculation retains more precision. If you need a rounded value for a defined purpose, use an appropriate rounding method deliberately; changing the display format alone does not change the stored calculation.
Choose between the asterisk and PRODUCT
Use the asterisk when multiplying a couple of values, especially when the formula expresses a familiar relationship such as quantity times price. Use PRODUCT when the inputs are numerous, are listed in a range, or when its function form makes the intent clearer. For a total of matching quantity-and-price products, use SUMPRODUCT rather than PRODUCT.
Neither method is inherently more accurate for ordinary multiplication. The best choice is the one that matches the calculation and is easiest to maintain. Avoid writing every input as a hard-coded number if those values are likely to change; cell references help keep assumptions visible and reduce the chance of missing an update.
For troubleshooting, select the formula cell and inspect the formula bar, then check each referenced input. Confirm that the formula begins with an equals sign, uses an asterisk for multiplication, and points to the intended cells. If you share the workbook, clear labels and consistent formats make the calculation easier to review.
Frequently Asked Questions
What symbol do I use to multiply in Excel?
Use the asterisk (*). It appears on many keyboards as Shift+8, though the exact key can depend on the keyboard layout. Excel does not use the letter x as its multiplication operator in a formula.
How do I multiply an entire column by one number?
Put the number in a cell, make its reference absolute with dollar signs, and multiply each row’s value by that fixed reference. Enter the first row’s formula, then use the fill handle to copy it down. Check that the reference to the fixed number stays unchanged.
Can I multiply cells without using PRODUCT?
Yes. Use the asterisk between cell references. It is usually the clearest option for two cells. PRODUCT is an alternative function, especially useful for multiplying several cells or a range.
Why is my multiplication formula showing zero?
Check whether an input is actually zero or blank, whether a referenced cell is the one you intended, and whether values that look numeric are stored as text. Also inspect the formula bar and the number format of the result cell.
What is the difference between PRODUCT and SUMPRODUCT?
PRODUCT multiplies its supplied numbers together. SUMPRODUCT multiplies corresponding values in ranges and adds those individual products. For example, use SUMPRODUCT for a total made from quantities times matching prices, not for multiplying every number into one combined product.
Related
- Excel Format as Number: Steps and Common Fixes
- Excel Format by Number Range with Conditional Formatting
- Excel Find and Delete Text: Replace, Clear, or Remove
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- COUNTIF in Excel: How It Works and ExamplesIn Excel, COUNTIF counts cells in a range that meet one condition. Its syntax is =COUNTIF(range, criteria); for…
- Excel Formula for a List of Numbers: 10 Useful OptionsTo create a list from 1 to 10 in Excel, enter =SEQUENCE(10) in an empty cell; it spills…
- Excel Compare Duplicates Between Two Sheets: FormulasTo compare values in two Excel sheets, enter a formula beside the first list and check whether each…
- Can You Sort Excel by Color? Steps and TipsYes. In Excel for Microsoft 365 on Windows, select your data and choose Data > Sort, then set…
- Rank in Excel by Multiple Criteria: Formulas and TipsWith primary scores in B2:B5, secondary scores in C2:C5, and a third tie-breaker in D2:D5, enter this in…
- Excel Days Until End of Month: Formula and ExamplesWith no input cells needed, enter =EOMONTH(TODAY(),0)-TODAY() to calculate the number of days from today to the last…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.