How to Multiply in Excel: 8 Methods That Save Real Time

Method 1: The Asterisk Operator (Fastest for Two Cells)

The asterisk (*) is the multiplication operator in Excel. It works inside any formula, just like a plus or minus sign. The forward slash (/) is the counterpart used to divide numbers, and the percentage symbol (%) handles ratios. All of basic math sits on the same row of the keyboard, which is what makes it so quick to multiply numbers in cells without reaching for the mouse.

When you want to multiply two cells, the steps are:

1. Click the new cell where the answer should appear.
2. Type = to start the formula.
3. Click the first cell (or type its reference, such as A2).
4. Type *.
5. Click the second cell (or type B2).
6. Press Enter.

A formula like =A2*B2 returns the product instantly. The asterisk also works on raw numbers (=15*8), mixed cells and numbers (=A2*1.07), and any combination chained together for three cells or more (=A2*B2*C2).

This is the most common multiplication formula in daily spreadsheet work. It wins for one-off jobs such as finding a single price including tax, doubling a quantity, or working out a bonus payout on the fly. When the task is small and only a single cell needs the answer, the asterisk is hard to beat.

Method 2: The PRODUCT Function (For Long Ranges)

The PRODUCT function is the dedicated multiply function in Excel. It multiplies all the numbers in a range with a single formula, which saves typing when more than three or four cells need to be multiplied together. To multiply multiple cells across a row or column, the PRODUCT function does the heavy lifting in one step.

To insert PRODUCT through the ribbon:

1. Click the destination cell.

2. Open the Formulas tab on the ribbon.

3. Click Math & Trig.
4. Scroll down and select PRODUCT.
5. In the dialog, drag across the range to multiply (for example, A1:A10).
6. Click OK.

Or type the following formula directly: =PRODUCT(A1:A10).

PRODUCT also accepts multiple ranges and individual cells separated by commas. The formula =PRODUCT(A1:A5, C1:C5, 2) multiplies all the cells in both ranges and then doubles the result. This makes it a clean choice when multiple values from different cells need to combine in one formula.

A useful detail that catches people out: PRODUCT ignores empty cells and cells containing text. The asterisk operator does not. If a range has gaps or stray labels, the PRODUCT function will still return a clean answer where A1*A2*A3 would throw a #VALUE! error. Excel treats blank cells inside PRODUCT as if they were not there, which is exactly what most users want.

Method 3: Paste Special > Multiply (Apply One Number to a Whole Range)

Paste Special > Multiply is the unsung hero of bulk price changes, currency conversions, and percentage adjustments. It multiplies an existing range of cells by a single value, no formula required. The same number gets applied to every selected cell in place.

To multiply a column of prices by 1.10 (a 10% price increase):

1. Type 1.10 into any blank cell.
2. Copy that cell with Ctrl + C.
3. Select the range of prices to update.
4. Right-click the selection and choose Paste Special.
5. Under Operation, click Multiply.
6. Click OK.

Every cell in the selection gets multiplied by 1.10. The original values are gone and the new values stay as plain numbers, not formulas. The blank cell with 1.10 can then be deleted.

This method works equally well to multiply values for currency conversions (multiply by an exchange rate), unit conversions (multiply by 2.54 to turn inches into centimeters), and applying flat discounts (multiply by 0.85 for a 15% reduction). The same result could be achieved with a helper column and a formula, but Paste Special skips that step entirely.

A faster keyboard route to the same dialog: Ctrl + Alt + V.

Method 4: SUMPRODUCT (Multiply Columns and Add in One Step)

The SUMPRODUCT function multiplies two or more arrays cell by cell and then adds the results. Sales and finance teams use it constantly for data analysis. The function answers the classic spreadsheet question "What is the total revenue from this list of items and quantities?" with a single formula.

Imagine column A holds quantities and column B holds unit prices for ten products. The total revenue formula is:

=SUMPRODUCT(A2:A11, B2:B11)

=SUMPRODUCT(A2:A11, B2:B11)

The provided C# code appears to be a formula from a spreadsheet application like Excel, rather than C# code. If you intended to convert a C# code snippet, please provide the correct C# code. If this is indeed a formula, it doesn't directly translate to VB.NET as it's not a programming construct. Please clarify your request if needed.

That formula multiplies each quantity in column A by its matching price in column B and sums the result across all the cells. No helper column required, no array formulas needed.

