Multiply in Excel by a Constant Number

How-to basics · Updated November 20, 2026

To multiply a value by a fixed number in Excel, enter a formula such as =A2*3 in another cell, replacing A2 with the cell that contains your value and 3 with the constant. If you will reuse the constant for many rows, put it in a cell and lock its reference with dollar signs. You can also use Paste Special to multiply existing cells in place, but that changes the original values.

What You’ll Need

  • An Excel workbook and the values you want to multiply.
  • The constant number to use, such as 3, 0.5, or 10%.
  • A blank column or range for formula results, unless you deliberately want to change the original cells using Paste Special.

The steps below are for Microsoft Excel for Microsoft 365 on Windows. Basic formulas work in Excel for Mac and Excel for the web as well. The Paste Special operation described later is intended for the desktop app.

Step-by-Step

  1. Check the source values and choose where results should go. For example, suppose A2:A6 contains five quantities and you want to triple each one. Use an empty column, such as B, for the results. Keeping the originals in column A means you can compare the output, correct a mistake, or change the constant without having to reconstruct the source data. If your data has headings, keep the formula rows aligned with the corresponding source rows.
  2. Enter a formula for the first value. With the source value in A2 and the constant 3, click B2 and enter =A2*3. Press Enter. Excel calculates the value in A2 multiplied by 3 and displays the result in B2. For instance, if A2 contains 12, the result is 36. The asterisk is Excel’s multiplication operator; do not use the letter x. Start the formula with an equals sign so Excel evaluates it instead of treating it as ordinary text.
  3. Use a cell reference when the constant may change. Type the constant 3 into E1, for example, and use a reference to that cell in the calculation. With the original value in A2 and the constant in E1, enter =A2*E1 in B2. If A2 is 12 and E1 is 3, B2 returns 36. This version is easy to update: change E1 to 4, and the formula result recalculates to 48. However, when you copy the formula down, Excel normally adjusts both references, so E1 would shift to E2, E3, and so on.
  4. Lock the constant reference before filling down. With values in A2:A6 and the constant in E1, enter =A2*$E$1 in B2. The dollar signs make E1 an absolute reference: it stays fixed when the formula is copied. A2 remains relative, so it changes to A3 in the next row. If A2 is 12 and E1 is 3, the first result is 36; if A3 is 5, the next result is 15. To add the dollar signs, you can edit the reference in the formula bar or select the E1 reference while editing and press F4 on Windows. On a Mac, the shortcut can depend on the keyboard and system settings; typing the dollar signs directly is a reliable alternative.
  5. Copy the formula to the other rows. Select B2 and point to the small square at the lower-right corner of the selection, called the fill handle. Drag it down to B6. You can also copy B2, select B3:B6, and paste. With the absolute reference in place, each row uses its own value from column A and the same constant in E1. Review the first and last filled rows to make sure the source row changed while the constant reference stayed fixed. In Excel for Mac, dragging the fill handle works too; Excel for the web supports ordinary formulas and fill operations.
  6. Choose whether results should remain formulas or become fixed values. Formulas are usually the better choice if the source data or constant could change; Excel will recalculate the results. To keep only the current results, copy the output range, then use Home > Paste > Paste Values. This replaces the formulas with their displayed numeric results. Consider doing this only after checking the calculations, because later changes to the source values or constant will no longer update those fixed results.

You can also multiply a range by a constant without keeping a separate result column. First make a backup or duplicate the source data. Enter the constant in a blank cell and copy it. Select the cells to change, then choose Home > Paste > Paste Special. In the Paste Special dialog, choose Multiply under Operation and confirm. For example, if the copied cell contains 3 and the selected cells contain 12 and 5, the cells become 36 and 15. This operation overwrites the selected values, so use it only when that is what you intend. Excel for Mac has Paste Special options in the desktop app; the exact dialog appearance can differ. If you do not see the Multiply operation in your version, use a formula column instead. In Excel for the web, use formulas rather than relying on this desktop Paste Special operation.

Common Mistakes

  • Forgetting the equals sign. If an entry starts with a number or text instead of an equals sign, Excel may display the intended calculation as text rather than calculate it. Begin the entry with the equals sign, and check that the cell is not formatted as Text. If it is, change the format to General, then edit and re-enter the formula.
  • Using x instead of the asterisk. Excel formulas use the asterisk for multiplication. Typing a letter x between cell references will not perform multiplication.
  • Letting the constant reference move. A formula that refers to E1 without dollar signs changes that reference when filled down. If every row should use the same constant, lock both the column and row as in the absolute reference example.
  • Confusing a percentage with a percentage increase. Multiplying a number by 10% returns one tenth of that number, not the original number plus 10%. To find a 10% increase, multiply by 1.1; to find the increased amount alone, multiply by 0.1. For a 10% reduction, use 0.9 as the multiplier.
  • Overwriting the source data by accident. A formula entered directly into a cell that already contains a source value replaces that value. Use an empty output column or make a copy first. Paste Special with Multiply also changes the selected cells themselves.
  • Applying the constant to the wrong selection. Before using Paste Special, verify that the copied cell contains the intended constant and that only the desired numeric cells are selected. A selection that includes headings or unrelated figures can produce unwanted changes.

