Excel Multiply Formula Not Working? Fix Common Causes

Errors & fixes · Updated November 19, 2026

If an Excel multiplication formula is not working, first check that it uses the asterisk (*) between valid cell references, then confirm the referenced cells contain numbers and Excel is calculating automatically. For example, with a quantity in A2 and a price in B2, enter =A2*B2 in C2; if A2 is 4 and B2 is 12, the result should be 48.

How Excel multiplication works

Excel uses the asterisk for multiplication. The letter x and the multiplication symbol × are not substitutes in a standard worksheet formula. You can multiply numbers directly, multiply cell references, or combine both approaches. Cell references are usually preferable because changing an input updates the result without editing the formula.

With a quantity in A2 and a unit cost in B2, enter =A2*B2 in C2. If A2 contains 4 and B2 contains 12, C2 returns 48. If you need to multiply more than two values, use the asterisk between each reference. With values in A2, B2, and C2, enter =A2*B2*C2 in D2; if the values are 2, 3, and 5, D2 returns 30.

Excel also has the PRODUCT function, which multiplies the values in its arguments. With numbers in A2:A4, enter =PRODUCT(A2:A4) in B2. If A2, A3, and A4 contain 2, 3, and 5, respectively, the result is 30. For a simple multiplication, the asterisk is usually easier to read; PRODUCT can be convenient for a range of cells.

Check the formula entry and cell references

Start by selecting the result cell and looking at the formula bar. A formula must begin with an equals sign. Check for a missing asterisk, a typo in a cell address, an extra character, or a reference to the wrong row. If you copied a formula down a column, Excel normally adjusts relative references automatically, which is useful for row-by-row calculations but can be a problem when one input should stay fixed.

For example, suppose each row has a quantity in column A and a price in column B. A formula copied from C2 to C3 should change its references from row 2 to row 3. But if every row should use a tax rate stored in B1, that reference needs to be fixed with dollar signs. With quantities in A2:A10, tax rate in B1, and a pre-tax amount in C2, enter =C2*$B$1 in D2 and fill it down. The B1 reference stays fixed while C2 changes to C3, C4, and so on. If C2 is 100 and B1 is 0.1, D2 returns 10.

Also check whether a reference includes the intended cells. A formula can calculate without an error and still give the wrong answer if it points to a neighboring cell or omits an input. Click each reference in the formula bar to see which cell Excel highlights.

Numbers stored as text

A common reason multiplication fails is that one or both inputs look like numbers but are stored as text. This can happen after importing a CSV file, copying data from a website, or entering a leading apostrophe. A cell formatted as Text can also cause newly entered digits to be treated as text. Changing the display format to Number does not necessarily convert text that is already in the cell.

Look for a green triangle in the cell corner or an error-checking icon. If Excel offers Convert to Number, use that option for the affected cells. You can also select the cells and choose Data > Text to Columns, then select Finish to make Excel reinterpret many text-formatted numbers. Check the results afterward, especially if the data contains dates or unusual separators.

For a single value that is numeric text, a helper formula can convert it. With the text value in A2, enter =VALUE(A2) in B2. If A2 contains the text 12, B2 returns the number 12, which can then be used in arithmetic. Conversion depends on Excel’s regional settings: decimal and thousands separators in imported data must match what Excel recognizes. Leading or trailing spaces and nonbreaking spaces can also interfere, so inspect suspicious source data rather than assuming every text value will convert cleanly.

Formula appears as text instead of a result

If the cell displays the characters of the formula instead of its answer, check the cell format and the way the formula was entered. A leading apostrophe, such as one used to preserve text, prevents Excel from evaluating the entry as a formula. A cell formatted as Text before the formula was typed can have the same effect.

Select the affected cell and change its number format to General using Home > Number Format. Then press F2 and Enter to make Excel re-evaluate the existing entry. On a Mac, use Control+U to edit the selected cell, then press Return. Alternatively, delete the entry, set the cell to General, and type the formula again. Simply changing the format may not be enough until the formula is re-entered or confirmed.

If many cells show formulas rather than results, the Show Formulas view may be enabled. In Excel for Microsoft 365 on Windows, use Formulas > Show Formulas to switch back to results. The Windows shortcut is Ctrl+`; on Mac, the shortcut is Control+`. The displayed formulas are not necessarily broken—the worksheet may simply be showing them instead of their calculated values.

Calculation mode and stale results

A correct formula may appear not to update when the workbook is set to manual calculation. In that mode, Excel waits for a recalculation command instead of recalculating every dependent formula after an input changes. Open Formulas > Calculation Options and select Automatic. In Excel for Mac, use Formulas > Calculation Options > Automatic as well.