SUMPRODUCT scales to any number of arrays. Three columns of data become =SUMPRODUCT(A2:A11, B2:B11, C2:C11). The function also handles conditional logic when combined with comparison expressions, which is why analysts working with a large data set tend to keep it close at hand. It does the heavy lifting that older array formulas used to require.

Method 5: The Fill Handle (Apply One Formula to a Whole Column)

Once one multiplication formula is written, the fill handle copies it down a whole column in one motion. Excel makes this fast through a small visual cue at the corner of every selected cell.

To fill a multiplication formula down:

1. Write the formula in the first cell of the new column, such as =A2*B2 in cell C2.
2. Click C2 to select it.
3. Hover over the small green square at the lower right corner of the cell.
4. Double click the small square. Excel fills the formula down to match the length of the adjacent data, all the way to the last cell of the data set.

Excel updates the cell references automatically as the formula moves down. Row 3 becomes =A3*B3, row 4 becomes =A4*B4, and so on. The column letter stays the same; the row number changes. This behavior is called a relative reference, and it is what lets one formula multiply rows of data without rewriting anything.

To keep one cell fixed while the rest move, add dollar signs: =A2*$B$2 will always multiply by B2, even when the formula is dragged or copied to other cells. This absolute reference trick is essential when applying a single tax rate or commission percentage to a whole row of values or a whole column of items. Pressing F4 while editing a formula cycles through the absolute, relative, and mixed reference styles.

The fill handle also works horizontally. Drag right instead of down to apply the same formula across columns rather than rows.

Method 6: Multiplying by a Percentage in Excel

Working with a percentage in Excel causes more confusion than almost any other math operation. The trick is to remember that Excel treats percentages as decimals under the hood. When a cell shows 15%, the underlying value is 0.15.

To calculate 15% of 200:

=200*15%

=200*15%

Or with a cell reference where A2 contains 200:

=A2*15%

=A2*15%

Both return 30. The percentage symbol tells Excel to divide by 100, so 15% and 0.15 produce the same result.

To increase a value by a percentage (such as adding sales tax), multiply by 1 plus the rate: =A2*1.08 adds 8% tax. To decrease, subtract from 1: =A2*0.92 applies an 8% discount. The above example pattern handles tip calculators, markup pricing, and discount tables with one short formula.

Method 7: The POWER Function (For Exponents)

POWER raises a number to an exponent, which is repeated multiplication of the same number. It earns a place on this list because compound growth, area calculations, and engineering formulas all rely on it. A few numbers chained together with the asterisk works for small exponents, but POWER scales cleanly to any size.

Syntax: =POWER(number, power).

To raise 5 to the 3rd power (5 × 5 × 5 = 125):

=POWER(5, 3)

=POWER(5, 3)

`Math.Pow(5, 3)`

The same result comes from the caret operator: =5^3. Either works for multiplying numbers in Excel that need an exponent.

For compound interest projections, POWER is faster than chained multiplication. A $1,000 investment growing at 5% per year for 10 years becomes:

=1000*POWER(1.05, 10)

=1000*POWER(1.05, 10)

That returns approximately $1,628.89.

Method 8: VBA Macro (For Repeating Tasks)

Spreadsheets that go through the same multiplication routine every week become a candidate for a VBA macro. A small block of code can multiply a column, format the result, and move on without touching the formula bar. For repetitive common tasks, the macro does the heavy lifting once and then runs with a single click.

To open the VBA editor: press Alt + F11.

A simple macro that multiplies every value in column A by 1.10 looks like this:

Sub MultiplyColumn()
    Dim cell As Range
    For Each cell In Range("A1:A100")
        If IsNumeric(cell.Value) And cell.Value <> "" Then
            cell.Value = cell.Value * 1.1
        End If
    Next cell
End Sub

Sub MultiplyColumn()
    Dim cell As Range
    For Each cell In Range("A1:A100")
        If IsNumeric(cell.Value) And cell.Value <> "" Then
            cell.Value = cell.Value * 1.1
        End If
    Next cell
End Sub

Sub MultiplyColumn()
    Dim cell As Range
    For Each cell In Range("A1:A100")
        If IsNumeric(cell.Value) AndAlso cell.Value <> "" Then
            cell.Value = cell.Value * 1.1
        End If
    Next cell