Tips

  • Use the clearest approach for the task. A direct number in a formula is convenient for a one-off calculation. A constant stored in its own cell is easier to maintain when the number might change, and a formula column preserves the original data. Paste Special is useful when you specifically want to update the stored values rather than create a calculated copy.
  • Label the constant. If E1 contains 3, add a nearby label such as Multiplier in D1. A clear label makes the workbook easier to understand later and helps prevent someone from changing the wrong cell. You can also format the constant cell with a fill color, but do not rely on color alone to explain what it does.
  • Use decimal values for fractional multipliers. A multiplier of 0.5 halves a value, while 2 doubles it. Excel also stores a percentage such as 10% as 0.1 for arithmetic. If the constant cell is formatted as a percentage, enter 10% there; the formula will multiply by one tenth.
  • Check number formatting as well as the calculation. A cell may contain a correct result but display too few decimal places, a currency symbol, or a percentage sign because of its number format. Select the result cells and use Home > Number to choose a suitable format or adjust decimal places. Formatting changes how a value appears, not the underlying multiplication.
  • Keep the result range consistent. Put the formula in the first data row and fill it down only as far as the source values go. When a table gains new rows, check that the formula is included in the new rows. Excel tables often extend formulas automatically when a calculated column is used, but verify the new result, especially if the workbook has different table settings.
  • Use a quick arithmetic check. Pick one source value and calculate it independently, then compare it with the corresponding result. This catches issues such as selecting the wrong constant or starting the formula one row too high. When working with many rows, also inspect the first and final results before sharing or replacing the source data.

Troubleshooting

The cell shows the formula rather than a result. First check whether Show Formulas is turned on; on Windows, Ctrl+` toggles this display. On a Mac, the shortcut may vary by keyboard, so check the Formulas tab for the Show Formulas command. If only one cell is affected, it may be formatted as Text or the entry may have a leading apostrophe. Set the cell to General, remove any apostrophe before the equals sign, and re-enter the formula.

The result is 0 or does not match the expected calculation. Click the source and constant cells to confirm their actual contents. A number that looks numeric may have been imported as text, or the formula may refer to a blank or different cell. Check the formula bar and trace which cell references it uses. If the source is text, convert it to a number where appropriate; changing the display format alone does not convert text into a numeric value.

Every filled row uses a different constant cell. Edit the first formula so the constant reference has dollar signs around both its column and row, then fill it down again. If results already exist, you can replace the formulas in the output range with the corrected version by filling over them. Confirm that the source reference remains relative, so each output row still uses the matching input row.

The result displays too many or too few decimal places. The calculation may be correct even if the display is rounded. Select the result cells and use the decimal-place controls on the Home tab, or open Format Cells to choose the number of decimal places. Do not round the source values unless rounding is part of the calculation you need; displayed rounding and stored precision are different.

Paste Special changed values you wanted to preserve. Immediately use Undo on Windows with Ctrl+Z or on Mac with Command+Z, if the action is still available in the undo history. If you have made further changes, restore the backup or copy of the original data. Before trying again, select only the intended numeric range and confirm the multiplier cell before choosing the Multiply operation.

Frequently Asked Questions

How do I multiply a whole column by one number?
Put the multiplier in a cell, use a formula in the first output row with an absolute reference to that multiplier, and fill the formula down alongside the source values. This keeps the original column intact and lets you change the multiplier later.

Can I multiply by a number without using another cell?
Yes. Put the number directly in the formula after the asterisk. This is quick for a calculation that will not need frequent adjustment. If the number might change, a separate constant cell is easier to update and audit.

How do I multiply by 10 percent?
Use 10% as the multiplier to calculate one tenth of a value. For example, if a value is 200, ten percent of it is 20. If you mean increase 200 by 10%, the final amount is 220, so multiply by 1.1 instead.

Can I multiply several selected cells in place?
In desktop Excel, copy a cell containing the constant, select the values, and use Home > Paste > Paste Special, then choose Multiply under Operation. This replaces the selected values. Make a copy first if you may need the originals. If that operation is unavailable, calculate results in a separate column with formulas.

Why does my formula change when I copy it down?
Excel adjusts relative references as a formula moves so that each row can use its corresponding source value. That behavior is useful for the source reference, but not for a shared multiplier. Lock the multiplier reference with dollar signs before filling the formula.

Will the result update if I change the constant?
Yes, if the result cell contains a formula referring to the constant cell. Excel recalculates it when the constant changes, provided calculation is set to Automatic. If you pasted values over the formulas, the results are fixed and will not update; restore formulas or calculate them again to reflect a new constant.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.