Multiply Key in Excel: Use the Asterisk or Formula

Formulas & functions · Updated November 20, 2026

In Excel, multiplication uses the asterisk key (*) inside a formula, not the letter x or the × symbol. Start with an equals sign, then type the values or cell references you want to multiply with an asterisk between them; for example, with no cell references needed, enter =6*7 in a cell to get 42.

Which key multiplies in Excel?

Excel does not have a separate multiplication command that you must select before entering a calculation. Its multiplication operator is the asterisk, also called a star. On many Windows keyboards, the asterisk on the number row is typed by holding Shift and pressing 8. If your keyboard has a numeric keypad, its dedicated asterisk key usually types the same character without Shift.

Keyboard layouts differ by language and hardware, so the key combination may not be identical everywhere. The important thing is the character that appears in the formula: *. On a Mac, the multiplication operator in Excel formulas is also the asterisk; use the key combination for an asterisk on your keyboard layout, or the numeric keypad’s asterisk key if available. A displayed multiplication sign, ×, is not a substitute for the formula operator.

If you type a calculation directly into a worksheet cell, begin with =. Without the equals sign, Excel may treat the entry as text rather than calculate it. You can also put the asterisk in a formula by selecting cells with the mouse while entering the formula.

How to multiply numbers in a cell

For a simple calculation, select a blank cell, type an equals sign, enter the first number, type an asterisk, enter the next number, and press Enter. With no cell references needed, the formula =8*5 returns 40. You can multiply more than two values by placing another asterisk between each value; Excel evaluates the resulting expression as a calculation.

For example, if you want to calculate the total cost of several identical items, you can multiply the unit price by the number of items. Typing numbers directly into a formula can be useful for a quick check, but referencing worksheet cells is usually easier to update. If a price or quantity changes, a formula that points to those cells recalculates automatically, while a formula containing fixed numbers must be edited by hand.

After entering a formula, the cell displays its result, while the formula itself appears in the formula bar when that cell is selected. To see formulas in worksheet cells instead of their calculated values, Excel for Windows has the Show Formulas command on the Formulas tab. This changes the worksheet display, not the underlying calculations.

Multiply values stored in cells

Suppose a worksheet has a product price in A2 and the number of items in B2. With the price in A2 and quantity in B2, enter =A2*B2 in C2 to calculate the line total. If A2 contains 12.5 and B2 contains 4, the result in C2 is 50. The formula uses cell addresses rather than the values themselves, so changing either input updates the answer.

You can multiply several references in one calculation. With a quantity in A2, a unit price in B2, and a multiplier in C2, enter =A2*B2*C2 in D2. If those cells contain 3, 10, and 1.08, respectively, the result is 32.4. This can represent, for example, a quantity multiplied by a unit amount and then by a simple adjustment factor; the formula only performs arithmetic and does not determine what the factor means.

Cell references can point to different parts of a worksheet, and you can type them or click the cells as you build the formula. To construct the price-and-quantity example using clicks, type an equals sign in C2, select A2, type an asterisk, select B2, and press Enter. Excel inserts the references for you.

Use PRODUCT for several values

The asterisk operator is the clearest choice for a small number of values. Excel also provides the PRODUCT function, which multiplies numbers supplied as arguments or found in referenced cells and ranges. With values 2, 3, and 4 in A2:A4, enter =PRODUCT(A2:A4) in another cell; the result is 24. This can be more readable than typing a long chain of cell references separated by asterisks.

PRODUCT can accept more than one range or individual value. With 2 and 3 in A2:A3 and 4 and 5 in B2:B3, enter =PRODUCT(A2:A3,B2:B3) in a blank cell. It multiplies all four values, giving 120. The comma separates arguments in standard English-language Excel settings; some regional settings use different list separators, so the separator shown by your installation may vary.

For ordinary two-cell multiplication, PRODUCT is optional: using the asterisk is shorter and makes the operation easy to recognize. PRODUCT is useful when the inputs form a range or when the formula would otherwise become a lengthy chain. In a referenced range, blank cells and text entries are ignored by PRODUCT, but a zero value makes the product zero. Check the range if the result is unexpectedly zero or smaller than expected.

Order of operations and parentheses

Excel follows standard arithmetic precedence: multiplication and division are evaluated before addition and subtraction. For example, with no cell references, =2+3*4 returns 14 because Excel calculates 3 times 4 before adding 2. If you want the addition to happen first, use parentheses; with no cell references, =(2+3)*4 returns 20.