End Sub

Run the macro with F5 or assign it to a button on the ribbon. The values in the entire column from A1:A100 will increase by 10%.

VBA is heavier than the previous methods. It earns its place when a multiplication task repeats often enough that even Paste Special starts to feel slow.

Common Issues and Troubleshooting

Multiplication looks simple until something breaks. The fixes below cover roughly 90% of the questions that come up in daily spreadsheet work, and treating each one as a learning experience saves time the next round.

#VALUE! error after multiplying. This almost always means one of the cells contains text rather than a number. Numbers stored as text often appear left-aligned or have a small green triangle in the corner. Click the cell, look for the warning icon, and choose Convert to Number.

The result shows zero when it should not. Check whether either cell is empty or contains a space. Anything multiplied by zero returns zero. The PRODUCT function ignores blanks; the asterisk operator does not.

The formula text appears in the cell instead of a number. The cell is formatted as Text. Right-click the cell, choose Format Cells, switch to General or Number, then press F2 followed by Enter to refresh the formula. Excel will then automatically update the display.

Decimal precision looks off by a tiny fraction. Excel stores numbers with 15 digits of precision. Long multiplication chains across many cells can accumulate small rounding errors. Wrap the result in ROUND to control display: =ROUND(A2*B2, 2) rounds to two decimal places.

Circular reference warning. This means the formula refers to its own cell. For example, putting =A1*2 inside cell A1. Move the formula to a different cell.

References shift when dragging a formula and the result goes wrong. Use absolute references with dollar signs ($A$2) for cells that should stay fixed as the formula copies into other cells. Press F4 while editing a formula to cycle through reference types.

Multiplication by percentage gives a tiny result. Typing 15 where 15% was intended is the usual cause. Multiplying by 15 is not the same as multiplying by 15%. Add the percentage symbol or divide by 100.

Excel says the result is too large. The maximum positive number Excel can display is roughly 9.99999999999999E+307. Anything beyond that returns #NUM!. This rarely happens in business use but can appear in scientific calculations.

Drag fill stops short of the last row. Double click on the fill handle only works when the column next to it has unbroken data. If column B has gaps, the fill stops at the first blank. Either fill those gaps or drag the small square down manually to the last cell.

For Developers: Multiplying in Excel Programmatically

For software teams that need to apply multiplication operations to Excel files outside of the desktop application, IronXL handles spreadsheet logic in C# without requiring Excel or Office Interop on the server. The library reads, writes, and computes formulas directly inside .XLSX files.

A short example that opens a workbook, multiplies two columns into a third, and saves the result:

using IronXL;
WorkBook workbook = WorkBook.Load("invoices.xlsx");
WorkSheet sheet = workbook.WorkSheets.First();
for (int row = 2; row <= 11; row++)
{
    decimal quantity = sheet[$"A{row}"].DecimalValue;
    decimal price = sheet[$"B{row}"].DecimalValue;
    sheet[$"C{row}"].Value = quantity * price;
}
workbook.SaveAs("invoices_calculated.xlsx");

using IronXL;
WorkBook workbook = WorkBook.Load("invoices.xlsx");
WorkSheet sheet = workbook.WorkSheets.First();
for (int row = 2; row <= 11; row++)
{
    decimal quantity = sheet[$"A{row}"].DecimalValue;
    decimal price = sheet[$"B{row}"].DecimalValue;
    sheet[$"C{row}"].Value = quantity * price;
}
workbook.SaveAs("invoices_calculated.xlsx");

Imports IronXL

Dim workbook As WorkBook = WorkBook.Load("invoices.xlsx")
Dim sheet As WorkSheet = workbook.WorkSheets.First()

For row As Integer = 2 To 11
    Dim quantity As Decimal = sheet($"A{row}").DecimalValue
    Dim price As Decimal = sheet($"B{row}").DecimalValue
    sheet($"C{row}").Value = quantity * price
Next

workbook.SaveAs("invoices_calculated.xlsx")

The same approach extends to PRODUCT-style range multiplication, percentage adjustments, and bulk recalculation across thousands of rows. IronXL runs on Windows, macOS, Linux, Docker, and Azure without an Excel installation, which makes it a fit for backend services that process spreadsheets at scale.

For deeper code samples covering formulas, formatting, and bulk data operations, visit the IronXL tutorials and documentation.