To recalculate the current workbook manually, press F9 on Windows. On Mac keyboards, use Fn+F9 if the function keys are assigned to hardware controls. Shift+F9 recalculates the active worksheet in Windows; the Mac equivalent may also require Fn, depending on the keyboard settings. These shortcuts are useful for diagnosis, but setting the workbook to Automatic is the normal fix if results should update as values change.

Calculation mode can be affected by other workbooks open in the same Excel session, so check the setting rather than assuming a particular workbook is responsible. If a formula updates after pressing F9, but not when its inputs change, calculation mode is a strong possibility. If it still does not update, confirm that the formula actually refers to the cells you changed.

Errors, blanks, and unexpected results

Excel’s error value often points toward the cause. #VALUE! commonly indicates that an operand is text or another unsuitable value. Check both input cells, including values that appear numeric but were imported as text. #REF! means a formula contains an invalid reference, often because a referenced row, column, or cell was deleted. Edit the formula to point to the correct cells.

#NAME? can appear when Excel does not recognize part of an entry, such as a misspelled function name or text that should have quotation marks. Multiplication by itself does not require a function name, so check that the operator and references are typed correctly. If the result is zero, inspect the inputs for blank cells or actual zero values; multiplying any value by zero returns zero.

A displayed result that looks wrong is not always a calculation error. A narrow column can show number signs (#####) because the value does not fit; widen the column by dragging its right boundary or double-clicking that boundary to AutoFit. A result cell formatted as Date or Percentage can also display a numerical result in a surprising way. Select the cell and try Home > Number Format > General or Number, then check the underlying value in the formula bar.

Order of operations and copying formulas

Excel follows the usual order of operations: multiplication is performed before addition and subtraction unless parentheses specify otherwise. This matters in formulas that combine calculations. With values in A2, B2, and C2, =A2+B2*C2 adds A2 to the product of B2 and C2. If A2 is 10, B2 is 3, and C2 is 4, the result is 22. To add A2 and B2 first and then multiply by C2, enter =(A2+B2)*C2 in D2; the same inputs return 52.

When filling a formula through a table, inspect the first few results to make sure references shift as intended. Select the cell and drag the fill handle—the small square at its lower-right corner—or copy and paste it. A fixed reference such as $B$1 remains unchanged; a relative reference such as A2 adjusts. Mixed references, such as $A2 or A$2, lock only the column or row. This distinction helps explain formulas that work in the first row but produce unexpected results farther down.

A quick troubleshooting sequence

Work through these checks in order; they distinguish a broken formula from a display or data problem:

  • Select the result cell and confirm the formula begins with an equals sign and uses an asterisk for multiplication.
  • Click or inspect each referenced cell. Confirm the references point to the intended inputs and that the inputs are numeric values rather than text.
  • Check the result cell’s format. Use General or Number if it is displaying a date, percentage, or an overflow of number signs.
  • If the formula itself is visible, check for Text format, a leading apostrophe, or the Show Formulas setting.
  • If inputs change but the answer stays the same, set calculation to Automatic or recalculate with F9.
  • Read any error value, then repair the specific issue: text input, invalid reference, or incorrect formula entry.

This order is practical because it checks the formula, its inputs, the display, and recalculation separately. Avoid replacing a correct formula with a more complicated one before checking the input types and cell references; those are frequent causes of a multiplication result that seems inexplicable.

Frequently Asked Questions

Why does Excel show the multiplication formula instead of the answer?
Usually the cell is formatted as Text, the entry starts with an apostrophe, or Show Formulas is enabled. Set the cell to General, re-enter or confirm the formula, and check Formulas > Show Formulas.

Why does Excel return #VALUE! when I multiply two cells?
One of the cells may contain text, an unrecognized separator, or other nonnumeric content. Check both inputs, convert numeric text to numbers, and remove unwanted spaces where appropriate.

Why is my multiplication result not changing?
Check Formulas > Calculation Options and select Automatic. If calculation is already automatic, confirm that the formula references the input cell you edited.

Can I use x or × instead of an asterisk?
No. For ordinary worksheet multiplication, use the asterisk operator between numbers or cell references. The letter x and the × symbol are not the standard multiplication operator in an Excel formula.

Why does Excel show ##### for my multiplication result?
The column may be too narrow to display the value, or the cell’s number format may not suit it. Widen the column and check the cell’s number format before changing the calculation.

Should I use PRODUCT or the asterisk?
Use the asterisk for clear, short calculations involving a few values. PRODUCT is useful when multiplying a range or several arguments, but neither choice fixes text-formatted inputs or incorrect references; those need to be corrected separately.

Related

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

More in Errors & fixes

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

Spotted an error in this guide? Let us know.