This matters when a formula combines a multiplication with a discount, fee, or other adjustment. Do not rely on visual spacing to show what you mean: parentheses make the intended grouping explicit. A practical way to check a complicated calculation is to break it into smaller steps in separate cells, compare the intermediate results with your expectations, and then combine the steps once the logic is clear.

Excel calculates expressions using the values stored in cells, not necessarily the rounded numbers shown on screen. For instance, a cell formatted to show two decimal places may contain additional decimal places. If a multiplication result seems slightly different from a hand calculation based on displayed values, inspect the source values and number formats before assuming the formula is wrong.

Copy a multiplication formula down a column

When each worksheet row has a separate quantity and price, enter the multiplication formula in the first result row and copy it down. With quantities in A2:A10 and prices in B2:B10, enter =A2*B2 in C2. Copy C2 into C3:C10 using the fill handle, the small square at the lower-right corner of the selected cell. Excel adjusts the references for each row, so the next row uses A3 and B3.

These are relative references: their row and column positions change when the formula is copied. Sometimes one input should stay fixed. For example, if A2 contains a quantity, B2 contains a unit price, and E1 contains a fixed multiplier, enter =A2*B2*$E$1 in C2. If the three input cells contain 3, 10, and 1.1, the result is 33. The dollar signs lock the reference to E1 when you copy the formula; the references to A2 and B2 remain relative.

On Windows, while editing a formula, select a cell reference and press F4 to cycle through absolute and relative reference styles. On many Mac keyboards, the equivalent is Command+T, though function-key settings and keyboard models can affect shortcuts. You can also type the dollar signs yourself. Verify a copied formula in a later row to make sure the changing and fixed references behave as intended.

Common multiplication problems

  • The formula is displayed as text: Check that the entry begins with an equals sign. Also check whether the cell is formatted as Text; change it to General or another suitable number format, then re-enter the formula.
  • You typed x instead of an asterisk: The letter x is not Excel’s multiplication operator. Replace it with * and make sure the formula still starts with an equals sign.
  • You see an error: Check for missing cell references, unmatched parentheses, or text where a numeric value is expected. A cell that looks like a number may have been imported or stored as text.
  • The answer is zero: One of the multiplied inputs may actually be zero. Inspect the referenced cells and, when using PRODUCT, make sure the selected range does not include a zero that should not be part of the calculation.
  • The result looks rounded: The cell may only be displaying a limited number of decimal places. Use the number-format controls on the Home tab to display more decimals; changing the display format is different from changing the stored value.

Also distinguish a formula from a symbol used in a heading or explanation. If you want to show a multiplication sign as ordinary text, you can enter or paste × as text. If you want Excel to calculate a product, use the asterisk in a formula instead. This is a frequent source of confusion because the two marks look similar in written arithmetic but have different roles in a worksheet.

Excel on Mac and in a web browser

The multiplication operator and formula syntax are the same in Excel for Microsoft 365 on Windows, Excel for Mac, and Excel for the web: formulas use an equals sign and an asterisk. The physical key used to type an asterisk depends on the keyboard, not on a different Excel calculation rule. If a laptop has no numeric keypad, use the keyboard’s asterisk combination.

Excel for the web runs in a browser, so keyboard shortcuts can also be affected by the browser or operating system. You can simply click the worksheet cell and type the formula. On Windows desktop Excel, the standard Enter key confirms the entry; on a Mac, Enter or Return can confirm it depending on the keyboard and settings. The main differences are interface and keyboard behavior, not how multiplication formulas calculate.

Frequently Asked Questions

What is the multiplication symbol in Excel?
Use the asterisk, *, between values or cell references in a formula. Excel does not use the letter x or the printed × character as its multiplication operator.

How do I multiply two columns in Excel?
Put a formula in the first result row that multiplies the two cells in that row, then copy it down. For example, if the two inputs are in A2 and B2, enter =A2*B2 in C2 and fill the formula into the rows below.

Can I multiply more than two cells?
Yes. Join the references with asterisks, or use PRODUCT for a range or a longer list. Check that each referenced cell contains the intended numeric value.

Why does Excel show the formula instead of the answer?
The cell may be formatted as Text, the formula may lack its leading equals sign, or Show Formulas may be turned on. Check the cell format and the Formulas tab, then re-enter the formula if needed.

Is there a multiplication button in Excel?
There is no special worksheet button required for multiplication. Type an asterisk in a formula, or use PRODUCT when multiplying a range or a list of values.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.